15 lines
457 B
Transact-SQL
15 lines
457 B
Transact-SQL
CREATE TABLE [dbo].[ApiConsumers]
|
|
(
|
|
[Id] INT NOT NULL IDENTITY,
|
|
[ApiIdentifier] UNIQUEIDENTIFIER NOT NULL DEFAULT NEWID(),
|
|
[ApiTypeId] TINYINT NOT NULL,
|
|
[IsEnabled] BIT NOT NULL,
|
|
|
|
CONSTRAINT [PK_ApiConsumers] PRIMARY KEY ([Id]),
|
|
CONSTRAINT [FK_ApiConsumers_ApiTypes] FOREIGN KEY ([ApiTypeId]) REFERENCES [_ApiTypes]([ApiTypeId])
|
|
)
|
|
|
|
GO
|
|
|
|
CREATE UNIQUE INDEX [IX_ApiConsumers_ApiIdentifier] ON [dbo].[ApiConsumers] ([ApiIdentifier])
|