GrDqU62J

1CREATE TABLE IF NOT EXISTS `NOAS_DATABASE`.`CUSTOMER` (
2    `CUSTOMER_ID` VARCHAR(20) NOT NULL,
3    `CUST_NETWORK_SET` TEXT(20) NULL,
4    `BILLING_ID` TEXT(20) NULL,
5    `LOCATION` TEXT(20) NULL,
6    `SERVICE_ID` VARCHAR(20) NULL,
7    `RANGE_ID` VARCHAR(20) NULL,
8    `TRUNK_GROUP_ID` VARCHAR(20) NULL,
9    PRIMARY KEY (`CUSTOMER_ID`),
10    INDEX `SERVICE_ID_idx` (`SERVICE_ID` ASC) VISIBLE,
11    INDEX `RANGE_ID_idx` (`RANGE_ID` ASC) VISIBLE,
12    INDEX `TRUNK_GROUP_ID_idx` (`TRUNK_GROUP_ID` ASC) VISIBLE,
13    CONSTRAINT `SERVICE_ID`
14        FOREIGN KEY (`SERVICE_ID`)
15        REFERENCES `NOAS_DATABASE`.`SERVICE` (`SERVICE_ID`)
16        ON DELETE NO ACTION
17        ON UPDATE NO ACTION,
18    CONSTRAINT `RANGE_ID`
19        FOREIGN KEY (`RANGE_ID`)
20        REFERENCES `NOAS_DATABASE`.`NO_RANGE` (`RANGE_ID`)
21        ON DELETE NO ACTION
22        ON UPDATE NO ACTION,
23    CONSTRAINT `TRUNK_GROUP_ID`
24        FOREIGN KEY (`TRUNK_GROUP_ID`)
25        REFERENCES `NOAS_DATABASE`.`TRUNK_GROUP` (`TRUNK_GROUP_ID`)
26        ON DELETE NO ACTION
27        ON UPDATE NO ACTION)
28ENGINE = InnoDB;