17 lines
925 B
Transact-SQL
17 lines
925 B
Transact-SQL
CREATE TABLE [dbo].[Collaterals] (
|
|
[CollateralId] INT IDENTITY (1, 1) NOT NULL,
|
|
[RepoId] INT NOT NULL,
|
|
[VIN] NVARCHAR (100) NULL,
|
|
[Make] NVARCHAR (100) NULL,
|
|
[Model] NVARCHAR (100) NULL,
|
|
[Year] INT NULL,
|
|
[Description] NVARCHAR (255) NULL,
|
|
[VehicleType] INT NULL,
|
|
[BodyStyle] NVARCHAR (50) NULL,
|
|
[Inoperable] BIT NULL,
|
|
[RetitledInLandmarkName] DATETIME NULL,
|
|
[RefCollateralId] NVARCHAR (25) NULL,
|
|
[CollateralTypeId] INT NULL,
|
|
CONSTRAINT [PK_dbo.Collaterals] PRIMARY KEY CLUSTERED ([CollateralId] ASC),
|
|
CONSTRAINT [FK_dbo.Collaterals_dbo.Repoes_RepoId] FOREIGN KEY ([RepoId]) REFERENCES [dbo].[Repos] ([RepoId]) ON DELETE CASCADE
|
|
); |