create database ticketsManager;

create table employees(
    id_employee int generated always as identity (increment by 1),
    name text,
    surname text,
    grade int,
    constraint pk_employee primary key (id_employee)
);

CREATE TABLE tickets (
    id_ticket int,
    title text,
    buying_date date,
    id_employee int,
    constraint pk_ticket primary key (id_ticket),
    constraint fk_ticket foreign key (id_employee) references employees
);


create table admins(
    username text,
    password text,
    constraint pk_admin primary key (username)
);