-- auto-generated definition
create table providers
(
    provider_id      int                                    not null
        primary key,
    tax_number       varchar(45) collate utf8mb4_general_ci null,
    live             tinyint(1) default 0                   not null,
    live_update      datetime                               null,
    live_location    point                                  null,
    called_flag      tinyint(1) default 0                   not null,
    interviewed_flag tinyint(1) default 0                   not null,
    reported_flag    tinyint(1) default 0                   not null,
    constraint provider_user
        foreign key (provider_id) references users (user_id)
            on update cascade on delete cascade
)
    charset = utf8mb4;