/*豸Ϣ*/
CREATE TABLE [dbo].[deviceType] (
	[deviceTypeId] [int] IDENTITY (1, 1) NOT NULL ,  			//豸ͱ
	[deviceTypeName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL  	//豸
) ON [PRIMARY]

/*豸״̬Ϣ*/
CREATE TABLE [dbo].[deviceStateInfo] (
	[deviceState] [int] IDENTITY (1, 1) NOT NULL ,				//豸״̬
	[deviceStateDesc] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL	//豸״̬ 
) ON [PRIMARY]

/*豸Ϣ*/
CREATE TABLE [dbo].[deviceInfo] (
	[deviceId] [int] IDENTITY (1, 1) NOT NULL ,  				//豸
	[deviceName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , 	//豸
	[deviceTypeId] [int] NULL , 						//豸ͱ
	[deviceSign] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , 		//豸Ʒ
	[deviceModel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,		//豸ͺ
	[deviceSerialNumber] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,	//豸к
	[deviceImagePath] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,	//豸ͼƬ·
	[deviceState] [smallint] NULL ,						//豸״̬
	[deviceMadePlace] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,	//豸
	[deviceOutDate] [datetime] NULL ,					//豸
	[devicePurchaseTime] [datetime] NULL ,					//豸
	[deviceMemo] [text] COLLATE Chinese_PRC_CI_AS NULL 			//豸עϢ
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

/*Ϣ*/
CREATE TABLE [dbo].[departmentInfo] (
	[departmentId] [int] IDENTITY (1, 1) NOT NULL ,				//ű
	[departmentName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL 	//
) ON [PRIMARY]

/*豸Ϣ*/
CREATE TABLE [dbo].[lendInfo] (
	[lendId] [int] IDENTITY (1, 1) NOT NULL ,				//ü¼
	[deviceId] [int] NOT NULL ,						//豸
	[lendDepartmentId] [int] NOT NULL ,					//豸ű
	[lendPerson] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,	//豸
	[lendDate] [datetime] NOT NULL ,					//豸
	[lendDays] [smallint] NOT NULL ,					//豸
	[returnDate] [datetime] NULL ,						//黹豸ʱ
	[isReturn] [bit] NOT NULL 						//豸ǷѾ黹
) ON [PRIMARY]

/*豸άϢ*/
CREATE TABLE [dbo].[repairInfo] (
	[repairId] [int] IDENTITY (1, 1) NOT NULL ,				//ά޼¼
       	[deviceId] [int] NULL ,							//ά豸
        [repairPlace] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,		//ά޵ص
	[repairMan] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,		//ά
	[repairTime] [float] NULL ,						//ά޹ʱ
	[repairMoney] [float] NULL ,						//ά޷
	[errorReason] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,		//ԭ	
	[repairStartTime] [datetime] NULL ,					//ά޿ʼ
	[repairEndTime] [datetime] NULL ,					//ά޽
	[isReturn] [bit] NULL ,							//豸ǷѾ
	[repairMemo] [text] COLLATE Chinese_PRC_CI_AS NULL 			//Ϣ
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

/*豸Ϣ*/
CREATE TABLE [dbo].[rubbishInfo] (
	[deviceId] [int] NOT NULL ,						//豸
	[deviceRubbishTime] [datetime] NULL ,					//
	[deviceRubbishReason] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,	//ԭ
	[deprecitionMoney] [float] NULL 					//۾ɽ
) ON [PRIMARY]

/*ԱʺϢ*/
CREATE TABLE [dbo].[admin] (
	[adminUserName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,	//Աʺ
	[adminPassword] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL 	//Ա
) ON [PRIMARY]
