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
)