Weekedule
테이블 (7)
방 (Room)
- Key (id) — VARCAHR(36) — 기본 키 — NOT NULL
- Field (name) — VARCHAR(100) — NOT NULL
- Field2 (description) — TEXT
- Field3 (status) — VARCHAR(20) — NOT NULL — active/waiting/archived
- Field4 (color) — VARCHAR(30)
- Field5 (icon) — VARCHAR(30)
- Field6 (heatmap_color) — VARCHAR(20)
- Field7 (next_sync) — VARCHAR(10)
- Field8 (next_sync_day) — VARCHAR(20)
- Field9 (created_at) — DATETIME — NOT NULL
방 인원 (RoomMember)
- Key (id) — VARCHAR(36) — 기본 키 — NOT NULL
- Field (room_id) — VARCHAR(36) — NOT NULL — fk->Room.id
- Field2 (name) — VARCHAR(50) — NOT NULL
- Field3 (initials) — VARCHAR(5)
- Field4 (color_id) — VARCHAR(20)
사용자 (User)
- Key (id) — VARCHAR(36) — 기본 키 — NOT NULL
- Field (display_name) — VARCHAR(50) — NOT NULL
- Field2 (start_of_week) — VARCHAR(3) — NOT NULL — mon/sun
- Field3 (show_weekends) — TINYINT(1) — NOT NULL
- Field4 (grid_start) — INT — NOT NULL
- Field5 (grid_end) — INT — NOT NULL
- Field6 (theme) — VARCHAR(10) — NOT NULL — light/dark/system
- Field7 (language) — VARCHAR(5) — NOT NULL — ko/en
스케쥴 (CalendarEvent)
- Key (id) — VARCHAR(36) — 기본 키 — NOT NULL
- Field (owner_id) — VARCHAR(36) — NOT NULL — FK->RoomMember.id or Friend.id
- Field2 (owner_type) — VARCHAR(10) — NOT NULL — member/friend/user
- Field3 (title) — VARCHAR(100) — NOT NULL
- Field4 (description) — TEXT
- Field5 (day_of_week) — INT — NOT NULL — 0=월, 6=일
- Field6 (start_time) — VARCHAR(5) — NOT NULL — HH:MM
- Field7 (end_time) — VARCHAR(5) — NOT NULL — HH:MM
- Field8 (category) — VARCHAR(20) — NOT NULL — class/meeting/deepwork/personal/break
- Field9 (location) — VARCHAR(100)
알림 (Notification)
- Key (id) — VARCHAR(36) — 기본 키 — NOT NULL
- Field2 (type) — VARCHAR(30) — NOT NULL
- Field3 (title) — VARCHAR(100) — NOT NULL
- Field4 (body) — TEXT
- Field5 (time) — DATETME — NOT NULL
- Field6 (read) — TINYINT(1) — NOT NULL
- Field7 (actionable) — TINYINT(1)
- Field8 (roomID) — VARCHAR(36) — fk->Room.id
- Field9 (fromName) — VARCHAR(50)
친구 (Friend)
- Key (id) — VARCHAR(36) — 기본 키 — NOT NULL
- Field (name) — VARCHAR(50) — NOT NULL
- Field2 (initials) — VARCHAR(5)
- Field3 (color_id) — VARCHAR(20)
- Field4 (added_at) — DATETIME — NOT NULL
친구요청 (FriendRequest)
- Key (id) — VARCHAR(36) — 기본 키 — NOT NULL
- Field (from_id) — VARCHAR(36) — NOT NULL — FK->Friend.id
- Field2 (from_name) — VARCHAR(50)
- Field3 (from_initials) — VARCHAR(5)
- Field4 (sent_at) — DATETIME — NOT NULL