CREATE TABLE [dbo].[TaxableAuthorityType]
(
[TaxableAuthorityTypeID] [int] NOT NULL IDENTITY(1, 1),
[SalesTaxSetupFID] [int] NOT NULL,
[AuthorityTypeFID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TaxableAuthorityType] ADD CONSTRAINT [PK_TaxableAuthorityType] PRIMARY KEY NONCLUSTERED  ([TaxableAuthorityTypeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TaxableAuthorityType] ADD CONSTRAINT [IX_TaxableAuthorityType_AuthorityTypeFID] UNIQUE NONCLUSTERED  ([AuthorityTypeFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TaxableAuthorityType] ADD CONSTRAINT [FK_TaxableAuthorityType_AuthorityType] FOREIGN KEY ([AuthorityTypeFID]) REFERENCES [dbo].[AuthorityTypes] ([AuthPriKey])
GO
ALTER TABLE [dbo].[TaxableAuthorityType] ADD CONSTRAINT [FK_TaxableAuthorityType_SalesTaxSetup] FOREIGN KEY ([SalesTaxSetupFID]) REFERENCES [dbo].[SalesTaxSetup] ([SalesTaxSetupID])
GO
GRANT SELECT ON  [dbo].[TaxableAuthorityType] TO [MssExec]
GRANT INSERT ON  [dbo].[TaxableAuthorityType] TO [MssExec]
GRANT DELETE ON  [dbo].[TaxableAuthorityType] TO [MssExec]
GRANT UPDATE ON  [dbo].[TaxableAuthorityType] TO [MssExec]
GO