/* ================================================================================ 档案代号:nnz_file 档案名称:支票作废档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table nnz_file ( nnz01 varchar2(11) NOT NULL, /*银行别 */ nnz02 varchar2(15) NOT NULL, /*票号 */ nnz03 varchar2(255), /*备注 */ nnzuser varchar2(10), /*资料所有者 */ nnzgrup varchar2(10), /*资料所有部门 */ nnzmodu varchar2(10), /*资料修改者 */ nnzdate date /*最近修改日 */ ); create unique index nnz_pk on nnz_file (nnz01,nnz02); alter table nnz_file add constraint nnz_pk primary key (nnz01,nnz02) enable validate; grant select on nnz_file to public; grant index on nnz_file to public; grant update on nnz_file to public; grant delete on nnz_file to public; grant insert on nnz_file to public; |