fos
Tables (5)
emoji_reactions
- id — BIGINT — Primary key — NOT NULL
- study_id — BIGINT — Foreign key → studies.id — NOT NULL
- emoji — VARCHAR(20) — NOT NULL
- count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
focus_sessions
- id — BIGINT — Primary key — NOT NULL
- study_id — BIGINT — Foreign key → studies.id — NOT NULL
- target_minutes — INT — NOT NULL
- earned_point — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- started_at — DATETIME
- completed_at — DATETIME
- created_at — DATETIME — NOT NULL
habit_records
- id — BIGINT — Primary key — NOT NULL
- habit_id — BIGINT — Foreign key → habits.id — NOT NULL
- record_date — DATE — NOT NULL
- is_checked — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
habits
- id — BIGINT — Primary key — NOT NULL
- study_id — BIGINT — Foreign key → studies.id — NOT NULL
- name — VARCHAR(20) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
studies
- id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT — NOT NULL
- background — VARCHAR(100)
- password_hash — VARCHAR(255) — NOT NULL
- point — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME