/****** Object:  Table [dbo].[Base_Class]    Script Date: 05/18/2008 22:15:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Base_Class](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[sub_type] [int] NOT NULL,
 CONSTRAINT [PK_Base_Class] PRIMARY KEY CLUSTERED 
(
	[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:  Index [idx_base_class_id_sub_type]    Script Date: 05/18/2008 22:16:34 ******/
CREATE UNIQUE NONCLUSTERED INDEX [idx_base_class_id_sub_type] ON [dbo].[Base_Class] 
(
	[id] ASC,
	[sub_type] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

CREATE TABLE [dbo].[Inheriting_Class_A](
	[base_class_id] [int] NOT NULL,
 CONSTRAINT [PK_Inheriting_Class_A] PRIMARY KEY CLUSTERED 
(
	[base_class_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 [dbo].[Inheriting_Class_A]  WITH CHECK ADD  CONSTRAINT [FK_Inheriting_Class_A_Base_Class] FOREIGN KEY([base_class_id])
REFERENCES [dbo].[Base_Class] ([id])
GO
ALTER TABLE [dbo].[Inheriting_Class_A] CHECK CONSTRAINT [FK_Inheriting_Class_A_Base_Class]
GO

CREATE TABLE [dbo].[Inheriting_Class_B](
	[base_class_id] [int] NOT NULL,
 CONSTRAINT [PK_Inheriting_Class_B] PRIMARY KEY CLUSTERED 
(
	[base_class_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 [dbo].[Inheriting_Class_B]  WITH CHECK ADD  CONSTRAINT [FK_Inheriting_Class_B_Base_Class] FOREIGN KEY([base_class_id])
REFERENCES [dbo].[Base_Class] ([id])
GO
ALTER TABLE [dbo].[Inheriting_Class_B] CHECK CONSTRAINT [FK_Inheriting_Class_B_Base_Class]
GO

CREATE TABLE [dbo].[Inheriting_Class_C](
	[base_class_id] [int] NOT NULL,
 CONSTRAINT [PK_Inheriting_Class_C] PRIMARY KEY CLUSTERED 
(
	[base_class_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 [dbo].[Inheriting_Class_C]  WITH CHECK ADD  CONSTRAINT [FK_Inheriting_Class_C_Base_Class] FOREIGN KEY([base_class_id])
REFERENCES [dbo].[Base_Class] ([id])
GO
ALTER TABLE [dbo].[Inheriting_Class_C] CHECK CONSTRAINT [FK_Inheriting_Class_C_Base_Class]
GO