/****** Object:  Table [dbo].[tbl_Dogovor]    Script Date: 03/26/2012 22:40:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbl_Dogovor](
	[DG_CODE] [varchar](10) NOT NULL,
	[DG_TURDATE] [datetime] NOT NULL,
	[DG_TRKEY] [int] NULL,
	[DG_CNKEY] [int] NOT NULL,
	[DG_CTKEY] [int] NOT NULL,
	[DG_NMEN] [smallint] NULL,
	[DG_PRICE] [money] NOT NULL,
	[DG_PAYED] [money] NULL,
	[DG_NDAY] [smallint] NULL,
	[DG_MAINMEN] [varchar](45) NULL,
	[DG_MAINMENPHONE] [varchar](50) NULL,
	[DG_MAINMENADRESS] [varchar](70) NULL,
	[DG_MAINMENPASPORT] [varchar](70) NULL,
	[DG_PARTNERKEY] [int] NULL,
	[DG_OPERATOR] [varchar](25) NULL,
	[DG_PRINTDOGOVOR] [smallint] NULL,
	[DG_PRINTVAUCHER] [smallint] NULL,
	[DG_TYPECOUNT] [smallint] NULL,
	[DG_DISCOUNT] [money] NULL,
	[DG_DISCOUNTSUM] [money] NOT NULL,
	[DG_CREATOR] [int] NOT NULL,
	[DG_OWNER] [int] NOT NULL,
	[DG_SOR_CODE] [int] NOT NULL,
	[DG_CRDATE] [datetime] NOT NULL,
	[DG_RATE] [varchar](3) NULL,
	[DG_ADVERTISE] [int] NULL,
	[DG_LOCKED] [smallint] NULL,
	[DG_CAUSEDISC] [int] NULL,
	[DG_VISADATE] [datetime] NULL,
	[DG_PPAYMENTDATE] [datetime] NULL,
	[DG_PAYMENTDATE] [datetime] NULL,
	[DG_TURPUTDATE] [datetime] NULL,
	[DG_DOCUMENT] [varchar](250) NULL,
	[DG_TURPUTPLACE] [varchar](128) NULL,
	[DG_PROCENT] [int] NULL,
	[DG_OLDTOURDATE] [datetime] NULL,
	[ROWID] [timestamp] NULL,
	[DG_TurDateBfrAnnul] [datetime] NULL,
	[DG_ARKey] [int] NULL,
	[DG_Key] [int] NOT NULL,
	[DG_CodePartner] [varchar](20) NULL,
	[DG_FilialKey] [int] NOT NULL,
	[DG_IsOutDoc] [int] NOT NULL,
	[DG_AgentID] [int] NULL,
	[DG_TRANSFERRED] [smallint] NULL,
	[DG_NOTES] [varchar](250) NULL,
	[DG_INVOICECOST] [varchar](80) NULL,
	[DG_DCRCLIENT] [int] NULL,
	[DG_DCRPAYMENT] [int] NULL,
	[DG_ISMAKEDISCOUNT] [int] NULL,
	[DG_DISCSUMBFRANN] [money] NULL,
	[DG_PRICEBFRANN] [money] NULL,
	[DG_RazmerP] [money] NULL,
	[DG_FINISHEMAILING] [smallint] NULL,
	[DG_LASTSTATUSSEND] [smallint] NULL,
	[DG_LEADDEPARTMENT] [int] NOT NULL,
	[DG_MAINMENEMAIL] [varchar](50) NULL,
	[DG_MAINMENCOMMENT] [varchar](50) NULL,
	[DG_DUPUSERKEY] [int] NULL,
	[DG_BTKEY] [int] NULL,
	[DG_ConfirmedDate] [smalldatetime] NULL,
	[DG_PRTDOGKEY] [int] NOT NULL,
	[DG_CTDepartureKey] [int] NULL,
	[DG_SalePrice] [money] NULL,
	[DG_SaleDiscount] [money] NULL,
	[DG_PDTType] [smallint] NOT NULL,
 CONSTRAINT [PK_tbl_Dogovor] PRIMARY KEY CLUSTERED
(
	[DG_Key] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 70) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tbl_Dogovor]  WITH NOCHECK ADD  CONSTRAINT [AX_DG_FilialKey] FOREIGN KEY([DG_FilialKey])
REFERENCES [dbo].[tbl_Partners] ([PR_KEY])
GO

ALTER TABLE [dbo].[tbl_Dogovor] CHECK CONSTRAINT [AX_DG_FilialKey]
GO

ALTER TABLE [dbo].[tbl_Dogovor] ADD  CONSTRAINT [DF_Dogovor_DG_DISCOUNTSUM]  DEFAULT (0) FOR [DG_DISCOUNTSUM]
GO

ALTER TABLE [dbo].[tbl_Dogovor] ADD  CONSTRAINT [DF__tbl_Dogov__DG_AR__51851410]  DEFAULT (0) FOR [DG_ARKey]
GO

ALTER TABLE [dbo].[tbl_Dogovor] ADD  CONSTRAINT [DF__tbl_dogov__DG_Is__569ECEE8]  DEFAULT (0) FOR [DG_IsOutDoc]
GO

ALTER TABLE [dbo].[tbl_Dogovor] ADD  CONSTRAINT [DF_tbl_Dogovor_DG_LASTSTATUSSEND]  DEFAULT (0) FOR [DG_LASTSTATUSSEND]
GO

ALTER TABLE [dbo].[tbl_Dogovor] ADD  DEFAULT (0) FOR [DG_LEADDEPARTMENT]
GO

ALTER TABLE [dbo].[tbl_Dogovor] ADD  CONSTRAINT [DF_Dogovor_DG_PrtDogKey]  DEFAULT (0) FOR [DG_PRTDOGKEY]
GO

ALTER TABLE [dbo].[tbl_Dogovor] ADD  DEFAULT (0) FOR [DG_PDTType]
GO