Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement