9 lines
380 B
Transact-SQL
9 lines
380 B
Transact-SQL
CREATE TABLE [dbo].[ExchangeSymbols] (
|
|
[Symbol] VARCHAR (30) NOT NULL,
|
|
[ExchangeId] SMALLINT NOT NULL,
|
|
[SymbolAlias] VARCHAR (30) NULL,
|
|
CONSTRAINT [PK_ExchangeSymbols] PRIMARY KEY CLUSTERED ([Symbol] ASC, [ExchangeId] ASC),
|
|
CONSTRAINT [FK_ExchangeSymbols_ExchangeSymbols] FOREIGN KEY ([ExchangeId]) REFERENCES [dbo].[Exchanges] ([ExchangeId])
|
|
);
|
|
|