CREATE TABLE pas
(
  das character varying(6),
  prca character varying(15),
  prcb character varying(15)
)
WITH (OIDS=FALSE);
ALTER TABLE pas OWNER TO postgres;

CREATE TABLE divisions
(
  id bigint NOT NULL,
  "name" character varying(50),
  CONSTRAINT divisions_pkey PRIMARY KEY (id)
)
WITH (OIDS=FALSE);
ALTER TABLE divisions OWNER TO postgres;

CREATE TABLE pe
(
  pe character varying(212),
  cod character varying(15),
  daa bigint,
  pos bigint,
  adr1 character varying(30),
  adr2 character varying(44),
  divers character varying(20),
  dr character varying(45),
  dr2 character varying(5)
)
WITH (OIDS=FALSE);
ALTER TABLE pe OWNER TO postgres;

CREATE TABLE prc
(
  daa character varying(20),
  ord character varying(4),
  "in" character varying(2),
  ante character varying(9),
  sl1 character varying(37),
  prc character varying(12),
  na1 character varying(10),
  co1 bigint,
  ha1 character varying(8),
  cod1 character varying(2),
  ri1 bigint,
  cac character varying(4),
  ddi character varying(10),
  cc character varying(10),
  notif character varying(10),
  caoo character varying(210),
  rscod character varying(10),
  rslt character varying(1),
  rsnr integer,
  rspos integer,
  acj character varying(4),
  n1 character varying(1),
  tv character varying(1),
  mo character varying(2),
  ha character varying(2),
  pw1 character varying(2),
  sl2 character varying(35),
  pw2 character varying(2),
  na2 character varying(10),
  n2 character varying(1),
  co2 bigint,
  ha2 character varying(8),
  cod2 character varying(2),
  ri2 bigint,
  sl3 character varying(35),
  pw3 character varying(2),
  na3 character varying(10),
  n3 character varying(1),
  co3 bigint,
  ha3 character varying(8),
  cod3 character varying(2),
  ri3 bigint,
  pw4 character varying(2),
  na4 character varying(10),
  n4 character varying(1),
  co4 bigint,
  ha4 character varying(8),
  cod4 character varying(2),
  ri4 bigint,
  na5 character varying(10),
  n5 character varying(1),
  co5 bigint,
  ha5 character varying(8),
  cod5 character varying(2),
  ri5 bigint
)
WITH (OIDS=FALSE);
ALTER TABLE prc OWNER TO postgres;