CREATE TABLE eve_felmero
(
  eve_felmero_kod serial not null,
  eve_felmero_pkod int4 not null,
  eve_felmero_tkod int4 not null,
  fizikai varchar(221),
  hozaj varchar(156),
  villamos varchar(104),
  vegyi varchar(117),
  levego varchar(117),
  biologiai varchar(52),
  sugarzas varchar(143),
  kelthely varchar(80),
  datum_kelt date,
  munkavedelmis text,
  feor varchar(10),
  feorszoveg varchar(60),
 "c_userid" varchar(20),
   "c_date" date,
   "c_time" varchar(10),
   "m_userid" varchar(20),
   "m_date" date,
   "m_time" varchar(10),
   CONSTRAINT "eve_felmero_pk1" PRIMARY KEY ("eve_felmero_kod"),
   CONSTRAINT eve_felmero_fk1 FOREIGN KEY ("eve_felmero_pkod", "eve_felmero_tkod") 
      REFERENCES telephely ("telephely_pkod", "telephely_kod") MATCH SIMPLE  ON UPDATE NO ACTION ON DELETE NO ACTION   
) WITHOUT OIDS;

ALTER TABLE eve_felmero OWNER TO mbt;

CREATE INDEX eve_felmero_id1 ON eve_felmero (feorszoveg);
CREATE INDEX eve_felmero_id2 ON eve_felmero (eve_felmero_pkod, eve_felmero_tkod);