CREATE TABLE mst_area
(
  area_id integer NOT NULL,
  area_name text,
  disp_rank integer,
  CONSTRAINT mst_area_pkey PRIMARY KEY (area_id)
) 
WITHOUT OIDS;
ALTER TABLE mst_area OWNER TO pgsqladmin;
GRANT ALL ON TABLE mst_area TO nobody;
GRANT ALL ON TABLE mst_area TO pgsqladmin;

CREATE INDEX index_mst_area ON mst_area USING btree (area_id);


CREATE TABLE mst_gyousya
(
  gyousya_id    integer NOT NULL,
  gyousya_name  text,
  gyousya_post  text,
  gyousya_addr1 text,
  gyousya_addr2 text,
  gyousya_tel   text,
  gyousya_fax   text,
  gyousya_mail  text,
  gyousya_memo  text,
  disp_rank     integer,
  CONSTRAINT mst_gyousya_pkey PRIMARY KEY (gyousya_id)
) 
WITHOUT OIDS;
ALTER TABLE mst_gyousya OWNER TO pgsqladmin;
GRANT ALL ON TABLE mst_gyousya TO nobody;
GRANT ALL ON TABLE mst_gyousya TO pgsqladmin;

CREATE INDEX index_mst_gyousya ON mst_gyousya USING btree (gyousya_id);



CREATE TABLE mst_gyoumu
(
  gyoumu_id    integer NOT NULL,
  gyoumu_name  text,
  disp_rank     integer,
  CONSTRAINT mst_gyoumu_pkey PRIMARY KEY (gyoumu_id)
) 
WITHOUT OIDS;
ALTER TABLE mst_gyoumu OWNER TO pgsqladmin;
GRANT ALL ON TABLE mst_gyoumu TO nobody;
GRANT ALL ON TABLE mst_gyoumu TO pgsqladmin;

CREATE INDEX index_mst_gyoumu ON mst_gyoumu USING btree (gyoumu_id);

CREATE TABLE mst_gyoumukbn
(
  gyoumu_id       integer NOT NULL,
  gyoumukbn_id    integer NOT NULL,
  gyoumukbn_name  text,
  disp_rank       integer,
  CONSTRAINT mst_gyoumukbn_pkey PRIMARY KEY (gyoumu_id,gyoumukbn_id)
) 
WITHOUT OIDS;
ALTER TABLE mst_gyoumukbn OWNER TO pgsqladmin;
GRANT ALL ON TABLE mst_gyoumukbn TO nobody;
GRANT ALL ON TABLE mst_gyoumukbn TO pgsqladmin;

CREATE INDEX index_mst_gyoumukbn ON mst_gyoumukbn USING btree (gyoumu_id,gyoumukbn_id);


CREATE TABLE rcv_tbl
(
  rcv_id            integer NOT NULL,
  rcv_area_id       integer,
  rcv_gyousya_id    integer,
  rcv_gyoumu_id     integer,
  rcv_gyoumukbn_id  integer,
  seikyu_money      bigint,
  seikyu_date       text,
  seikyu_kigen      text,
  seikyu_memo       text,
  seikyu_user       integer,
  nyukin_money      bigint,
  nyukin_date       text,
  nyukin_memo       text,
  nyukin_user       integer,
  CONSTRAINT rcv_tbl_pkey PRIMARY KEY (rcv_id)
) 
WITHOUT OIDS;
ALTER TABLE rcv_tbl OWNER TO pgsqladmin;
GRANT ALL ON TABLE rcv_tbl TO nobody;
GRANT ALL ON TABLE rcv_tbl TO pgsqladmin;

CREATE INDEX index_rcv_tbl ON rcv_tbl USING btree (rcv_id);


CREATE TABLE mst_kamoku
(
  kamoku_id       integer NOT NULL,
  oya_id          integer NOT NULL,
  kamoku_name     text,
  CONSTRAINT mst_kamoku_pkey PRIMARY KEY (kamoku_id,oya_id)
) 
WITHOUT OIDS;
ALTER TABLE mst_kamoku OWNER TO pgsqladmin;
GRANT ALL ON TABLE mst_kamoku TO nobody;
GRANT ALL ON TABLE mst_kamoku TO pgsqladmin;

CREATE INDEX index_mst_kamoku ON mst_kamoku USING btree (kamoku_id,oya_id);