source: src/FinkiChattery/FinkiChattery.Database/dbo/Tables/StudentTeam.sql@ e6a6d9a

CREATE TABLE [dbo].[StudentTeam] (
    [Id]        BIGINT           IDENTITY (1, 1) NOT NULL,
    [Uid]       UNIQUEIDENTIFIER NOT NULL,
    [StudentFk] BIGINT           NOT NULL,
    [TeamFk]    BIGINT           NOT NULL,
    CONSTRAINT [PK_StudentTeam] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_StudentTeam_Student_StudentFk] FOREIGN KEY ([StudentFk]) REFERENCES [dbo].[Student] ([Id]),
    CONSTRAINT [FK_StudentTeam_Team_TeamFk] FOREIGN KEY ([TeamFk]) REFERENCES [dbo].[Team] ([Id])
);


GO
CREATE NONCLUSTERED INDEX [IX_StudentTeam_StudentFk]
    ON [dbo].[StudentTeam]([StudentFk] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_StudentTeam_TeamFk]
    ON [dbo].[StudentTeam]([TeamFk] ASC);