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