코딧
테이블 (6)
Recommendation
- recommendation_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- subject_id — BIGINT — 외래 키 → Subject.subject_id
- reason — TEXT
- feedback — TEXT
- created_at — DATETIME
Schedule
- schedule_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- subject_id — BIGINT — 외래 키 → Subject.subject_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- schedule_date — DATE — NOT NULL
- start_time — TIME
- end_time — TIME
- memo — TEXT
- status — VARCHAR(20)
Study_Goal
- goal_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- subject_id — BIGINT — 외래 키 → Subject.subject_id
- goal_date — DATE — NOT NULL
- target_seconds — INT — NOT NULL
- achieved_seconds — INT
- achievement_rate — DOUBLE
Study_Record
- record_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- subject_id — BIGINT — 외래 키 → Subject.subject_id — NOT NULL
- study_date — DATE — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME
- duration_seconds — INT
Subject
- subject_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → User.user_id — NOT NULL
- subject_name — VARCHAR(100) — NOT NULL
- color — VARCHAR(30)
- target_time — INT
User
- user_id — BIGINT — 기본 키 — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- second_password — VARCHAR(255)
- fail_count — INT
- is_locked — BOOLEAN