StudyCheck

Tables (3)

Study

  • Key (user_id) — varchar(100) — Primary key — NOT NULL
  • Key (start_time) — varchar(14) — Primary key — NOT NULL
  • Field (end_time) — varchar(14)
  • Field (sys_fst_rg_ts) — timestamp
  • Field (sys_fst_rg_usid) — varchar(100)
  • Field (sys_lt_ch_ts) — timestamp
  • Field (sys_lt_ch_usid) — varchar(100)

StudyList

  • Key (user_id) — varchar(100) — Primary key — NOT NULL
  • Key (date) — varchar(8) — Primary key — NOT NULL
  • Field (study_time) — integer
  • Field (sys_fst_rg_ts) — timestamp
  • Field (sys_fst_rg_usid) — varchar(100)
  • Field (sys_lt_ch_ts) — timestamp
  • Field (sys_lt_ch_usid) — varchar(100)

User

  • key (user_id) — varchar(100) — Primary key — NOT NULL
  • Field (user_pw) — varchar(100)
  • Field2 (user_name) — varchar(100)
  • Field3 (phone_number) — varchar(100)
  • Field4 (end_yn) — varchar(1)
  • Field5 (member_start_date) — varchar(8)
  • Field (member_end_date) — varchar(8)
  • Field (sys_fst_rg_ts) — timestamp
  • Field (sys_fst_rg_usid) — varchar(100)
  • Field (sys_lt_ch_ts) — timestamp
  • Field (sys_lt_ch_usid) — varchar(100)