roomies

Tables (8)

category (카테고리)

  • id (Key) — Primary key — NOT NULL
  • room_id (Key2) — Primary key — NOT NULL
  • name (Field)

role (역할)

  • id (Key) — Primary key — NOT NULL
  • room_id (Key2) — Primary key — NOT NULL
  • name (Field)
  • create_at (Field2)

room (방)

  • id (Key) — Primary key — NOT NULL
  • invite_code (Field)
  • create_user (Field2)
  • create_at (Field3)
  • name (Field4)

room_member (방 멤버)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Primary key — NOT NULL
  • room_id (Key3) — Primary key — NOT NULL
  • join_at (Field)

task (집안일)

  • id (Key) — Primary key — NOT NULL
  • category_id (Key2) — Primary key — NOT NULL
  • name (Field)
  • created_at (Field3)

task_assignment (집안일 할당 결과)

  • id (Key) — Primary key — NOT NULL
  • task_schedule_id (Key2) — Primary key — NOT NULL
  • assigned_member_id (Key3) — Primary key — NOT NULL
  • date (Field)
  • status (Field2)

task_schedule (집안일 스케줄)

  • id (Key) — Primary key — NOT NULL
  • task_id (Key2) — Primary key — NOT NULL
  • frequency (Field)
  • days_of_week (Field2)
  • assigned_order (Field3)

user (유저)

  • Key — Primary key — NOT NULL
  • provider (Field)
  • provider_id (Field2)
  • create_at (Field4)