hotel s pulen broi tochki

create table employees
(
    id         int primary key not null auto_increment,
    first_name varchar(50)     not null,
    last_name  varchar(50)     not null,
    title      varchar(50)     not null,
    notes      blob not null
);

insert into employees(id, first_name, last_name, title, notes)
values (1, 'da', 'dwa', 'dad', 'dawda'),
       (2, 'da', 'dwa', 'dad', 'dawda'),
       (3, 'da', 'dwa', 'dad', 'dawda');

create table customers
(
    account_number   int primary key not null auto_increment,
    first_name       varchar(50)     not null,
    last_name        varchar(50)     not null,
    phone_number     varchar(50)     not null,
    emergency_name   varchar(50)     not null,
    emergency_number varchar(50)     not null,
    notes            blob not null
);
insert into customers(account_number,
                      first_name, last_name,
                      phone_number, emergency_name,
                      emergency_number, notes)
values (1, 'sa', 'sa', "1", 'sa', "1", 'dawda'),
       (2, 'sa', 'sa', "1", 'sa', "1", 'dawda'),
       (3, 'sa', 'sa', "1", 'sa', "1", 'dawda');

create table payments
(
    id                  int primary key not null auto_increment,
    employee_id         int             not null,
    payment_date        datetime        not null,
    account_number      int             not null,
    first_date_occupied date            not null,
    last_date_occupied  date            not null,
    total_days          int             not null,
    amount_charged      int             not null,
    tax_rate            int             not null,
    tax_amount          int             not null,
    payment_total       int             not null,
    notes               blob not null
);

insert into payments (id, employee_id, payment_date, account_number, first_date_occupied,
                      last_date_occupied, total_days, amount_charged, tax_rate, tax_amount, payment_total, notes)
values (1, 1, '2000-10-10', 5, '2000-10-10', '2000-10-10', 20, 10, 10, 10, 10, 'блоб'),
       (2, 1, '2000-10-10', 5, '2000-10-10', '2000-10-10', 20, 10, 10, 10, 10, 'блоб'),
       (3, 1, '2000-10-10', 5, '2000-10-10', '2000-10-10', 20, 10, 10, 10, 10, 'блоб');

create table occupancies
(
    id             int primary key not null auto_increment,
    employee_id    int             not null,
    date_occupied  date            not null,
    account_number int             not null,
    room_number    int             not null,
    rate_applied   int             not null,
    phone_charge   int             not null,
    notes          blob not null
);

insert into occupancies(id, employee_id, date_occupied, account_number,
                        room_number, rate_applied, phone_charge, notes)
values (1, 1, '2000-10-10', 1, 5, 1, 1, 'dawd'),
       (2, 1, '2000-10-10', 1, 5, 1, 1, 'dawd'),
       (3, 1, '2000-10-10', 1, 5, 1, 1, 'dawd');


create table room_status (
   room_status int not null,
   notes blob,
   primary key(room_status)
);
insert into room_status(room_status)values(1),(2),(3);

create table room_types(
   room_type INT not null,
   notes blob not null,
   primary key(room_type)
);
insert into room_types(room_type,notes)values(1,'sasas'),(2,'sasas'),(3,'sasasa');

create table bed_types(
  bed_type INT not null,
  notes blob not null,
  primary key(bed_type)
);
insert into bed_types(bed_type,notes)values(1,'sasas'),(2,'sasas'),(3,'sasasa');

create table rooms(
   room_number int not null,
   room_type varchar(50),
   bed_type varchar(50),
   rate varchar(50),
   room_status varchar(50),
   notes blob not null,
   primary key(room_number)
);
insert into rooms(room_number,notes)values(1,'sasas'),(2,'sasas'),(3,'sasasa');