arrays

CREATE TABLE SETTINGS (
  SETT_ID                        SMALLINT NOT NULL,
  TIMERS                         SMALLINT[1:20],
  SPEEDS                         DECIMAL(7,2)[1:20],
  M_DATA                        DECIMAL(5,2)[1:20]);
 
/* Primary key */

ALTER TABLE SETTINGS ADD CONSTRAINT INTEG_58 PRIMARY KEY (SETT_ID);

CREATE TABLE MAIN (
NUMBER BIGINT NOT NULL,
SIDE VARCHAR(10),
STATE SMALLINT,
PROG_ID FOR_PROG_ID,
LENGHT DECIMAL(6,2),
SETT_ID SMALLINT,
QUE_CON BIGINT NOT NULL,
JL_NUM SMALLINT NOT NULL,
PRIMARY KEY (QUE_CON,JL_NUM),
FOREIGN KEY (SETT_ID) REFERENCES SETTINGS (SETT_ID)
ON UPDATE CASCADE
ON DELETE CASCADE
);