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)