User

create table user
(
    created_date_time       datetime(6)                null,
    id                      bigint auto_increment
        primary key,
    last_modified_date_time datetime(6)                null,
    email                   varchar(255)               null,
    nickname                varchar(255)               null,
    password                varchar(255)               null,
    entity_status           enum ('ACTIVE', 'DELETED') null
);

Refresh_Token

create table refresh_token
(
    created_date_time       datetime(6)  null,
    last_modified_date_time datetime(6)  null,
    refresh_token_id        bigint auto_increment
        primary key,
    user_id                 bigint       null,
    token                   varchar(255) null
);

Product

create table product
(
    id    bigint auto_increment
        primary key,
    name  varchar(255) not null,
    stock int          not null,
    price int          not null
);

Payment

create table payment
(
    id                      bigint auto_increment
        primary key,
    created_date_time       datetime(6) null,
    last_modified_date_time datetime(6) null,
    quantity                int         not null,
    success                 bit         not null,
    total_price             int         not null,
    product_id              bigint      null,
    constraint FK95mdx4gcoy5aacmes6h5fxhwr
        foreign key (product_id) references product (id)
);