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