17 lines
717 B
Transact-SQL
17 lines
717 B
Transact-SQL
CREATE TABLE [dbo].[RepoCompany] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[Name] NVARCHAR (100) NOT NULL,
|
|
[Email] NVARCHAR (255) NULL,
|
|
[Address_Line_1] NVARCHAR (255) NULL,
|
|
[Address_Line_2] NVARCHAR (255) NULL,
|
|
[City] NVARCHAR (255) NULL,
|
|
[State] NVARCHAR (255) NULL,
|
|
[ZIP] NVARCHAR (10) NULL,
|
|
[Country] NVARCHAR (255) NULL,
|
|
[Phone] NVARCHAR (255) NULL,
|
|
[Fax] NVARCHAR (255) NULL,
|
|
[DisabledDate] DATETIME NULL,
|
|
[DisabledBy] NVARCHAR (255) NULL,
|
|
[ReferenceId] INT NULL,
|
|
CONSTRAINT [PK_RepoCompany] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
); |