08B DB - 2.17 update
Tables (4)
ChatMember (Untitled2)
- id — long — Primary key — NOT NULL
- user_id — long — Foreign key → User.id — NOT NULL
- chatroom_id — long — Foreign key → ChatRoom.id — NOT NULL
- enter_time — timestamp
ChatRoom (Untitled3)
- id — long — Primary key — NOT NULL
- last_message_id — string
Message (Untitled4)
- id — long — Primary key — NOT NULL
- chatroom_id — long — Foreign key → ChatRoom.id — NOT NULL
- sender_id — long — Foreign key → User.id — NOT NULL
- content — string
- send_time — timestamp
- is_deleted — tinyint
User (Untitled)
- id — long — Primary key — NOT NULL
- provider= naver (provider) — string
- provider_user_id — long
- username — string
- profile_image — string
- email — string
- create_time — timestamp