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: 9 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>
For more information send a message to info at phpclasses dot org.