[dbo].[Fields]

(local) > SupportBridge > Tables > dbo.Fields

Properties
Columns
Indexes
SQL Script
Uses
Used By

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	20
Created	12:44:45 PM Thursday, October 04, 2007
Last Modified	12:44:46 PM Thursday, October 04, 2007

Columns

Name	Data Type	Max Length (Bytes)	Identity
fieldID	int	4	1 - 1
fieldType	int	4
divisionID	int	4
fieldName	nvarchar(50)	100
fieldOrder	int	4
mandatory	int	4
active	int	4
displayName	nvarchar(150)	300

Indexes

	Name	Columns	Unique
	pk_fields	fieldID

SQL Script

CREATE TABLE [dbo].[Fields]
(
[fieldID] [int] NOT NULL IDENTITY(1, 1),
[fieldType] [int] NOT NULL,
[divisionID] [int] NOT NULL,
[fieldName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fieldOrder] [int] NOT NULL,
[mandatory] [int] NOT NULL,
[active] [int] NOT NULL,
[displayName] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Fields] ADD CONSTRAINT [pk_fields] PRIMARY KEY CLUSTERED ([fieldID]) ON [PRIMARY]
GO

Uses

Used By