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