Tables [dbo].[RPPres_AllocationDetails]
PropertyValue
HeapTrue
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 Nulls
Foreign Keys FK_RPPres_AllocationDetails_AllocationID_RPPres_Allocations: [dbo].[RPPres_Allocations].AllocationIDAllocationIDint4
True
Foreign Keys FK_RPPres_AllocationDetails_RPPresModelTypeID_RPPres_ModelTypes: [dbo].[RPPres_ModelTypes].RPPresModelTypeIDRPPresModelTypeIDint4
True
Percentagedecimal(10,4)9
True
NameColumns
FK_RPPres_AllocationDetails_AllocationID_RPPres_AllocationsAllocationID->[dbo].[RPPres_Allocations].[AllocationID]
FK_RPPres_AllocationDetails_RPPresModelTypeID_RPPres_ModelTypesRPPresModelTypeID->[dbo].[RPPres_ModelTypes].[ModelTypeID]
CREATE TABLE [dbo].[RPPres_AllocationDetails]
(
[AllocationID] [int] NULL,
[RPPresModelTypeID] [int] NULL,
[Percentage] [decimal] (10, 4) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPPres_AllocationDetails] ADD CONSTRAINT [FK_RPPres_AllocationDetails_AllocationID_RPPres_Allocations] FOREIGN KEY ([AllocationID]) REFERENCES [dbo].[RPPres_Allocations] ([AllocationID])
GO
ALTER TABLE [dbo].[RPPres_AllocationDetails] ADD CONSTRAINT [FK_RPPres_AllocationDetails_RPPresModelTypeID_RPPres_ModelTypes] FOREIGN KEY ([RPPresModelTypeID]) REFERENCES [dbo].[RPPres_ModelTypes] ([ModelTypeID])
GO