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)