GhHeetyM

1CREATE  TABLE IF NOT EXISTS `customer` (
2  `cust_ID` INT NOT NULL AUTO_INCREMENT ,
3  `cust_nama` VARCHAR(255) NULL ,
4  `cust_alamat` VARCHAR(255) NULL ,
5  `cust_kota` VARCHAR(45) NULL ,
6  `cust_kodepos` CHAR(5) NULL ,
7  `province_p_ID` INT NOT NULL ,
8  `country_idcountry` INT NOT NULL ,
9  `cust_telp1` VARCHAR(20) NULL ,
10  `cust_telp2` VARCHAR(20) NULL ,
11  `cust_fax1` VARCHAR(20) NULL ,
12  `cust_fax2` VARCHAR(45) NULL ,
13  `cust_email` VARCHAR(255) NULL ,
14  `cust_website` VARCHAR(255) NULL ,
15  `cust_terminpembayaran` INT NULL ,
16  `cust_bataskredit` DECIMAL(12,2) NULL ,
17  `customerrating_idcustomerrating` INT NOT NULL ,
18  `cust_targetpenjualan` DECIMAL(12,2) NULL ,
19  `cust_kenapajak` TINYINT NULL ,
20  `cust_npwp` VARCHAR(45) NULL ,
21  `cust_kawasanberikat` TINYINT NULL ,
22  `cust_datatambahan` TEXT NULL ,
23  `cust_datetime` DATETIME NULL ,
24  `cust_by` VARCHAR(64) NULL ,
25  `sales_id` INT NOT NULL ,
26  `customercol` VARCHAR(45) NULL ,
27  PRIMARY KEY (`cust_ID`) ,
28  INDEX `fk_customer_customerrating1` (`customerrating_idcustomerrating` ASC) ,
29  INDEX `fk_customer_country1` (`country_idcountry` ASC) ,
30  INDEX `fk_customer_users1` (`sales_id` ASC) ,
31  INDEX `fk_customer_province1` (`province_p_ID` ASC) ,
32  CONSTRAINT `fk_customer_customerrating1`
33    FOREIGN KEY (`customerrating_idcustomerrating` )
34    REFERENCES `customerrating` (`cr_ID` )
35    ON DELETE NO ACTION
36    ON UPDATE NO ACTION,
37  CONSTRAINT `fk_customer_country1`
38    FOREIGN KEY (`country_idcountry` )
39    REFERENCES `country` (`country_ID` )
40    ON DELETE NO ACTION
41    ON UPDATE NO ACTION,
42  CONSTRAINT `fk_customer_users1`
43    FOREIGN KEY (`sales_id` )
44    REFERENCES `users` (`usr_ID` )
45    ON DELETE NO ACTION
46    ON UPDATE NO ACTION,
47  CONSTRAINT `fk_customer_province1`
48    FOREIGN KEY (`province_p_ID` )
49    REFERENCES `province` (`p_ID` )
50    ON DELETE NO ACTION
51    ON UPDATE NO ACTION)
52ENGINE = InnoDB