【SQL开源代码栏目提醒】：网学会员SQL开源代码为您提供SoftORM.sql参考，解决您在SoftORM.sql学习中工作中的难题，参考学习。
/*==============================================================*/
/* Database name: SoftCRM */
/* DBMS name: sqlServer2000(Extend) */
/* Created on: 2006-8-27 8:51:35 */
/*==============================================================*/
/*==============================================================*/
/* Table: Area */
/*==============================================================*/
create table Area (
AreaID int identity
/*AreaID*/,
AreaName nvarchar(20) not null
/*AreaName*/,
constraint PK_AREA primary key (AreaID)
)
go
/*==============================================================*/
/* Table: Bargain */
/*==============================================================*/
create table Bargain (
BargainID int identity
/*BargainID*/,
EmployeeID int null
/*EmployeeID*/,
UserID int null
/*UserID*/,
BargainBeginDate datetime not null
/*BargainBeginDate*/,
BargainEndDate datetime not null
/*BargainEndDate*/,
BargainNote nvarchar(100) null
/*BargainNote*/,
constraint PK_BARGAIN primary key (BargainID)
)
go
/*==============================================================*/
/* Table: City */
/*==============================================================*/
create table City (
CityID int identity
/*CityID*/,
AreaID int null
/*AreaID*/,
CityName nvarchar(20) not null
/*CityName*/,
constraint PK_CITY primary key (CityID)
)
go
/*==============================================================*/
/* Table: Department */
/*==============================================================*/
create table Department (
DepartID int identity
/*DepartID*/,
DepartName nvarchar(20) not null
/*DepartName*/,
constraint PK_DEPARTMENT primary key (DepartID)
)
go
/*==============================================================*/
/* Table: EmployeeInfo */
/*==============================================================*/
create table EmployeeInfo (
EmployeeID int identity
/*EmployeeID*/,
DepartID int not null
/*DepartID*/,
EmployeeName nvarchar(20) not null
/*EmployeeName*/,
EmployeePhone nvarchar(20) null
/*EmployeePhone*/,
EmployeeEMail nvarchar(20) null
/*EmployeeEMail*/,
EmployeeBirthday datetime null
/*EmployeeBirthday*/,
EmployeeSex bit null
/*EmployeeSex*/,
Note nvarchar(50) null
/*Note*/,
constraint PK_EMPLOYEEINFO primary key (EmployeeID)
)
go
/*==============================================================*/
/* Table: Implement */
/*==============================================================*/
create table Implement (
ImplementID int identity
/*ImplementID*/,
EmployeeID int null
/*EmployeeID*/,
UserID int null
/*UserID*/,
SoftVersion nvarchar(20) not null
/*SoftVersion*/,
ImplementBeginDate datetime not null
/*ImplementBeginDate*/,
ImplementEndDate datetime not null
/*ImplementEndDate*/,
ImplementSumUp nvarchar(100) not null
/*ImplementSumUp*/,
Note nvarchar(100) null
/*Note*/,
constraint PK_IMPLEMENT primary key (ImplementID)
)
go
/*==============================================================*/
/* Table: LinkRecord */
/*==============================================================*/
create table LinkRecord (
LinkRecordID int identity
/*LinkRecordID*/,
EmployeeID int null
/*EmployeeID*/,
UserID int null
/*UserID*/,
LinkDate datetime not null
/*LinkDate*/,
LinkNote nvarchar(100) not null
/*LinkNote*/,
constraint PK_LINKRECORD primary key (LinkRecordID)
)
go
/*==============================================================*/
/* Table: Linkman */
/*==============================================================*/
create table Linkman (
UserID int null
/*UserID*/,
LinkmanID int identity
/*LinkmanID*/,
LinkmanName nvarchar(20) not null
/*LinkmanName*/,
LinkmanPhone nvarchar(20) null
/*LinkmanPhone*/,
LinkmanEMail nvarchar(20) null
/*LinkmanEMail*/,
LinkmanQQ nvarchar(20) null
/*LinkmanQQ*/,
LinkmanBirthday datetime null
/*LinkmanBirthday*/,
LinkmanLike nvarchar(50) null
/*LinkmanLike*/,
LinkmanSex bit null
/*LinkmanSex*/,
note nvarchar(50) null
/*note*/,
constraint PK_LINKMAN primary key (LinkmanID)
)
go
/*==============================================================*/
/* Table: Notion */
/*==============================================================*/
create t
相关文章
2013-9-1
