Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [NN]
- GO
- /****** Object: Table [dbo].[PAYSUMMA] Script Date: 25.10.2014 13:32:49 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_PADDING ON
- GO
- CREATE TABLE [dbo].[PAYSUMMA](
- [PAYFACTCD] [dbo].[PKFIELD] NOT NULL,
- [ACCOUNTCD] [varchar](6) NOT NULL,
- [SERVICECD] [dbo].[PKFIELD] NOT NULL,
- [PAYSUM] [dbo].[CASH] NULL,
- [PAYDATE] [date] NULL,
- [PAYMONTH] [dbo].[TMONTH] NULL,
- [PAYYEAR] [dbo].[ TYEAR] NULL,
- CONSTRAINT [PK_PAYSUMMA] PRIMARY KEY CLUSTERED
- (
- [PAYFACTCD] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- GO
- SET ANSI_PADDING OFF
- GO
- ALTER TABLE [dbo].[PAYSUMMA] WITH CHECK ADD CONSTRAINT [FK_PAYSUMMA_ABONENT1] FOREIGN KEY([ACCOUNTCD])
- REFERENCES [dbo].[ABONENT] ([ACCOUNTCD])
- ON UPDATE CASCADE
- GO
- ALTER TABLE [dbo].[PAYSUMMA] CHECK CONSTRAINT [FK_PAYSUMMA_ABONENT1]
- GO
- ALTER TABLE [dbo].[PAYSUMMA] WITH CHECK ADD CONSTRAINT [FK_PAYSUMMA_SERVICES] FOREIGN KEY([SERVICECD])
- REFERENCES [dbo].[SERVICES] ([SERVICECD])
- ON UPDATE CASCADE
- GO
- ALTER TABLE [dbo].[PAYSUMMA] CHECK CONSTRAINT [FK_PAYSUMMA_SERVICES]
- GO
- ALTER TABLE [dbo].[PAYSUMMA] WITH CHECK ADD CHECK (([PAYMONTH]>=(1) AND [PAYMONTH]<=(12)))
- GO
- ALTER TABLE [dbo].[PAYSUMMA] WITH CHECK ADD CHECK (([PAYYEAR]>=(1990) AND [PAYYEAR]<=(2100)))
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement