able Notion (
NotionID int identity
/*NotionID*/,
EmployeeID int null
/*EmployeeID*/,
UserID int null
/*UserID*/,
NotionContent nvarchar(100) null
/*NotionContent*/,
HandleContent nvarchar(100) null
/*HandleContent*/,
NotionDate datetime null
/*NotionDate*/,
HandleDate datetime null
/*HandleDate*/,
constraint PK_NOTION primary key (NotionID)
)
go
/*==============================================================*/
/* Table: Requirement */
/*==============================================================*/
create table Requirement (
RequirementID int identity
/*RequirementID*/,
EmployeeID int null
/*EmployeeID*/,
UserID int null
/*UserID*/,
RequirementContent nvarchar(100) null
/*RequirementContent*/,
HandleContent nvarchar(100) null
/*HandleContent*/,
RequirementDate datetime null
/*RequirementDate*/,
HandleDate datetime null
/*HandleDate*/,
constraint PK_REQUIREMENT primary key (RequirementID)
)
go
/*==============================================================*/
/* Table: Task */
/*==============================================================*/
create table Task (
TaskID int identity
/*TaskID*/,
EmployeeID int null
/*EmployeeID*/,
UserID int null
/*UserID*/,
TaskTitle nvarchar(20) not null
/*TaskTitle*/,
TaskBeginDate datetime null
/*TaskBeginDate*/,
TaskEndDate datetime null
/*TaskEndDate*/,
TaskNote nvarchar(100) not null
/*TaskNote*/,
constraint PK_TASK primary key (TaskID)
)
go
/*==============================================================*/
/* Table: UserGrade