[dbo].[MilitaryAllocationItemCodeException]

Property	Value
Row Count (~)	0
Created	10:30:22 AM Monday, March 30, 2015
Last Modified	10:30:29 AM Monday, March 30, 2015

Property

Value

Row Count (~)

Created

10:30:22 AM Monday, March 30, 2015

Last Modified

10:30:29 AM Monday, March 30, 2015

	Name	Data Type	Max Length (Bytes)	Identity
	MilitaryAllocationItemCodeExceptionID	int	4	1 - 1
$Indexes IX_MilitaryAllocationItemCodeException_ExceptionType_PointOfService: MilitaryAllocationItemCodeFID\ExceptionTypeFID\PointOfServiceFID$	MilitaryAllocationItemCodeFID	int	4
$Indexes IX_MilitaryAllocationItemCodeException_ExceptionType_PointOfService: MilitaryAllocationItemCodeFID\ExceptionTypeFID\PointOfServiceFID$	ExceptionTypeFID	int	4
$Indexes IX_MilitaryAllocationItemCodeException_ExceptionType_PointOfService: MilitaryAllocationItemCodeFID\ExceptionTypeFID\PointOfServiceFID$	PointOfServiceFID	int	4
	PayAgentFID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

MilitaryAllocationItemCodeExceptionID

int

1 - 1

Foreign Keys FK_MilitaryAllocationItemCodeException_MilitaryAllocationItemCode: [dbo].[MilitaryAllocationItemCode].MilitaryAllocationItemCodeFID

$Indexes IX_MilitaryAllocationItemCodeException_ExceptionType_PointOfService: MilitaryAllocationItemCodeFID\ExceptionTypeFID\PointOfServiceFID$

MilitaryAllocationItemCodeFID

int

$Indexes IX_MilitaryAllocationItemCodeException_ExceptionType_PointOfService: MilitaryAllocationItemCodeFID\ExceptionTypeFID\PointOfServiceFID$

ExceptionTypeFID

int

$Indexes IX_MilitaryAllocationItemCodeException_ExceptionType_PointOfService: MilitaryAllocationItemCodeFID\ExceptionTypeFID\PointOfServiceFID$

PointOfServiceFID

int

PayAgentFID

int

	Name	Columns	Unique
	PK_MilitaryAllocationItemCodeException	MilitaryAllocationItemCodeExceptionID
	IX_MilitaryAllocationItemCodeException_ExceptionType_PointOfService	MilitaryAllocationItemCodeFID, ExceptionTypeFID, PointOfServiceFID

Name

Columns

Unique

PK_MilitaryAllocationItemCodeException

MilitaryAllocationItemCodeExceptionID

IX_MilitaryAllocationItemCodeException_ExceptionType_PointOfService

MilitaryAllocationItemCodeFID, ExceptionTypeFID, PointOfServiceFID

Name	Constraint
CK_MilitaryAllocationItemCodeException_ValidPayAgent	((0)=[dbo].[CheckAllocationExceptionValidPayAgent]([MilitaryAllocationItemCodeFID],[PayAgentFID]))

Name

Constraint

CK_MilitaryAllocationItemCodeException_ValidPayAgent

((0)=[dbo].[CheckAllocationExceptionValidPayAgent]([MilitaryAllocationItemCodeFID],[PayAgentFID]))

Name	Delete	Columns
FK_MilitaryAllocationItemCodeException_ExceptionType		ExceptionTypeFID->[dbo].[ExceptionType].[ExceptionTypeID]
FK_MilitaryAllocationItemCodeException_MilitaryAllocationItemCode	Cascade	MilitaryAllocationItemCodeFID->[dbo].[MilitaryAllocationItemCode].[MilitaryAllocationItemCodeID]
FK_MilitaryAllocationItemCodeException_PreferredRevenueAgent		PayAgentFID->[dbo].[PreferredRevenueAgent].[PreferredRevenueAgentID]
FK_MilitaryAllocationItemCodeException_PointOfService		PointOfServiceFID->[dbo].[PointOfService].[PointOfServiceID]

Name

Delete

Columns

FK_MilitaryAllocationItemCodeException_ExceptionType

ExceptionTypeFID->[dbo].[ExceptionType].[ExceptionTypeID]

FK_MilitaryAllocationItemCodeException_MilitaryAllocationItemCode

Cascade

MilitaryAllocationItemCodeFID->[dbo].[MilitaryAllocationItemCode].[MilitaryAllocationItemCodeID]

FK_MilitaryAllocationItemCodeException_PreferredRevenueAgent

PayAgentFID->[dbo].[PreferredRevenueAgent].[PreferredRevenueAgentID]

FK_MilitaryAllocationItemCodeException_PointOfService

PointOfServiceFID->[dbo].[PointOfService].[PointOfServiceID]

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

Type

Action

Owning Principal

Grant

Delete

MssExec

Grant

Insert

MssExec

Grant

Select

MssExec

Grant

Update

MssExec

SQL Script

CREATE TABLE [dbo].[MilitaryAllocationItemCodeException]
(
[MilitaryAllocationItemCodeExceptionID] [int] NOT NULL IDENTITY(1, 1),
[MilitaryAllocationItemCodeFID] [int] NOT NULL,
[ExceptionTypeFID] [int] NOT NULL,
[PointOfServiceFID] [int] NOT NULL,
[PayAgentFID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MilitaryAllocationItemCodeException] ADD CONSTRAINT [CK_MilitaryAllocationItemCodeException_ValidPayAgent] CHECK (((0)=[dbo].[CheckAllocationExceptionValidPayAgent]([MilitaryAllocationItemCodeFID],[PayAgentFID])))
GO
ALTER TABLE [dbo].[MilitaryAllocationItemCodeException] ADD CONSTRAINT [PK_MilitaryAllocationItemCodeException] PRIMARY KEY CLUSTERED  ([MilitaryAllocationItemCodeExceptionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MilitaryAllocationItemCodeException] ADD CONSTRAINT [IX_MilitaryAllocationItemCodeException_ExceptionType_PointOfService] UNIQUE NONCLUSTERED  ([MilitaryAllocationItemCodeFID], [ExceptionTypeFID], [PointOfServiceFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MilitaryAllocationItemCodeException] ADD CONSTRAINT [FK_MilitaryAllocationItemCodeException_ExceptionType] FOREIGN KEY ([ExceptionTypeFID]) REFERENCES [dbo].[ExceptionType] ([ExceptionTypeID])
GO
ALTER TABLE [dbo].[MilitaryAllocationItemCodeException] ADD CONSTRAINT [FK_MilitaryAllocationItemCodeException_MilitaryAllocationItemCode] FOREIGN KEY ([MilitaryAllocationItemCodeFID]) REFERENCES [dbo].[MilitaryAllocationItemCode] ([MilitaryAllocationItemCodeID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[MilitaryAllocationItemCodeException] ADD CONSTRAINT [FK_MilitaryAllocationItemCodeException_PreferredRevenueAgent] FOREIGN KEY ([PayAgentFID]) REFERENCES [dbo].[PreferredRevenueAgent] ([PreferredRevenueAgentID])
GO
ALTER TABLE [dbo].[MilitaryAllocationItemCodeException] ADD CONSTRAINT [FK_MilitaryAllocationItemCodeException_PointOfService] FOREIGN KEY ([PointOfServiceFID]) REFERENCES [dbo].[PointOfService] ([PointOfServiceID])
GO
GRANT SELECT ON  [dbo].[MilitaryAllocationItemCodeException] TO [MssExec]
GRANT INSERT ON  [dbo].[MilitaryAllocationItemCodeException] TO [MssExec]
GRANT DELETE ON  [dbo].[MilitaryAllocationItemCodeException] TO [MssExec]
GRANT UPDATE ON  [dbo].[MilitaryAllocationItemCodeException] TO [MssExec]
GO