CREATE TABLE buyer
(
id INT NOT NULL,
fio VARCHAR(64) NOT NULL,
sex CHAR(1) NOT NULL CHECK (sex IN ('м', 'ж')),
dp datetime,
socialstatus VARCHAR(30),
CONSTRAINT buyer_pk PRIMARY KEY (id)
)
 
 
CREATE TABLE videocassette
(
id INT NOT NULL,
movietitle VARCHAR(64) NOT NULL,
price DECIMAL(10, 2) NOT NULL CHECK (price>0),
producer VARCHAR(64) NOT NULL ,
genre VARCHAR(64) NOT NULL,
numberofOscars VARCHAR(64) NOT NULL,
screen datetime,
CONSTRAINT videocassette_pk PRIMARY KEY (id)
)
 
CREATE TABLE sale
(
id INT NOT NULL,
movietitle VARCHAR(64) NOT NULL,
Fbuyer VARCHAR(64) NOT NULL,
pnumber VARCHAR(64) NOT NULL,
sale datetime NOT NULL,
buyer_id INT NOT NULL,
record_id INT NOT NULL,
CONSTRAINT sale_pk PRIMARY KEY (id),
CONSTRAINT buyer_fk FOREIGN KEY
(buyer_id) REFERENCES buyer,
CONSTRAINT videocassette_fk FOREIGN KEY
(record_id) REFERENCES videocassette,
)