BD_LAB3_QUERY_CREARE_TABEL_ANGAJATI

USE companydb;

CREATE TABLE Angajati(
    AngajatID INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
    DepartamentID INT NOT NULL,
    SupervizorID INT NOT NULL,
    Nume VARCHAR(20) NOT NULL,
    Prenume VARCHAR(20) NOT NULL,
    CNP VARCHAR(13) NOT NULL UNIQUE,
    Strada VARCHAR(30) NOT NULL,
    Numar INT NOT NULL,
    Oras VARCHAR(20) NOT NULL,
    Judet VARCHAR(20) NOT NULL,
    Sex CHAR(1) CHECK([Sex] = 'F' OR [Sex] = 'M') DEFAULT('F'),
    DataNasterii DATETIME,
    Salariu INT NOT NULL
);