/* ================================================================================ 档案代号:gai_file 档案名称:流程讯息批次通知纪录档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gai_file ( gai01 varchar2(35) NOT NULL, /*讯息号码 */ /*讯息号码($模组别_单据编号_三位流水号) */ gai02 varchar2(1), /*等级 */ /*等级(A.紧急 B.重要 C.一般 D.通知 E.纪录)*/ gai03 varchar2(255), /*讯息内容 */ /*讯息内容(应该要包含程式代号与功能类别) */ gai04 varchar2(20), /*建议执行程式代号 */ gai05 varchar2(255), /*Mail收件者清单 */ /*Mail收件者清单(以分号隔开) */ gai06 varchar2(255) /*Mail副本清单 */ /*Mail副本清单(以分号隔开) */ ); create unique index gai_pk on gai_file (gai01); alter table gai_file add constraint gai_pk primary key (gai01) enable validate; grant select on gai_file to public; grant index on gai_file to public; grant update on gai_file to public; grant delete on gai_file to public; grant insert on gai_file to public; |