待办事项 数据库表设计

待办事项 数据库表设计

 

drop table "Backlog" cascade constraints;

/*==============================================================*/
/* Table: "Backlog"                                             */
/*==============================================================*/
create table "Backlog" 
(
   "Id"                 CHAR(36)             not null,
   "Title"              NVARCHAR2(256)       not null,
   "GroupName"          NVARCHAR2(64),
   "Tag"                NVARCHAR2(128),
   "SourceId"           NVARCHAR2(64),
   "OwnerType"          NUMBER(1),
   "Url"                NVARCHAR2(256),
   "Applyer"            NVARCHAR2(32),
   "ApplyTime"          TIMESTAMP,
   "Description"        NVARCHAR2(1024),
   constraint PK_BACKLOG primary key ("Id")
);

comment on table "Backlog" is
'待办事项';

comment on column "Backlog"."Id" is
'Id';

comment on column "Backlog"."Title" is
'标题名称';

comment on column "Backlog"."GroupName" is
'分组名称';

comment on column "Backlog"."Tag" is
'标签';

comment on column "Backlog"."SourceId" is
'源业务Id';

comment on column "Backlog"."OwnerType" is
'所有者类型';

comment on column "Backlog"."Url" is
'操作网址';

comment on column "Backlog"."Applyer" is
'发起人';

comment on column "Backlog"."ApplyTime" is
'发起时间';

comment on column "Backlog"."Description" is
'描述';