코딧

테이블 (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