Tables [dbo].[CoUserBranches]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:07 AM Thursday, March 21, 2019
Last Modified1:10:35 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_CoUserBranches: UserBranchIDUserBranchIDint4
False
1 - 1
UserIDvarchar(8)8
False
Foreign Keys FK_CoUserBranches_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_CoUserBranches: UserBranchIDPK_CoUserBranchesUserBranchID
True
80
NameColumns
FK_CoUserBranches_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
CREATE TABLE [dbo].[CoUserBranches]
(
[UserBranchID] [int] NOT NULL IDENTITY(1, 1),
[UserID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BranchID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CoUserBranches] ADD CONSTRAINT [PK_CoUserBranches] PRIMARY KEY CLUSTERED  ([UserBranchID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CoUserBranches] ADD CONSTRAINT [FK_CoUserBranches_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO