sleep

Tables (5)

CHARCTER (멤버 등급)

  • CHARACTER_ID (Field) — INTEGER — Primary key
  • MEMBER_ID (Field3) — INTEGER — Foreign key → MEMBER.MEMBER_ID
  • SCORE (Field2) — TINYINT

DIARY (감사일기)

  • DIARY_ID (Field) — INTEGER — Primary key
  • MEMBER_ID (Field3) — INTEGER — Foreign key → MEMBER.MEMBER_ID
  • CONTENT (Field2) — STRING
  • CREATED_AT (Field4) — TIMESTAMP
  • MODIFIED_AT (Field5) — TIMESTAMP

MEMBER (유저)

  • MEMBER_ID (Field) — INTEGER — Primary key
  • ID (Field2) — STRING
  • PASSWORD (Field3) — STRING
  • NICKNAME (Field4) — STRING
  • AGE (Field5) — TINYINT

SLEEP (실제 수면 관리)

  • CHARACTER_ID (Field) — INTEGER — Primary key
  • MEMBER_ID (Field3) — INTEGER — Foreign key → MEMBER.MEMBER_ID
  • SLEEP_TIME (Field2) — DATETIME
  • END_TIME (Field4) — DATETIME

SLEEP_ADVISOR (목표시간관리)

  • SLEEP_ADVISOR_ID (Field) — INTEGER — Primary key
  • MEMBER_ID (Field3) — INTEGER — Foreign key → MEMBER.MEMBER_ID
  • GOAL_SLEEP_TIME (Field2) — TIME
  • GOAL_WAKEUP_TIME (Field4) — TIME