CREATE TABLE telekanal
(
kirjeldus CHARACTER VARYING(255),
nimetus CHARACTER VARYING(255),
t_id serial NOT NULL,
CONSTRAINT primary_id PRIMARY KEY (t_id)
)
CREATE TABLE programm
(
algusaeg TIMESTAMP WITHOUT TIME zone,
kirjeldus CHARACTER VARYING(255),
nimetus CHARACTER VARYING(255),
pikkus INTEGER,
tyyp CHARACTER VARYING(255),
telekanal BIGINT NOT NULL,
p_id serial NOT NULL,
CONSTRAINT primary_programmid PRIMARY KEY (p_id),
CONSTRAINT fk_telekanal FOREIGN KEY (telekanal)
REFERENCES telekanal (t_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)