CREATE TABLE [dbo].[Parameters]
(
[paramID] [int] NOT NULL IDENTITY(1, 1),
[divisionID] [int] NOT NULL,
[fillerID] [int] NOT NULL,
[dataID] [int] NULL CONSTRAINT [DF__Parameter__dataI__06CD04F7] DEFAULT ((-1)),
[paramAlias] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[paramTitle] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[paramType] [int] NULL,
[paramValue] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[paramDesc] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Parameters] ADD CONSTRAINT [pk_parameters] PRIMARY KEY CLUSTERED ([paramID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Parameters] ADD CONSTRAINT [fk_parameters_div] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO
[dbo].[Parameters]
![Foreign Keys fk_parameters_div: [dbo].[Divisions].divisionID](../../Images/fk.gif)
