1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111
|
CREATE TABLE [dbo].[T_SEASON_SEA](
[SEA_ID] [smallint] IDENTITY(-32768,1) NOT NULL,
[SEA_CODE] [smallint] NOT NULL,
[SEA_NAME] [varchar](50) NOT NULL,
[SEA_YEAR] [smallint] NOT NULL,
CONSTRAINT [PK_T_SEASON_SEA] PRIMARY KEY CLUSTERED
(
[SEA_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY],
CONSTRAINT [AK_SEA_CODE_SEA_YEAR] UNIQUE NONCLUSTERED
(
[SEA_CODE] ASC,
[SEA_YEAR] 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
/****** Object: Table [S_PROMO].[T_PERCENTAGE_OWN_PEO] Script Date: 5/08/2014 12:09:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [S_PROMO].[T_PERCENTAGE_OWN_PEO](
[PEO_ID] [int] IDENTITY(-2147483648,1) NOT NULL,
[PEO_PERCENTAGE] [decimal](4, 2) NOT NULL,
[DTO_ID] [int] NOT NULL,
CONSTRAINT [PK_T_PERCENTAGE_OWN_PEO] PRIMARY KEY CLUSTERED
(
[PEO_ID] 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
/****** Object: Table [S_PROMO].[T_SEASON_GROUP_SGP] Script Date: 5/08/2014 12:09:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [S_PROMO].[T_SEASON_GROUP_SGP](
[SGP_ID] [int] IDENTITY(-2147483648,1) NOT NULL,
[PEO_ID] [int] NOT NULL,
CONSTRAINT [PK_T_SEASON_GROUP_SGP] PRIMARY KEY CLUSTERED
(
[SGP_ID] 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
/****** Object: Table [S_PROMO].[TJ_SGP_SEA_JSS] Script Date: 5/08/2014 12:09:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [S_PROMO].[TJ_SGP_SEA_JSS](
[SGP_ID] [int] NOT NULL,
[SEA_ID] [smallint] NOT NULL,
CONSTRAINT [PK_TJ_SGP_SEA_JSS] PRIMARY KEY CLUSTERED
(
[SGP_ID] ASC,
[SEA_ID] 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
ALTER TABLE [S_PROMO].[T_PERCENTAGE_OWN_PEO] WITH CHECK ADD CONSTRAINT [FK_T_PERCENTAGE_OWN_PEO_T_DETAIL_OWN_DTO] FOREIGN KEY([DTO_ID])
REFERENCES [S_PROMO].[T_DETAIL_OWN_DTO] ([DTO_ID])
GO
ALTER TABLE [S_PROMO].[T_PERCENTAGE_OWN_PEO] CHECK CONSTRAINT [FK_T_PERCENTAGE_OWN_PEO_T_DETAIL_OWN_DTO]
GO
ALTER TABLE [S_PROMO].[T_SEASON_GROUP_SGP] WITH CHECK ADD CONSTRAINT [FK_T_SEASON_GROUP_SGP_T_PERCENTAGE_OWN_PEO] FOREIGN KEY([PEO_ID])
REFERENCES [S_PROMO].[T_PERCENTAGE_OWN_PEO] ([PEO_ID])
GO
ALTER TABLE [S_PROMO].[T_SEASON_GROUP_SGP] CHECK CONSTRAINT [FK_T_SEASON_GROUP_SGP_T_PERCENTAGE_OWN_PEO]
GO
ALTER TABLE [S_PROMO].[TJ_SGP_SEA_JSS] WITH CHECK ADD CONSTRAINT [FK_TJ_SGP_SEA_JSS_T_SEASON_GROUP_SGP] FOREIGN KEY([SGP_ID])
REFERENCES [S_PROMO].[T_SEASON_GROUP_SGP] ([SGP_ID])
GO
ALTER TABLE [S_PROMO].[TJ_SGP_SEA_JSS] CHECK CONSTRAINT [FK_TJ_SGP_SEA_JSS_T_SEASON_GROUP_SGP]
GO
ALTER TABLE [S_PROMO].[TJ_SGP_SEA_JSS] WITH CHECK ADD CONSTRAINT [FK_TJ_SGP_SEA_JSS_T_SEASON_SEA] FOREIGN KEY([SEA_ID])
REFERENCES [dbo].[T_SEASON_SEA] ([SEA_ID])
GO
ALTER TABLE [S_PROMO].[TJ_SGP_SEA_JSS] CHECK CONSTRAINT [FK_TJ_SGP_SEA_JSS_T_SEASON_SEA]
GO
ALTER TABLE [dbo].[T_SEASON_SEA] WITH CHECK ADD CONSTRAINT [CK_YEAR_EXISTS] CHECK (([DBO].[UF_CHECK_IF_YEAR_EXISTS]([SEA_YEAR])=(1)))
GO
ALTER TABLE [dbo].[T_SEASON_SEA] CHECK CONSTRAINT [CK_YEAR_EXISTS]
GO |
Partager