CREATE TABLE LCA_ACCPOINTS (
   CODE         D_APCODES NOT NULL /* D_APCODES = VARCHAR(10) */,
   CONSUMER     D_CONCODES NOT NULL /* D_CONCODES = VARCHAR(8) */,
   SUPPLIER     D_APCODES NOT NULL /* D_APCODES = VARCHAR(10) */,
   WORKHOUR     D_INT NOT NULL /* D_INT = INTEGER */,
   WORKDAY      D_INT NOT NULL /* D_INT = INTEGER */,
   OPENDATE     D_DATE NOT NULL /* D_DATE = DATE */,
   CLOSEDATE    D_DATE /* D_DATE = DATE */,
   TSTATION     D_CTLCODES NOT NULL /* D_CTLCODES = INTEGER */,
   STREET       D_CTLCODES NOT NULL /* D_CTLCODES = INTEGER */,
   HOUSE        D_HSAPS NOT NULL /* D_HSAPS = VARCHAR(4) */,
   APART        D_HSAPS /* D_HSAPS = VARCHAR(4) */,
   DESCRIPTION  D_DESCRIPTIONS /* D_DESCRIPTIONS = VARCHAR(255) */
);

ALTER TABLE LCA_ACCPOINTS ADD CONSTRAINT PK_LCA_ACCPOINTS_CODE PRIMARY KEY (CODE);

ALTER TABLE LCA_ACCPOINTS ADD CONSTRAINT FK_LCA_ACCPOINTS_CONSUMER FOREIGN KEY (CONSUMER) REFERENCES LCA_CONSUMERS (CODE) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE LCA_ACCPOINTS ADD CONSTRAINT FK_LCA_ACCPOINTS_STREET FOREIGN KEY (STREET) REFERENCES CTL_STREETS (CODE) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE LCA_ACCPOINTS ADD CONSTRAINT FK_LCA_ACCPOINTS_SUPPLIER FOREIGN KEY (SUPPLIER) REFERENCES LCA_ACCPOINTS (CODE) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE LCA_ACCPOINTS ADD CONSTRAINT FK_LCA_ACCPOINTS_TSTATION FOREIGN KEY (TSTATION) REFERENCES ENC_TSTATIONS (CODE) ON DELETE CASCADE ON UPDATE CASCADE;