CREATE TABLE [dbo].[Pacient]
(
    [user] VARCHAR(50) NOT NULL ,
    [parola] VARCHAR(50) NOT NULL,
    [nume] VARCHAR(50) NOT NULL,
    [mail] VARCHAR(255) NOT NULL,
    [userMedic] VARCHAR(50) NOT NULL,
    [CNP] VARCHAR(13) NOT NULL,
    [Alergi] VARCHAR(255) NULL,
    [Recomandari] VARCHAR(500) NULL,
    CONSTRAINT [medic-pacient] FOREIGN KEY ([userMedic]) REFERENCES [Medic]([user]),
    CONSTRAINT [PK_Pacient] PRIMARY KEY ([user])
)