EnterProjectBack

Tables (6)

Authentications (Untitled)

  • id (Key) — Primary key — NOT NULL

CahtRooms (채팅방)

  • id (Key) — string — Primary key — NOT NULL
  • first_user_id (Field) — bigint
  • second_user_id (Field2) — bigint
  • identifier (Field3) — string
  • chat_messages (Field4) — array
  • Field5

Messages (메시지)

    Notifications (공지사항)

    • id (key) — bigint — Primary key — NOT NULL
    • user_id (fk) — bigint — Foreign key → Users.id — NOT NULL
    • notification_type (Field) — int
    • identifier (Field2) — varchar(50)
    • is_read (Field3) — boolean
    • is_valid (Field4) — boolean
    • creat_at (Field5) — timestamp

    Participants (참가자)

    • id (Key) — string — Primary key — NOT NULL
    • chat_room_id (key2) — bigint
    • user_id (Field) — bigint
    • out (Field2) — boolean
    • read_message_size (Field3) — bigint
    • create_at (F) — timestamp
    • update_dt (Field4) — timestamp
    • Field5

    Users (사용자)

    • id (Key) — bigint — Primary key — NOT NULL
    • oauth_id (Field) — bigint
    • nickname (Field2) — varchar(20)
    • profile_url (Field3) — varchar(250)
    • password (Field6) — varchar(128)
    • email (Field7) — varchar(128)
    • create_at (Field4) — timestamp
    • update_at (Field5) — timestamp