--
--  仮ジャンル品目
--      t_pre_genre_item
--

CREATE TABLE t_pre_genre_item
(
    GenreCd integer NOT NULL,   -- PriKey
    PreItemCd integer NOT NULL,    -- PriKey

    DelFlg boolean,
    AddDate timestamp without time zone,
    UpdDate timestamp without time zone,
    UpdUsrNm character varying(60),
    UpdPcNm character varying(60),
    UpdCnt integer,

    PRIMARY KEY(GenreCd, PreItemCd)
);


-- トリガー
CREATE TRIGGER trigger_master_stamp
  BEFORE INSERT OR UPDATE
  ON t_pre_genre_item
  FOR EACH ROW
  EXECUTE PROCEDURE g_master_stamp();