yield資料表- CREATE TABLE `yield` (
- `Lot_ID` varchar(20) NOT NULL,
- `Company` varchar(60) NOT NULL,
- `Input` int(6) NOT NULL,
- `Output` varchar(6) NOT NULL,
- `Operator_ID` varchar(5) NOT NULL,
- `Percentage` float NOT NULL,
- `time_at` datetime NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `yield`
- --
- INSERT INTO `yield` VALUES ('2', 'P & E Electronic & Sound Systems Sdn Bhd', 10, '7', '4', 0.7, '2010-02-03 00:25:55');
複製代碼 ic資料表:- --
- -- Database: `lun`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `ic`
- --
- CREATE TABLE `ic` (
- `Lot_ID` varchar(20) NOT NULL,
- `Packages` varchar(20) NOT NULL,
- `Types_of_chip` varchar(10) NOT NULL,
- `Lead` tinyint(2) NOT NULL,
- `Company` varchar(60) NOT NULL,
- `Engineer_ID` varchar(5) NOT NULL,
- `time_at` datetime NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `ic`
- --
- INSERT INTO `ic` VALUES ('2', '2', 'soicn', 32, 'carsem', 'e0102', '2010-02-02 11:30:31');
- INSERT INTO `ic` VALUES ('1', '1', 'SOICW', 0, 'River Electronics Ipoh Sdn Bhd', 'c', '2010-02-03 00:13:46');
複製代碼 customer資料表:- -- Database: `lun`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `customer`
- --
- CREATE TABLE `customer` (
- `Customer_ID` varchar(10) NOT NULL,
- `Company` varchar(60) NOT NULL,
- `Phone` varchar(12) NOT NULL,
- `Email_address` varchar(255) NOT NULL,
- `Address` varchar(50) NOT NULL,
- `Admin_ID` varchar(5) NOT NULL,
- `time_at` datetime NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `customer`
- --
- INSERT INTO `customer` VALUES ('c123', 'Yamaha Electronics Manufacturing (M) Sdn Bhd', '056594456', 'carsem@hotmail.com', 'jelapang,ipoh', 'a0102', '2010-02-03 01:29:30');
- INSERT INTO `customer` VALUES ('c122', 'carsem', '', '', '', '', '0000-00-00 00:00:00');
複製代碼 user資料表:- -- Database: `lun`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `user`
- --
- CREATE TABLE `user` (
- `id` varchar(8) NOT NULL,
- `name` varchar(15) NOT NULL,
- `password` varchar(7) NOT NULL,
- `phone` int(10) NOT NULL,
- `ic` int(15) NOT NULL,
- `email` varchar(255) NOT NULL,
- `address` varchar(50) NOT NULL,
- `sex` tinyint(1) unsigned NOT NULL,
- `Admin_ID` varchar(5) NOT NULL,
- `time_at` datetime NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `user`
- --
- INSERT INTO `user` VALUES ('', 'john', '', 0, 0, '', '', 0, '', '0000-00-00 00:00:00');
複製代碼 ... |