CREATE TABLE karbantartas_jkpont
(
   "karbantartas_jkpont_kod" serial NOT NULL,
   "karbantartas_jkpont_jkod" int4 NOT NULL,
   "sorszam" int2, 
   "sorszamszov" varchar(40), 
   "szoveg" varchar(150), 
   "naponta" bool DEFAULT false,
   "hetente" bool DEFAULT false,
   "havonta" bool DEFAULT false, 
   "felevente" bool DEFAULT false, 
   "evente" bool DEFAULT false, 
   "szuksegszerint" bool DEFAULT false,
   "vegezte" varchar(50),
   "uzemora" varchar(20),
   "nyomtathato" bool DEFAULT true,
   "c_userid" varchar(20),
   "c_date" date,
   "c_time" varchar(10),
   "m_userid" varchar(20),
   "m_date" date,
   "m_time" varchar(10),
   CONSTRAINT "karbantartas_jkpont_pk1" PRIMARY KEY ("karbantartas_jkpont_kod"),
   CONSTRAINT karbantartas_jkpont_fk1 FOREIGN KEY ("karbantartas_jkpont_jkod") 
   REFERENCES karbantartas_jk ("karbantartas_jk_kod") MATCH SIMPLE  ON UPDATE NO ACTION ON DELETE NO ACTION
) WITHOUT OIDS;

ALTER TABLE karbantartas_jkpont OWNER TO mbt;

CREATE INDEX karbantartas_jkpont_id1 ON karbantartas_jkpont (karbantartas_jkpont_jkod);
