CREATE TABLE G2BCruiseOnBoardCurrency ( G2BCruiseId BIGINT NOT NULL, CurrencyId SMALLINT NOT NULL, CONSTRAINT PK_G2BCruiseOnBoardCurrency PRIMARY KEY NONCLUSTERED(G2BCruiseId ASC, CurrencyId ASC), CONSTRAINT FK_G2BCruiseOnBoardCurrency_G2BCruise FOREIGN KEY (G2BCruiseId) REFERENCES dbo.G2BCruise(G2BCruiseId), CONSTRAINT FK_G2BCruiseOnBoardCurrency_G2BMCurrency FOREIGN KEY (CurrencyId) REFERENCES dbo.G2BMCurrency(CurrencyId) )