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