待办事项 数据库表设计
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
'描述';