ตาราง project
CREATE TABLE `project` (
`project_number` int(11) NOT NULL,
`project_name` varchar(255) NOT NULL,
`project_des` text NOT NULL,
`revision` varchar(255) NOT NULL,
`user_name` varchar(255) NOT NULL,
`type` varchar(30) NOT NULL,
`model_no` varchar(255) NOT NULL,
`customer_no` varchar(255) NOT NULL,
`company_no` varchar(255) NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`project_number`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620;
ตาราง materials_use เพื่อเข้าดูรายละเอียดของแต่ละ project
CREATE TABLE `materials_use` (
`item` int(11) NOT NULL auto_increment,
`project_number` varchar(255) NOT NULL,
`status` varchar(255) NOT NULL,
`part_number` varchar(255) NOT NULL,
`part_id` varchar(255) NOT NULL,
`ref_design` varchar(255) NOT NULL,
`detail` text NOT NULL,
`package` varchar(255) NOT NULL,
`manufac_id` varchar(255) NOT NULL,
`mfg_part_number` varchar(255) NOT NULL,
`mfg_packaging` varchar(255) NOT NULL,
`usage` int(11) NOT NULL,
`unit` int(11) NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`item`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=14 ;
Load balance : Server 02
Quote:
