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: 1 month 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>

For more information send a message to info at phpclasses dot org.