hotel4eto 66 points

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     int     not null,
    emergency_name   varchar(50)     not null,
    emergency_number int     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', 21, 'sa', 123, 'dawda'),
       (2, 'sa', 'sa', 21, 'sa', 123, 'dawda'),
       (3, 'sa', 'sa', 21, 'sa', 123, 'dawda');

create table room_status
(
    room_status int not null,
    notes       blob not null
);

insert into room_status(room_status, notes)
values (1, 'daw'),
       (2, 'daw'),
       (3, 'daw');

create table room_types
(
    room_type varchar(50),
    notes     blob not null
);

insert into room_types(room_type, notes)
values ('zxc', 'daw'),
       ('zxc', 'daw'),
       ('zxc', 'daw');

create table bed_types
(
    bed_type varchar(50),
    notes    blob not null
);

insert into bed_types(bed_type, notes)
values ('top', 'da'),
       ('top', 'da'),
       ('top', 'da');

create table rooms
(
    room_number int primary key not null auto_increment,
    room_type   varchar(50)     not null,
    bed_type    varchar(50)     not null,
    rate        int             not null,
    room_status int     not null,
    notes       blob not null
);
insert into rooms(room_number, room_type, bed_type, rate, room_status, notes)
values (1, 'daw', 'da', 5, 32, 'dawd'),
       (2, 'daw', 'da', 5, 32, 'dawd'),
       (3, 'daw', 'da', 5, 32, 'dawd');

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');