DATABASE SECRETLAB

CREATE DATABASE [SecretLab]
GO
USE [SecretLab]
GO

CREATE TABLE [ListOfOrders](
    [id] INT PRIMARY KEY IDENTITY,
    [ORDER] NVARCHAR(50),
    [CreateDate] DATE NOT NULL
    )

CREATE TABLE [ListOfServices](
    [id] INT PRIMARY KEY IDENTITY,
    [Service] NVARCHAR(50),
    [Description] NVARCHAR(MAX),
    [Price] MONEY NOT NULL
    )

CREATE TABLE [ROLE](
    [id] INT PRIMARY KEY IDENTITY,
    [ROLE] NVARCHAR(20) NOT NULL
    )

CREATE TABLE [Users](
    [id] INT PRIMARY KEY IDENTITY,
    [FirstName] NVARCHAR(50) NOT NULL,
    [LastName] NVARCHAR(50) NOT NULL,
    [MiddleName] NVARCHAR(50) NOT NULL,
    [PassNum] NVARCHAR(15) NOT NULL,
    [InsurancePolicy] NVARCHAR(15) NOT NULL,
    [INN] NVARCHAR(15) NOT NULL,
    [Login] NVARCHAR(50) NOT NULL,
    [Password] NVARCHAR(50) NOT NULL,
    [E-mail] NVARCHAR(50) NOT NULL,
    [ListOfOrdersID] INT REFERENCES [ListOfOrders](id),
    [ListOfServices] INT REFERENCES [ListOfServices](id),
    [RoleID] INT REFERENCES [ROLE](id)
    )