CREATE TABLE TB_FACILITY_CATEGORY
(
ID BIGINT NOT NULL,
NAME VARCHAR(100),
PARENT_ID BIGINT,
);
ALTER TABLE XKW_LICENCE_CM.TB_FACILITY_CATEGORY
ADD CONSTRAINT pk_xkw_licence_cm.tb_facility_category PRIMARY KEY (ID);
ALTER TABLE TB_FACILITY_CATEGORY
ADD CONSTRAINT FK6059BF89D5E4BBA0 FOREIGN KEY (PARENT_ID)
REFERENCES XKW_LICENCE_CM.TB_FACILITY_CATEGORY (ID)
ON UPDATE NO ACTION
ON DELETE NO ACTION;