TriDo

테이블 (5)

habit_levels

  • id — bigint(20) — 기본 키 — NOT NULL
  • habit_id — bigint(20) — 외래 키 → habits.id — NOT NULL
  • level — tinyint(3) — NOT NULL
  • content — text — NOT NULL
  • seq — tinyint(3) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

habits

  • id — bigint(20) — 기본 키 — NOT NULL
  • title — varchar(255) — NOT NULL
  • is_public — tinyint(1) — NOT NULL
  • is_template — tinyint(1) — NOT NULL
  • creator_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

level_logs

  • id — bigint(20) — 기본 키 — NOT NULL
  • log_id — bigint(20) — 외래 키 → habit_levels.id — NOT NULL
  • habit_level_id — bigint(20) — 외래 키 → logs.id — NOT NULL
  • is_checked — tinyint(1) — NOT NULL
  • log_date — date — NOT NULL
  • content — text — NOT NULL
  • seq — tinyint(3) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

logs

  • id — bigint(20) — 기본 키 — NOT NULL
  • habit_id — bigint(20) — 외래 키 → habits.id — NOT NULL
  • round — int(10) — NOT NULL
  • start_date — date — NOT NULL
  • end_date — date — NOT NULL
  • title — varchar(255) — NOT NULL
  • creator_id — bigint(20) — 외래 키 → 사용자.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

사용자 (users)

  • id — bigint(20) — 기본 키 — NOT NULL
  • 이름 (name) — varchar(255) — NOT NULL
  • 이메일 (email) — varchar(255) — NOT NULL
  • 비밀번호 (password) — varchar(255) — NOT NULL
  • 기억 토큰 (remember_token) — varchar(100)
  • 생성일시 (created_at) — timestamp
  • 수정일시 (updated_at) — timestamp
  • 삭제일시 (deleted_at) — timestamp