CREATE TABLE [dbo].[BRONEERING] (
    [BRONEERING_ID]  INT      IDENTITY (1, 1) NOT NULL,
    [ISIK_ID_FK]     INT      NOT NULL,
    [TEENUSED_ID_FK] INT      NOT NULL,
    [Kuupaev]        DATE     NOT NULL,
    [Aeg]            TIME (7) NOT NULL,
    [Kogus]          INT      NOT NULL,
    PRIMARY KEY CLUSTERED ([BRONEERING_ID] ASC),
    CONSTRAINT [FK_BRONEERING_ISIK] FOREIGN KEY ([ISIK_ID_FK]) REFERENCES [dbo].[ISIK] ([ISIK_ID]),
    CONSTRAINT [FK_BRONEERING_TEENUSED] FOREIGN KEY ([TEENUSED_ID_FK]) REFERENCES [dbo].[TEENUSED] ([TEENUSED_ID])
);