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