repo_folder

最新推荐文章于 2024-04-01 09:37:55 发布

weixin_30681121

最新推荐文章于 2024-04-01 09:37:55 发布

阅读量88

点赞数

原文链接：http://www.cnblogs.com/silentjesse/p/3672634.html

版权

-- 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)
   ;