lyfz_repos/经典版源码/document/数据库维护脚本/outlay(支出).sql

-- ============================================= 
-- 程序编写： Jeff
-- 版    本:  V 1.0
-- 建立日期： 2015-05-18
-- 功能说明： outlay支出;
-- 备    注： ;
-- 修改日期: 
-- 修改说明: 
-- =============================================  
set ansi_nulls on
go
set quoted_identifier on
go
set ansi_padding on
go

--支出详情表;
if not exists(select * from dbo.sysobjects where id = object_id(N'Outlay') and objectproperty(id,'IsTable') = 1)
begin
create table [dbo].[Outlay](
	[olid]					[int] identity(1,1) not null,				/* 支出id */
	[olname]				[nvarchar](24) not null,					/* 支出项目 */
	[olmoney]				[nvarchar](24) not null,					/* 支出金额 */
	[oldate]				[nvarchar](24) null,						/* 支出日期 */
	[olbz]					[varchar](max) NULL,						/* 支出备注 */
	[renyuan1]				[varchar](24) NULL,							/* 人员1-取款人 */
	[renyuan2]				[varchar](24) NULL,							/* 人员2-经手人 */
	[financecheck]			[nvarchar](10) NULL,						/* 财务审核 */
	[oltime]				[nvarchar](12) NULL,						/* 支出时间 */
	[photo]					[image] NULL,								/* 取款人 发票\收据\合同相片 */
	[financecheck2]			[nvarchar](50) NULL,						/* 财务审核2 */
	[financecheck3]			[nvarchar](50) NULL,						/* 财务审核3 */
	[hasphoto]				[bit] default(0) NULL						/* 是否有相片 */
) on [primary]
end
go

--支出根类别表;
if not exists(select * from dbo.sysobjects where id = object_id(N'OutlayRootConf') and objectproperty(id,'IsTable') = 1)
begin
create table [dbo].[OutlayRootConf](
	[olrcid]				[int] identity(1,1) not null,					-- 支出根类别id;
	[olrcname]				[nvarchar](24) not null							-- 支出根类别名;

	constraint [PK_OutlayRootConf] primary key clustered
	(
		[olrcid]
	)with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on,allow_page_locks = on) on [primary],

)on [primary]
end
go


--支出子类别表;
if not exists(select * from dbo.sysobjects where id = object_id(N'OutlaySubConf') and objectproperty(id,'IsTable') = 1)
begin
create table [dbo].[OutlaySubConf](
	[olsrid]				[int] not null,									-- 支出根类别id;
	[olscid]				[int] identity(1,1) not null,					-- 支出子类别id;
	[olscname]				[nvarchar](24) not null,						-- 支出子类别名;
	constraint [PK_OutlaySubConf] primary key clustered
	(
		[olscid]
	)with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on,allow_page_locks = on) on [primary],

)on [primary]
end
go

alter table OutlaySubConf 
with check add constraint [FK_OutlaySubConf] foreign key(olsrid)
references OutlayRootConf (olrcid)
go

drop table [OutlaySubConf]
drop table [OutlayRootConf]