Tables [dbo].[RPPres_Accounts]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:43 AM Thursday, March 21, 2019
Last Modified1:13:58 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_RPPres_Accounts: AccountIDAccountIDint4
False
1 - 1
AccountNumbervarchar(64)64
True
Descriptionvarchar(64)64
True
ISTypevarchar(64)64
True
Distributebit1
True
OrderBYint4
True
Foreign Keys FK_RPPres_Accounts_PresTypeID_RPPresTypes: [dbo].[RPPresTypes].PresTypeIDPresTypeIDint4
False
((1))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_RPPres_Accounts: AccountIDPK_RPPres_AccountsAccountID
True
80
NameColumns
FK_RPPres_Accounts_PresTypeID_RPPresTypesPresTypeID->[dbo].[RPPresTypes].[PresTypeID]
CREATE TABLE [dbo].[RPPres_Accounts]
(
[AccountID] [int] NOT NULL IDENTITY(1, 1),
[AccountNumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ISType] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Distribute] [bit] NULL,
[OrderBY] [int] NULL,
[PresTypeID] [int] NOT NULL CONSTRAINT [DF_RPPres_Accounts_PresTypeID] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPPres_Accounts] ADD CONSTRAINT [PK_RPPres_Accounts] PRIMARY KEY CLUSTERED  ([AccountID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPPres_Accounts] ADD CONSTRAINT [FK_RPPres_Accounts_PresTypeID_RPPresTypes] FOREIGN KEY ([PresTypeID]) REFERENCES [dbo].[RPPresTypes] ([PresTypeID])
GO