StudyTimer

Tables (3)

date_plan

  • PK (id) — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • date — date
  • goal_time (goal_time (분:정수)) — int
  • study_time_by_hour — json
  • total_study_time (total_study_time (분:소수점)) — float

keyword

  • PK (id) — bigint — Primary key — NOT NULL
  • keywordName — varchar(20)

subject

  • PK (id) — bigint — Primary key — NOT NULL
  • FK (date_plan_id) — bigint — Foreign key → date_plan.PK — NOT NULL
  • FK (keyword_id) — bigint — Foreign key → keyword.PK — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • break_time (break_time (분:정수)) — int
  • completed — bit(1)
  • subject_goal_time (subject_goal_time (분:정수)) — int
  • subject_name — varchar(20)
  • subject_study_time (subject_study_time (분:소수점)) — float
  • started — bit(1)
  • on_list_view — bit(1)