erd
Tables (7)
BODY_INFO
- body_no — number — Primary key — NOT NULL
- height — number(5,1) — NOT NULL
- weight — number(5,1) — NOT NULL
- muscle — number(5,1)
- fat — number(5,1)
- bmi_score — number(5,1)
- bmi_result — varchar2(100)
- check_date — date
- user_id — varchar2(50) — Foreign key → USERS.user_id — NOT NULL
INQUIRY
- inq_no — number(10) — Primary key — NOT NULL
- field — number
- title — varchar2(100) — NOT NULL
- content — varchar2(2000) — NOT NULL
- answer — varchar2(2000)
- reg_date — date — NOT NULL
- user_id — varchar2(50) — Foreign key → USERS.user_id — NOT NULL
PT_APPLICATION
- app_no — number — Primary key — NOT NULL
- app_date — date — NOT NULL
- program_no — number — Foreign key → PT_PROGRAM.program_no — NOT NULL
- user_id — varchar2(50) — Foreign key → USERS.user_id — NOT NULL
PT_PROGRAM
- program_no — number — Primary key — NOT NULL
- title — varchar2(100) — NOT NULL
- price — number — NOT NULL
- content — varchar2(2000) — NOT NULL
- capacity — number(1) — NOT NULL
- schedule — varchar2(100) — NOT NULL
- reg_date — date — NOT NULL
- user_id — varchar2(50) — Foreign key → USERS.user_id — NOT NULL
SUBSCRIPTION
- mem_num — number — Primary key — NOT NULL
- mem_reg_date — date
- mem_start_date — date
- mem_end_date — date
- pt_count — number(3)
- user_id — varchar2(50) — Foreign key → USERS.user_id — NOT NULL
TRAINER_INFO
- user_id — varchar2(50) — Foreign key → USERS.user_id — NOT NULL
- career — varchar2(2000)
- education — varchar2(1000)
- status — varchar2(100) — NOT NULL
USERS
- user_id — varchar2(50) — Primary key — NOT NULL
- user_pw — varchar2(100) — NOT NULL
- name — varchar2(50) — NOT NULL
- gender — char(1) — NOT NULL
- age — number(3) — NOT NULL
- phone — varchar2(20) — NOT NULL
- role — number(1) — NOT NULL
- reg_date — date — NOT NULL
- update_date — date — NOT NULL
- point — number