CREATE TABLE mst_group
(
  group_cd     text NOT NULL,
  group_id     text,
  group_pass   text,
  group_foldar text,
  group_name text,
  CONSTRAINT mst_group_pkey PRIMARY KEY (group_cd)
) 
WITHOUT OIDS;
ALTER TABLE mst_group OWNER TO pgsqladmin;
GRANT ALL ON TABLE mst_group TO nobody;
GRANT ALL ON TABLE mst_group TO pgsqladmin;

CREATE INDEX index_mst_group ON mst_group USING btree (group_cd);


CREATE TABLE mst_template
(
  temp_id        integer NOT NULL,
  temp_name      text,
  temp_dp_name   text,
  CONSTRAINT mst_template_pkey PRIMARY KEY (temp_id)
) 
WITHOUT OIDS;
ALTER TABLE mst_template OWNER TO pgsqladmin;
GRANT ALL ON TABLE mst_template TO nobody;
GRANT ALL ON TABLE mst_template TO pgsqladmin;

CREATE INDEX index_mst_template ON mst_template USING btree (temp_id);


CREATE TABLE mst_style
(
  style_id     integer NOT NULL,
  style_name   text,
  style_dp_name   text,
  CONSTRAINT mst_style_pkey PRIMARY KEY (style_id)
) 
WITHOUT OIDS;
ALTER TABLE mst_style OWNER TO pgsqladmin;
GRANT ALL ON TABLE mst_style TO nobody;
GRANT ALL ON TABLE mst_style TO pgsqladmin;

CREATE INDEX index_mst_style ON mst_style USING btree (style_id);


CREATE TABLE group_style_tbl
(
  group_cd         text NOT NULL,
  group_template   integer,
  group_style      integer,
  CONSTRAINT group_style_tbl_pkey PRIMARY KEY (group_cd)
) 
WITHOUT OIDS;
ALTER TABLE group_style_tbl OWNER TO pgsqladmin;
GRANT ALL ON TABLE group_style_tbl TO nobody;
GRANT ALL ON TABLE group_style_tbl TO pgsqladmin;

CREATE INDEX index_group_style_tbl ON group_style_tbl USING btree (group_cd);

CREATE TABLE group_file_tbl
(
  group_cd     text NOT NULL,
  file_id      integer NOT NULL,
  file_type     text,
  CONSTRAINT group_file_tbl_pkey PRIMARY KEY (group_cd,file_id)
) 
WITHOUT OIDS;
ALTER TABLE group_file_tbl OWNER TO pgsqladmin;
GRANT ALL ON TABLE group_file_tbl TO nobody;
GRANT ALL ON TABLE group_file_tbl TO pgsqladmin;

CREATE INDEX index_group_file_tbl ON group_file_tbl USING btree (group_cd,file_id);


CREATE TABLE group_header_tbl
(
  group_cd     text NOT NULL,
  header_memo  text,
  type         integer
  CONSTRAINT group_header_tbl_pkey PRIMARY KEY (group_cd)
) 
WITHOUT OIDS;
ALTER TABLE group_header_tbl OWNER TO pgsqladmin;
GRANT ALL ON TABLE group_header_tbl TO nobody;
GRANT ALL ON TABLE group_header_tbl TO pgsqladmin;

CREATE INDEX index_group_header_tbl ON group_header_tbl USING btree (group_cd);