開発依頼 #4806
<div>-- Drop table</div>
<div> </div>
<div>-- DROP TABLE us_cm.cmi1050m</div>
<div>--서버증명서정보</div>
<div>CREATE TABLE us_cm.cmi1050m (</div>
<div><span style="white-space: normal;">svr_url_fg varchar(1) NOT NULL, -- 運営/デモ区分</span></div>
<div><span style="white-space: normal;">svr_url varchar(200) NULL DEFAULT NULL::character varying, -- 運営/デモURL</span></div>
<div><span style="white-space: normal;">ca_cert varchar(4096) NULL DEFAULT NULL::character varying, -- 証明書(ROOT.CRT)</span></div>
<div><span style="white-space: normal;">cre_user varchar(20) NULL DEFAULT NULL::character varying, -- 作成者ID</span></div>
<div><span style="white-space: normal;">cre_dttm timestamp NULL, -- 作成日時</span></div>
<div><span style="white-space: normal;">upd_user varchar(20) NULL DEFAULT NULL::character varying, -- 更新者ID</span></div>
<div><span style="white-space: normal;">upd_dttm timestamp NULL, -- 更新日時</span></div>
<div><span style="white-space: normal;">CONSTRAINT ix_cmi1050m_pk PRIMARY KEY (svr_url_fg)</span></div>
<div>);</div>
<div>COMMENT ON TABLE us_cm.cmi1050m IS 'サーバー証明書情報';</div>
<div> </div>
<div>-- Column comments</div>
<div> </div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.svr_url_fg IS '運営/デモ区分';</div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.svr_url IS '運営/デモURL';</div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.ca_cert IS '証明書(ROOT.CRT) ';</div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.cre_user IS '作成者ID';</div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.cre_dttm IS '作成日時';</div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.upd_user IS '更新者ID';</div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.upd_dttm IS '更新日時';</div>
<div> </div>
<div>-- Permissions</div>
<div> </div>
<div>ALTER TABLE us_cm.cmi1050m OWNER TO owlpg;</div>
<div>GRANT ALL ON TABLE us_cm.cmi1050m TO owlpg;</div>
<div> </div>
<div>--クライアント증명서정보</div>
<div>CREATE TABLE us_cm.cmi1051m (</div>
<div><span style="white-space: normal;">cstm_id varchar(10) NOT NULL, -- 顧客ID</span></div>
<div><span style="white-space: normal;">svr_url_fg varchar(1) NULL DEFAULT NULL::character varying, -- 運営/デモ区分</span></div>
<div><span style="white-space: normal;">cert varchar(4096) NULL DEFAULT NULL::character varying, -- クライアント証明書</span></div>
<div><span style="white-space: normal;">cert_key varchar(4096) NULL DEFAULT NULL::character varying, -- クライアント証明書 秘密鍵</span></div>
<div><span style="white-space: normal;">key_pass varchar(100) NULL DEFAULT NULL::character varying, -- 証明書パスワード</span></div>
<div><span style="white-space: normal;">api_key varchar(500) NULL DEFAULT NULL::character varying, -- 日レセAPIキー</span></div>
<div><span style="white-space: normal;">cre_user varchar(20) NULL DEFAULT NULL::character varying, -- 作成者ID</span></div>
<div><span style="white-space: normal;">cre_dttm timestamp NULL, -- 作成日時</span></div>
<div><span style="white-space: normal;">upd_user varchar(20) NULL DEFAULT NULL::character varying, -- 更新者ID</span></div>
<div><span style="white-space: normal;">upd_dttm timestamp NULL, -- 更新日時</span></div>
<div><span style="white-space: normal;">CONSTRAINT ix_cmi1051m_pk PRIMARY KEY (cstm_id)</span></div>
<div>);</div>
<div>COMMENT ON TABLE us_cm.cmi1051m IS 'クライアント証明書情報';</div>
<div> </div>
<div>-- Column comments</div>
<div> </div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.cstm_id IS '顧客ID';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.svr_url_fg IS '運営/デモ区分';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.cert IS 'クライアント証明書';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.cert_key IS 'クライアント証明書 秘密鍵';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.key_pass IS '証明書パスワード';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.api_key IS '日レセAPIキー';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.cre_user IS '作成者ID';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.cre_dttm IS '作成日時';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.upd_user IS '更新者ID';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.upd_dttm IS '更新日時';</div>
<div> </div>
<div>-- Permissions</div>
<div> </div>
<div>ALTER TABLE us_cm.cmi1051m OWNER TO owlpg;</div>
<div>GRANT ALL ON TABLE us_cm.cmi1051m TO owlpg;</div>
<div> </div>
<div>-- DROP TABLE us_cm.cmi1050m</div>
<div>--서버증명서정보</div>
<div>CREATE TABLE us_cm.cmi1050m (</div>
<div><span style="white-space: normal;">svr_url_fg varchar(1) NOT NULL, -- 運営/デモ区分</span></div>
<div><span style="white-space: normal;">svr_url varchar(200) NULL DEFAULT NULL::character varying, -- 運営/デモURL</span></div>
<div><span style="white-space: normal;">ca_cert varchar(4096) NULL DEFAULT NULL::character varying, -- 証明書(ROOT.CRT)</span></div>
<div><span style="white-space: normal;">cre_user varchar(20) NULL DEFAULT NULL::character varying, -- 作成者ID</span></div>
<div><span style="white-space: normal;">cre_dttm timestamp NULL, -- 作成日時</span></div>
<div><span style="white-space: normal;">upd_user varchar(20) NULL DEFAULT NULL::character varying, -- 更新者ID</span></div>
<div><span style="white-space: normal;">upd_dttm timestamp NULL, -- 更新日時</span></div>
<div><span style="white-space: normal;">CONSTRAINT ix_cmi1050m_pk PRIMARY KEY (svr_url_fg)</span></div>
<div>);</div>
<div>COMMENT ON TABLE us_cm.cmi1050m IS 'サーバー証明書情報';</div>
<div> </div>
<div>-- Column comments</div>
<div> </div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.svr_url_fg IS '運営/デモ区分';</div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.svr_url IS '運営/デモURL';</div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.ca_cert IS '証明書(ROOT.CRT) ';</div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.cre_user IS '作成者ID';</div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.cre_dttm IS '作成日時';</div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.upd_user IS '更新者ID';</div>
<div>COMMENT ON COLUMN us_cm.cmi1050m.upd_dttm IS '更新日時';</div>
<div> </div>
<div>-- Permissions</div>
<div> </div>
<div>ALTER TABLE us_cm.cmi1050m OWNER TO owlpg;</div>
<div>GRANT ALL ON TABLE us_cm.cmi1050m TO owlpg;</div>
<div> </div>
<div>--クライアント증명서정보</div>
<div>CREATE TABLE us_cm.cmi1051m (</div>
<div><span style="white-space: normal;">cstm_id varchar(10) NOT NULL, -- 顧客ID</span></div>
<div><span style="white-space: normal;">svr_url_fg varchar(1) NULL DEFAULT NULL::character varying, -- 運営/デモ区分</span></div>
<div><span style="white-space: normal;">cert varchar(4096) NULL DEFAULT NULL::character varying, -- クライアント証明書</span></div>
<div><span style="white-space: normal;">cert_key varchar(4096) NULL DEFAULT NULL::character varying, -- クライアント証明書 秘密鍵</span></div>
<div><span style="white-space: normal;">key_pass varchar(100) NULL DEFAULT NULL::character varying, -- 証明書パスワード</span></div>
<div><span style="white-space: normal;">api_key varchar(500) NULL DEFAULT NULL::character varying, -- 日レセAPIキー</span></div>
<div><span style="white-space: normal;">cre_user varchar(20) NULL DEFAULT NULL::character varying, -- 作成者ID</span></div>
<div><span style="white-space: normal;">cre_dttm timestamp NULL, -- 作成日時</span></div>
<div><span style="white-space: normal;">upd_user varchar(20) NULL DEFAULT NULL::character varying, -- 更新者ID</span></div>
<div><span style="white-space: normal;">upd_dttm timestamp NULL, -- 更新日時</span></div>
<div><span style="white-space: normal;">CONSTRAINT ix_cmi1051m_pk PRIMARY KEY (cstm_id)</span></div>
<div>);</div>
<div>COMMENT ON TABLE us_cm.cmi1051m IS 'クライアント証明書情報';</div>
<div> </div>
<div>-- Column comments</div>
<div> </div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.cstm_id IS '顧客ID';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.svr_url_fg IS '運営/デモ区分';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.cert IS 'クライアント証明書';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.cert_key IS 'クライアント証明書 秘密鍵';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.key_pass IS '証明書パスワード';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.api_key IS '日レセAPIキー';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.cre_user IS '作成者ID';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.cre_dttm IS '作成日時';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.upd_user IS '更新者ID';</div>
<div>COMMENT ON COLUMN us_cm.cmi1051m.upd_dttm IS '更新日時';</div>
<div> </div>
<div>-- Permissions</div>
<div> </div>
<div>ALTER TABLE us_cm.cmi1051m OWNER TO owlpg;</div>
<div>GRANT ALL ON TABLE us_cm.cmi1051m TO owlpg;</div>
