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