Create table ZAK_FL (
ID_ZAK_FL NUMBER primary key,
SURNAME VARCHAR (40) not null,
NAME_ VARCHAR (40) not null,
PATRONYMIC VARCHAR (40) not null,
PHONE_NAMBER VARCHAR (12) not null unique,
LIVING_ADDRESS VARCHAR (300) not null,
PASSPORT_SERIES NUMBER not null,
PASSPORT_NUMBER NUMBER not null,
PASSPORT_DATE_ DATE not null,
PASSPORT_DEPARTMENT_CODE NUMBER not null,
PASSPORT_ISSUED_BY_ VARCHAR2 (300) not null,
CONSTRAINT ZAK_FL UNIQUE (PASSPORT_SERIES, PASSPORT_NUMBER)
);