Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /****** 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement