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