PHP Classes

File: doc/DbSchema.schemaxml

Recommend this page to a friend!
  Classes of Uldis Nelsons   PHP Barcode and QRCode Reader and Generator   doc/DbSchema.schemaxml   Download  
File: doc/DbSchema.schemaxml
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Barcode and QRCode Reader and Generator
Generate barcodes and qrcodes for printing
Author: By
Last change:
Date: 3 years ago
Size: 3,063 bytes
 

Contents

Class file image Download
<?xml version="1.0" encoding="UTF-8"?> <schemadesigner version="6.5"> <source> <database charset="latin1" collation="latin1_swedish_ci">cewood_20200120</database> </source> <canvas zoom="100"> <tables> <table name="d3codes_code" view="colnames"> <left>575</left> <top>277</top> <width>135</width> <height>97</height> <sql_create_table>CREATE TABLE `d3codes_code` ( `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1</sql_create_table> </table> <table name="d3codes_code_record" view="colnames"> <left>312</left> <top>345</top> <width>129</width> <height>175</height> <sql_create_table>CREATE TABLE `d3codes_code_record` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `code_id` tinyint(3) unsigned NOT NULL, `series_id` tinyint(3) unsigned NOT NULL, `model_id` tinyint(3) unsigned NOT NULL, `model_record_id` int(10) unsigned NOT NULL, `sqn` int(10) unsigned NOT NULL, `full_code` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `code_id` (`code_id`), KEY `model_code_series` (`model_id`,`code_id`,`series_id`), KEY `model_fullCode` (`model_id`,`full_code`(10)), KEY `d3codes_code_record_ibfk_series` (`series_id`), CONSTRAINT `d3codes_code_record_ibfk_code` FOREIGN KEY (`code_id`) REFERENCES `d3codes_code` (`id`), CONSTRAINT `d3codes_code_record_ibfk_model` FOREIGN KEY (`model_id`) REFERENCES `sys_models` (`id`), CONSTRAINT `d3codes_code_record_ibfk_series` FOREIGN KEY (`series_id`) REFERENCES `d3codes_series` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1</sql_create_table> </table> <table name="sys_models" view="colnames"> <left>576</left> <top>492</top> <width>132</width> <height>114</height> <sql_create_table>CREATE TABLE `sys_models` ( `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `table_name` varchar(256) NOT NULL COMMENT 'Table', `class_name` varchar(256) DEFAULT NULL COMMENT 'Class', PRIMARY KEY (`id`), UNIQUE KEY `table_name` (`table_name`,`class_name`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=ascii</sql_create_table> </table> <table name="d3codes_series" view="colnames"> <left>574</left> <top>385</top> <width>135</width> <height>97</height> <sql_create_table>CREATE TABLE `d3codes_series` ( `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1</sql_create_table> </table> <table name="d3codes_code_queue" view="colnames"> <left>91</left> <top>327</top> <width>144</width> <height>97</height> <sql_create_table>CREATE TABLE `d3codes_code_queue` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `record_id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `d3codes_code_queue_ibfk_record` (`record_id`), CONSTRAINT `d3codes_code_queue_ibfk_record` FOREIGN KEY (`record_id`) REFERENCES `d3codes_code_record` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1</sql_create_table> </table> </tables> </canvas> </schemadesigner>