lyfz_repos/经典版源码/document/数据库表脚本/FixedAssets.sql

USE [db]
GO
/****** 对象:		Table [dbo].[fixedassets]    描述：	固定资产 脚本日期:	11/10/2015 10:16:01 
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[fixedassets](
	[name]					[nvarchar](50)			NULL,
	[id]					[int] IDENTITY(1,1)		NOT NULL,
	[count]					[nvarchar](50)			NULL,
	[type]					[nvarchar](50)			NULL,
	[clerk]					[nvarchar](50)			NULL,
	[remark]				[nvarchar](50)			NULL,
	[date]					[nvarchar](50)			NULL,
	[photo]					[image]					NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[fixedassets](
	[name]					[nvarchar](50)			NULL,
	[id]					[int] IDENTITY(1,1)		NOT NULL,
	[SN]					[nvarchar](24)			NULL,		-- 编号;
	[count]					[nvarchar](50)			NULL,
	[type]					[nvarchar](50)			NULL,
	[clerk]					[nvarchar](50)			NULL,
	[dept]					[nvarchar](50)			NULL,		-- 部门;
	[remark]				[nvarchar](50)			NULL,
	[date]					[nvarchar](50)			NULL,
	[photo]					[image]					NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE TABLE [dbo].[Tbl_FixedAssets]
(
	FA_SerialNo				[nvarchar] (24)			NOT NULL,			-- 编号;
	FA_Description			[nvarchar] (50)			NOT NULL,			-- 描述;
	FA_RecordDate			[nvarchar] (24)			NOT NULL,			-- 登记日期;
	FA_UseState				[tinyint] DEFAULT(0)	NOT NULL,			-- 使用状态;
	FA_Etalon				[nvarchar] (50)			NULL,				-- 规格;
	FA_PurchaseDate			[nvarchar] (24)			NULL,				-- 购买日期;
	FA_BuyingPrice			[money]	DEFAULT(0)		NULL,				-- 购买价格;
	FA_PurchaseQuantity		[int] DEFAULT(0)		NOT NULL,			-- 购买数量;
	FA_Guardian				[nvarchar] (50)			NOT NULL,			-- 保管员;
	FA_Storage				[nvarchar] (50)			NULL,				-- 存放点;	
	FA_Remarks				[nvarchar] (max)		NULL,				-- 备注;
	FA_Image				[image]					NULL				-- 物品相片;
)