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