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)