---

CREATE TABLE [dbo].[Orders] (
    [Id]             INT  IDENTITY (1, 1) NOT NULL,
    [IdOrder]        INT  NOT NULL,
    [ArticulId]      INT  NULL,
    [Count]          INT  NOT NULL,
    [DataOrder]      DATE NOT NULL,
    [DateDeliveries] DATE NOT NULL,
    [AddressPointId] INT  NULL,
    [IdUserId]       INT  NULL,
    [CodeForUser]    INT  NOT NULL,
    [Status]         INT  NOT NULL,
    CONSTRAINT [PK_Orders] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Orders_Address_AddressPointId] FOREIGN KEY ([AddressPointId]) REFERENCES [dbo].[Address] ([Id]),
    CONSTRAINT [FK_Orders_Tovars_ArticulId] FOREIGN KEY ([ArticulId]) REFERENCES [dbo].[Tovars] ([Id]),
    CONSTRAINT [FK_Orders_Users_IdUserId] FOREIGN KEY ([IdUserId]) REFERENCES [dbo].[Users] ([Id])
);


GO
CREATE NONCLUSTERED INDEX [IX_Orders_AddressPointId]
    ON [dbo].[Orders]([AddressPointId] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_Orders_ArticulId]
    ON [dbo].[Orders]([ArticulId] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_Orders_IdUserId]
    ON [dbo].[Orders]([IdUserId] ASC);