CREATE TABLE oraszam_munkatabla
(
  kod serial NOT NULL,
  o_kod character(11) DEFAULT '',
  o_tipus character(1) DEFAULT 'F',
  s_leolv date,
  s_szamlalo numeric(12,3) DEFAULT 0,
  s_terhido date,
  f_kod character(11) DEFAULT '',
  f_jelleg character(1) NOT NULL,
  partner_sorszam integer DEFAULT 0,
  ora_tipus character varying(20) DEFAULT '',
  f_nev character varying(100) DEFAULT '',
  f_futtol character varying(20) DEFAULT '',
  f_futig character varying(20) DEFAULT '',
  kod_kifejtve character varying(200) DEFAULT '',
  o_uzembe character varying(20) DEFAULT '',
  o_uzemki character varying(20) DEFAULT '',
  o_gyarisz character varying(20) DEFAULT '',
  utolso_oraallas real DEFAULT 0,
  utolso_oraallas_datuma character varying(20) DEFAULT '',
  CONSTRAINT oraszam_munkatabla_pky PRIMARY KEY (kod)
)
WITHOUT OIDS;