08b api

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 — datetime

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
  • send_time — datetime
  • content — string

User (Untitled)

  • id — long — Primary key — NOT NULL
  • provider= naver (provider) — string
  • provider userid — long
  • username — string
  • email — string
  • create_time — datetime
  • role — string