project-dgdg

Tables (4)

chat_messages

  • id — num — Primary key — NOT NULL
  • room_id — num — Foreign key → chat_rooms.id — NOT NULL — 체팅방 아이디 (pk) (auto)
  • user_id — num — Foreign key → users.id — 유저 시퀀스 (auto) pk
  • content — text
  • created_at — timestamp
  • updated_at — timestamp
  • is_deleted — boolean

chat_participants

  • id — num — Primary key — NOT NULL
  • user_id — num — Foreign key → users.id — 유저 시퀀스 (auto) pk
  • room_id — num — Foreign key → chat_rooms.id — NOT NULL — 체팅방 아이디 (pk) (auto)
  • created_at — timestamp
  • updated_at — timestamp
  • is_deleted — boolean

chat_rooms

  • id — num — Primary key — NOT NULL — 체팅방 아이디 (pk) (auto)
  • name — varchar(30)
  • is_private — boolean
  • created_at — timestamp
  • updated_at — timestamp
  • is_deleted — boolean

users

  • id — num — Primary key — 유저 시퀀스 (auto) pk
  • login_id — varchar(15) — 유저 아이디
  • passward — text
  • nick_name — varchar(15)
  • created_at — timestamp
  • updated_at — timestamp
  • is_deleted — boolean