Stuff
public text v1 · immutableCREATE TABLE `JOB` (
`JobNum` smallint(4) NOT NULL auto_increment,
`Job_Status` varchar(15) default NULL,
`CustNum` smallint(4) default NULL,
`CustPO` varchar(30) default NULL,
`JobDesc` varchar(30) default NULL,
`JobOrderDate` date default NULL,
`JobDeliveryDate` date default NULL,
`JobArtFilename` varchar(30) default NULL,
`JobSLSM` varchar(10) default NULL,
`JobTerms` varchar(25) default NULL,
`JobShipMethod` varchar(25) default NULL,
`JobCF1` varchar(10) default NULL,
`JobCF2` varchar(10) default NULL,
`JobCF3` varchar(10) default NULL,
`JobCF4` varchar(10) default NULL,
`JobCF5` varchar(10) default NULL,
`JobCF6` varchar(10) default NULL,
`JobCF7` varchar(10) default NULL,
`JobCF8` varchar(10) default NULL,
`JobCB1` varchar(10) default NULL,
`JobCB2` varchar(10) default NULL,
`JobCB3` varchar(10) default NULL,
`JobCB4` varchar(10) default NULL,
`JobCB5` varchar(10) default NULL,
`JobCB6` varchar(10) default NULL,
`JobCB7` varchar(10) default NULL,
`JobCB8` varchar(10) default NULL,
`JobPL1` varchar(2) default NULL,
`JobPL2` varchar(2) default NULL,
`JobPL3` varchar(2) default NULL,
`JobPL4` varchar(2) default NULL,
`JobPL5` varchar(2) default NULL,
`JobPL6` varchar(2) default NULL,
`JobPL7` varchar(2) default NULL,
`JobPL8` varchar(2) default NULL,
`JobPL9` varchar(2) default NULL,
`JobPL10` varchar(2) default NULL,
`JobPL11` varchar(2) default NULL,
`JobComments` varchar(100) default NULL,
`JobTC` decimal(7,2) default NULL,
`JobLC` decimal(6,2) default NULL,
`JobFT` decimal(7,2) default NULL,
PRIMARY KEY (`JobNum`),
KEY `CustNum` (`CustNum`),
CONSTRAINT `JOB_ibfk_1` FOREIGN KEY (`CustNum`) REFERENCES `CUSTOMERS` (`CustNum`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1