createtables.sql

一个ISB的开发设计文档,里面包括了项目开发计划,开发规范,需求分析,数据库设计,软件设计,软件测试,用户手册,项目总结报告,,比较全面的介绍了软件的开发过程

use DocumentManage

--1.Path
CREATE TABLE Path
(
 Path_Id int NOT NULL PRIMARY KEY IDENTITY (1,1),
 Path varchar(500) NOT NULL,
 Remark varchar(1000) NULL
)

GO

--2.Organize
CREATE TABLE Organize
(
 Organize_Id int NOT NULL PRIMARY KEY,
 Organize_Name varchar(100) NOT NULL,
 Up_Organize_Id int NOT NULL,
 Remark varchar(1000) NULL
)

GO

--3.Popedom
CREATE TABLE Popedom
(
 Popedom_Id int NOT NULL PRIMARY KEY,
 Popedom_Name varchar(100) NOT NULL,
 Remark varchar(1000) NULL
)

GO

--4 Templet
CREATE TABLE Templet
(
 Templet_Id int NOT NULL PRIMARY KEY,
 Templet_Name varchar(100) NOT NULL,
 Templet_Create_Time datetime NOT NULL
)

GO


--5.User_Type
CREATE TABLE User_Type
(
 User_Type_Id int NOT NULL PRIMARY KEY,
 User_Type_Name varchar(100) NOT NULL,
 Remark varchar(1000) NULL
)

GO

--6.User_Info
CREATE TABLE User_Info
(
 User_Info_Id varchar(100) NOT NULL PRIMARY KEY,
 [User_Name] varchar(100) NOT NULL,
 Pass_Word varchar(100) NOT NULL,
 Disk_Space_Sum bigint NOT NULL,
 Disk_Space_Overplus bigint NOT NULL,
 
 Organize_Id int NULL
 CONSTRAINT User_Info_Organize_Id___Organize_Organize_Id
 FOREIGN KEY REFERENCES Organize(Organize_Id)
 NOT FOR REPLICATION,
 
 User_Type_Id int NOT NULL
 CONSTRAINT User_Info_User_Tyep_Id___User_Type_User_Type_Id
 FOREIGN KEY REFERENCES User_Type(User_Type_Id)
 NOT FOR REPLICATION,
 
 Popedom_Id int NOT NULL
 CONSTRAINT User_Popedom_Popedom_Id___Popedom_Popedom_Id
 FOREIGN KEY REFERENCES Popedom(Popedom_Id)
 NOT FOR REPLICATION,
 
 Remark varchar(1000) NULL
)

GO

--7.Document_Electron
CREATE TABLE Document_Electron
(
 Document_Electron_Id varchar(100) NOT NULL PRIMARY KEY,
 Document_Name varchar(100) NOT NULL,
 Document_Create_Time datetime NOT NULL,
 Document_Change_Time datetime NULL,
 Document_Size int NOT NULL,
 Document_Edition varchar(100) NOT NULL,
 
 User_Info_Id varchar(100) NOT NULL
 CONSTRAINT Document_Electron_User_Info_Id___User_Info_User_Info_Id
 FOREIGN KEY REFERENCES User_Info(User_Info_Id)
 NOT FOR REPLICATION,
 
 Remark varchar(1000) NULL,
 
 Templet_Id int NULL
 CONSTRAINT Document_Electron_Templet_Id___Templet_Templet_Id
 FOREIGN KEY REFERENCES Templet(Templet_Id)
 NOT FOR REPLICATION
)

GO

--8.Document_Bunf
CREATE TABLE Document_Bunf
(
 Document_Bunf_Id varchar(100) NOT NULL PRIMARY KEY,
 Document_Name varchar(100) NOT NULL,
 Document_Number int NOT NULL,
 Document_Time datetime NOT NULL,
 
 User_Info_Id varchar(100) NULL
 CONSTRAINT Document_Bunf_User_Info_Id___User_Info_User_Info_Id
 FOREIGN KEY REFERENCES User_Info(User_Info_Id)
 NOT FOR REPLICATION,
 
 Remark varchar(1000) NULL,
 
 Templet_Id int NULL
 CONSTRAINT Document_Bunf_Templet_Id___Templet_Templet_Id
 FOREIGN KEY REFERENCES Templet(Templet_Id)
 NOT FOR REPLICATION
)

GO

--9.Log
CREATE TABLE [Log]
(
 Log_Id int NOT NULL PRIMARY KEY IDENTITY(1,1),
 
 Handle varchar(200) NOT NULL,
 Log_Time datetime NOT NULL,
 [User_Name] varchar(100) NOT NULL,
 Document_Electron_Name varchar(100) NULL,
 Document_Bunf_Name varchar(100) NULL,
 Operate_Static bit NOT NULL,
 Remark varchar(1000) NULL
)

GO

--10.Backup
CREATE TABLE [Data_Backup]
(
 Backup_Id int NOT NULL PRIMARY KEY IDENTITY(1,1),
 Backup_Name varchar(100) NOT NULL,
 Backup_Path varchar(500) NOT NULL,
 Remark varchar(1000) NULL
)

GO