test
Tables (11)
MBR-profile
- User_serial_no — bigint — Foreign key → mbr_user.User_serial_no — NOT NULL
- user_email — varchar(50) — NOT NULL
- mbr_pwd — varchar(256)
- mbr_name — varchar(40) — NOT NULL
- mbr_nick_name — varchar(50) — NOT NULL
- mbr_birth_date — varchar(10) — NOT NULL
- mbr_gender — varchar — NOT NULL — 남자 : M 여자 : F
- mbr_phone_num — varchar(11) — NOT NULL
- mbr_addrress — varchar(150) — NOT NULL
- user_itrs — varchar(100) — NOT NULL
- user_reg_at — datetime — NOT NULL
- user_last_login_date — datetime — NOT NULL
- is_trainer — varchar(1) — NOT NULL
Trainer_management
- User_serial_no — bigint — Foreign key → mbr_user.User_serial_no — NOT NULL
- user_email — varchar(50) — NOT NULL
- mbr_pwd — varchar(256)
- mbr_name — varchar(40) — NOT NULL
- mbr_nick_name — varchar(50) — NOT NULL
- mbr_birth_date — varchar(10) — NOT NULL
- mbr_gender — varchar — NOT NULL — 남자 : M 여자 : F
- mbr_phone_num — varchar(11) — NOT NULL
- mbr_addrress — varchar(150) — NOT NULL
- user_itrs — varchar(100) — NOT NULL
- user_reg_at — datetime — NOT NULL
- user_last_login_date — datetime — NOT NULL
- is_trainer — varchar(1) — NOT NULL
User_serial_no
- User_serial_no — bigint — NOT NULL
- user_role — varchar(10) — NOT NULL — User / Trainer / admin
board_notice
- notice_no — int — Primary key — NOT NULL
- notice_title — varchar — NOT NULL
- notice_content — text — NOT NULL
- notice_read_count — int — NOT NULL
- notice_reg_date — datetime — NOT NULL
board_qna
- QNA_no — int — Primary key — NOT NULL
- QNA_title — varchar(100) — NOT NULL
- QNA_content — text — NOT NULL
- QNA_reg_date — datetime — NOT NULL
- QNA_answer_content — text — NOT NULL
- QNA_answer_status — varchar — NOT NULL
- User_serial_no2 — bigint — NOT NULL — 멤버 프로필
board_t_QNA
- QNA_no — int — Primary key — NOT NULL
- QNA_title — varchar(100) — NOT NULL
- QNA_content — text — NOT NULL
- QNA_reg_date — datetime — NOT NULL
- QNA_answer_content — text — NOT NULL
- QNA_answer_status — varchar — NOT NULL
- User_serial_no — bigint — NOT NULL — auto_increment
mbr_authorization
- User_serial_no2 — bigint — Foreign key → mbr_user.User_serial_no — NOT NULL
- User_name — varchar(20) — NOT NULL
- User_nick_name — varchar(20) — NOT NULL
- User_login_type — tinyint — 플랫폼:1 구글:2 네이버:3 카카오:4
mbr_excer_detail
- User_serial_no — bigint — Foreign key → mbr_user.User_serial_no — NOT NULL
- mbr_excer_detail — varchar(256) — NOT NULL
- mbr_profile_text — text — NOT NULL
- mbr_in_charge — varchar(40) — NOT NULL
- mbr_exp_exer — varchar(100) — NOT NULL
- mbr_exp_per — varchar(100) — NOT NULL
- mbr_exer_goal — varchar — NOT NULL
- mbr_bodyform_info — varchar(100) — NOT NULL
- mbr_case_his — varchar(50) — NOT NULL
- mbr_dir_exp — varchar(1) — NOT NULL — Y : N
- mbr_dir_exp_detail — varchar(100) — NOT NULL
mbr_profile_file
- user_uuid — varchar(256) — Primary key — NOT NULL
- save_dir — varchar(200) — NOT NULL
- file_name — varchar(150) — NOT NULL
- file_type — int — NOT NULL — 이미지 : 1 / 파일 : 0
- file_size — bigint — NOT NULL
- file_reg_at — datetime — NOT NULL
- User_serial_no — bigint — NOT NULL — auto_increment
mbr_user
- User_serial_no — bigint — Primary key — NOT NULL — auto_increment
- User_name — varchar(20) — NOT NULL
- User_nick_name — varchar(20) — NOT NULL
- User_login_type — tinyint — 플랫폼:1 구글:2 네이버:3 카카오:4
plaform_data
- date — date — Primary key — NOT NULL — 일일단위 종합, 시간단위로 갱신하고, 일자가 달라지면 reg
- day_user_count — int — NOT NULL
- day_new_user_count — int — NOT NULL
- day_new_trainer_count — int — NOT NULL
- day_payment_count — int
- day_pay_total — int