子敬正在创造自己的人生
需求有轻重缓急,功能有可控不可控。 需求有版本有截止(否则会无休无止),功能不可控变为可控。 集中兵力消灭敌人有生力量,集中优势兵力消灭敌人有生力量。
-- Create table
create table REPO_FOLDER
(
  UUID        VARCHAR2(50) not null,
  VALID       VARCHAR2(2) not null,
  CREATE_TIME TIMESTAMP(6) not null,
  CREATOR     VARCHAR2(50) not null,
  REMARK      VARCHAR2(500),
  MODIFY_TIME TIMESTAMP(6) not null,
  MODIFIER    VARCHAR2(50) not null
)
 ;
-- Add comments to the columns 
comment on column REPO_FOLDER.UUID
  is '文件夹ID';
comment on column REPO_FOLDER.VALID
  is 'YES:有效,NO:无效;参照枚举类EnumYesNo';
comment on column REPO_FOLDER.CREATE_TIME
  is '创建时间';
comment on column REPO_FOLDER.CREATOR
  is '创建者';
comment on column REPO_FOLDER.REMARK
  is '备注';
comment on column REPO_FOLDER.MODIFY_TIME
  is '最后修改时间';
comment on column REPO_FOLDER.MODIFIER
  is '修改人';
-- Create/Recreate primary, unique and foreign key constraints 
alter table REPO_FOLDER
  add constraint REPO_FOLDER_ID_KEY primary key (UUID)
   ;

 

posted on 2014-04-18 10:36  silentjesse  阅读(297)  评论(0编辑  收藏  举报