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