PHP Classes

File: doc/db.schemaxml

Recommend this page to a friend!
  Classes of Uldis Nelsons  >  D3 BTL  >  doc/db.schemaxml  >  Download  
File: doc/db.schemaxml
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: D3 BTL
Get machine project from BTL file into a database
Author: By
Last change:
Date: 11 months ago
Size: 2,867 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">aluksne</database> </source> <canvas zoom="100"> <tables> <table name="btl_part" view="colnames"> <left>224</left> <top>27</top> <width>177</width> <height>412</height> <sql_create_table>CREATE TABLE `btl_part` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `file_data_id` int(10) unsigned NOT NULL, `type` enum('rawpart','part') DEFAULT NULL, `single_member_number` int(10) unsigned DEFAULT NULL, `assembly_number` int(10) unsigned DEFAULT NULL, `order_number` int(10) unsigned DEFAULT NULL, `designation` varchar(200) DEFAULT NULL, `annotation` varchar(200) DEFAULT NULL, `storey` varchar(200) DEFAULT NULL, `material` varchar(200) DEFAULT NULL, `group` varchar(200) DEFAULT NULL, `package` varchar(200) DEFAULT NULL, `timber_grade` varchar(200) DEFAULT NULL, `quality_grade` varchar(200) DEFAULT NULL, `count` int(5) unsigned DEFAULT NULL, `length` int(10) unsigned DEFAULT NULL, `height` int(10) unsigned DEFAULT NULL, `width` int(10) unsigned DEFAULT NULL, `colour` varchar(200) DEFAULT NULL, `uid` int(10) unsigned DEFAULT NULL, `parsed_data` text, PRIMARY KEY (`id`), KEY `fk_file_Data` (`file_data_id`), CONSTRAINT `fk_file_Data` FOREIGN KEY (`file_data_id`) REFERENCES `btl_file_data` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1</sql_create_table> </table> <table name="btl_process" view="colnames"> <left>452</left> <top>28</top> <width>104</width> <height>199</height> <sql_create_table>CREATE TABLE `btl_process` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `part_id` int(10) unsigned NOT NULL, `key` char(20) DEFAULT NULL, `parameters` text, `ident` smallint(6) DEFAULT NULL, `quality` enum('automatic','visible','fast') DEFAULT NULL, `recess` enum('automatic','manual') DEFAULT NULL, `comment` text, PRIMARY KEY (`id`), KEY `fk_part` (`part_id`), CONSTRAINT `fk_part` FOREIGN KEY (`part_id`) REFERENCES `btl_part` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=latin1</sql_create_table> </table> <table name="btl_file_data" view="colnames"> <left>54</left> <top>23</top> <width>132</width> <height>211</height> <sql_create_table>CREATE TABLE `btl_file_data` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `status` enum('processed','error','deleted') DEFAULT 'error', `file_data` text, `parsed_data` text, `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `notes` varchar(255) DEFAULT NULL, `project_name` varchar(200) DEFAULT NULL, `export_datetime` datetime DEFAULT NULL, `file_name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1</sql_create_table> </table> </tables> </canvas> </schemadesigner>