PixeylPlay
Tables (4)
chat_room
- id (Key) — uuid — Primary key — NOT NULL
- owner_id (Field6) — uuid — NOT NULL
- title (Field) — string — NOT NULL
- descrption (Field2) — string
- max_capacity (Field3) — short — NOT NULL
- created_at (Field4) — date — NOT NULL
- modified_at (Field5) — date — NOT NULL
- current_member (Field7) — int — NOT NULL
chat_room_member
- id (Key) — uuid — Primary key — NOT NULL
- user_id (Key2) — uuid — Foreign key → user.id — NOT NULL
- chat_room_id (Key3) — uuid — Foreign key → chat_room.id — NOT NULL
- last_joined_at (Field2) — date
- last_read_at (Field3) — date
- created_at (Field) — date — NOT NULL
- is_banned (Field4) — boolean — NOT NULL
message
- id (Key) — uuid — Primary key — NOT NULL
- user_id (Key2) — uuid — Foreign key → user.id — NOT NULL
- chat_room_id (Key3) — uuid — Foreign key → chat_room.id — NOT NULL
- content (Field) — string — NOT NULL
- created_at (Field2) — date — NOT NULL
- modified_at (Field3) — date — NOT NULL
user
- id (Key) — uuid — Primary key — NOT NULL
- email (Field3) — string — NOT NULL
- name (Field2) — string — NOT NULL
- birth (Field6) — string — NOT NULL
- phone (Field4) — string — NOT NULL
- gender (Field5) — enum — NOT NULL
- nickname (Field) — string — NOT NULL
- created_at (Field8) — date — NOT NULL
- modified_at (Field9) — date — NOT NULL
- linked_providers (Field10) — enum[] — NOT NULL
- photo_url (Field11) — string