create table member (
create_date datetime(6),
last_modified_date datetime(6),
member_company varchar(255),
member_email_address varchar(255) not null,
member_id varchar(255) not null,
member_name varchar(255),
member_password varchar(255) not null,
member_phone_number varchar(255) not null,
member_status enum ('ADMIN','USER'),
primary key (member_id)
) engine=InnoDB
create table payment (
payment_fee integer,
payment_id bigint not null auto_increment,
member_id varchar(255),
payment_month varchar(255),
payment_status enum ('NONPAYMENT','PAID'),
payment_year varchar(255),
primary key (payment_id)
) engine=InnoDB
create table subscription_admin (
subs_cancel_date date,
subs_capacity integer,
subs_capacity_fee integer,
subs_date date,
subs_user integer,
subs_user_fee integer,
subs_id bigint not null auto_increment,
member_id varchar(255),
subs_status enum ('APPR','CANCEL','NONE','RESUBS','SUBS'),
primary key (subs_id)
) engine=InnoDB
create table subscription_user (
subs_capacity integer,
subs_capacity_fee integer,
subs_date date,
subs_user integer,
subs_user_fee integer,
subs_id bigint not null auto_increment,
member_id varchar(255),
subs_status enum ('APPR','CANCEL','NONE','RESUBS','SUBS'),
primary key (subs_id)
) engine=InnoDB
alter table if exists subscription_user
add constraint UK_nf8rxgf47ptkdws3gtgd66690 unique (member_id)
alter table if exists payment
add constraint FK4pswry4r5sx6j57cdeulh1hx8
foreign key (member_id)
references member (member_id)
alter table if exists subscription_admin
add constraint FKqgva7ns95f6tcq89ghphu5nb8
foreign key (member_id)
references member (member_id)
alter table if exists subscription_user
add constraint FKl93dylkomcs2f6wdiexicf3ty
foreign key (member_id)
references member (member_id)