16 lines
711 B
Transact-SQL
16 lines
711 B
Transact-SQL
CREATE TABLE [dbo].[Rate]
|
|
(
|
|
[RateId] INT NOT NULL PRIMARY KEY IDENTITY,
|
|
[RateUploadInfoId] INT NULL,
|
|
[ClosingRateUploadInfoId] INT NULL,
|
|
[Column] VARCHAR(50) NULL,
|
|
[Row] VARCHAR(50) NULL,
|
|
[RateSheetId] INT NOT NULL,
|
|
[Value] DECIMAL(18, 3) NOT NULL,
|
|
[RateStartDate] DATETIME2 NOT NULL,
|
|
[RateEndDate] DATETIME2 NULL,
|
|
CONSTRAINT [FK_Rate_RateUploadInfo] FOREIGN KEY ([RateUploadInfoId]) REFERENCES [RateUploadInfo]([RateUploadInfoId]),
|
|
CONSTRAINT [FK_Rate_ClosingRateUploadInfo] FOREIGN KEY ([ClosingRateUploadInfoId]) REFERENCES [RateUploadInfo]([RateUploadInfoId]),
|
|
CONSTRAINT [FK_Rate_RateSheet] FOREIGN KEY ([RateSheetId]) REFERENCES [RateSheet]([RateSheetId])
|
|
)
|