数据建表模板

某项目某数据表结构

建表 SQL 语句示例

create table test(cdate char(8) default to_char(sysdate,'YYYYMMDD') not null,ctime char(6) default to_char(sysdate,'HH24miss') not null,udate char(8) default to_char(sysdate,'YYYYMMDD') not null,utime char(6) default to_char(sysdate,'HH24miss') not null,note char(200),memo char(200),addit char(200),extra char(200))";
comment on column test.cdate is '创建日期';
comment on column test.ctime is '创建时间';
comment on column test.udate is '修改日期';
comment on column test.utime is '修改时间';
comment on column test.note is '备注信息';
comment on column test.memo is '备注信息';
comment on column test.addit is '附加信息';
comment on column test.extra is '附加信息';