PanpalApp

Tables (5)

allowed_country

  • allowed_country_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • country_code — VARCHAR(10) — NOT NULL

chat_message

  • chat_message_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_room.chat_room_id — NOT NULL
  • message — TEXT — NOT NULL
  • sent_at — TIMESTAMP

chat_room

  • chat_room_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100)
  • is_group — BOOLEAN
  • created_at — TIMESTAMP

chat_room_member

  • chat_room_member_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_room.chat_room_id — NOT NULL
  • joined_at — TIMESTAMP

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(10)
  • role — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • country_code — VARCHAR(10) — NOT NULL
  • bio — TEXT
  • created_at — TIMESTAMP