CREATE TABLE DARBINIEKI(
    ID      	INT GENERATED BY DEFAULT ON NULL AS IDENTITY,
    VARDS   	VARCHAR2(20) NOT NULL,
    UZVARDS 	VARCHAR2(20) NOT NULL,
    AMATA_ID   	INT NOT NULL,
    PRIMARY 	KEY(ID)
);

CREATE TABLE PERS_DATA(
    DARB_ID     INT PRIMARY KEY,
    ADRESE      VARCHAR(40) NOT NULL,
    TALRUNIS    NUMBER NOT NULL,
    DZ_DATA     DATE NOT NULL
);

ALTER TABLE PERS_DATA ADD
FOREIGN KEY (DARB_ID) REFERENCES DARBINIEKI (ID);

CREATE TABLE AMATS(
    ID    		INT PRIMARY KEY,
    NOSAUKUMS   VARCHAR(50) NOT NULL,
    ALGA        FLOAT
);

ALTER TABLE DARBINIEKI ADD
FOREIGN KEY (AMATA_ID) REFERENCES AMATS (ID);