CREATE TABLE hulladek_ht_kel
(
   hulladek_ht_kel_kod serial not null,
   hulladek_ht_kel_htkod int4 not null,
   teaor varchar(5),
   kezeles varchar(10),
   tevekenyseg varchar(60),
   mennyiseg varchar(15),
   "c_userid" varchar(20),
   "c_date" date,
   "c_time" varchar(10),
   "m_userid" varchar(20),
   "m_date" date,
   "m_time" varchar(10),
   CONSTRAINT "hulladek_ht_kel_pk1" PRIMARY KEY ("hulladek_ht_kel_kod"),
   CONSTRAINT hulladek_ht_kel_fk1 FOREIGN KEY (hulladek_ht_kel_htkod) REFERENCES hulladek_ht (hulladek_ht_kod) ON UPDATE NO ACTION ON DELETE NO ACTION
) WITHOUT OIDS;

ALTER TABLE hulladek_ht_kel OWNER TO mbt;

CREATE INDEX hulladek_ht_kel_id1 ON hulladek_ht_kel (hulladek_ht_kel_kod);   