bookchat

Tables (13)

Agony (Untitled7)

  • agony_id (Key) — auto_increment — Primary key — NOT NULL
  • book_shelf_id (Key2) — auto_increment — Foreign key → BookShelf.book_shelf_id — NOT NULL
  • title (Field) — varchar
  • hexColorCode (Field2) — varchar

AgonyRecord (Untitled8)

  • agony_record_id (Key) — auto_increment — Primary key — NOT NULL
  • agony_id (Key2) — auto_increment — Foreign key → Agony.agony_id — NOT NULL
  • chat_room_id (Key22) — auto_increment — Foreign key — NOT NULL
  • title (Field) — varchar
  • content (Field2) — varchar
  • hexColorCode (Field3) — varchar

BlockedUser (Untitled4)

  • blocked_user_id (Key) — auto_increment — Primary key — NOT NULL
  • chat_room_id (Key2) — auto_increment — Foreign key → ChatRoom.chat_room_id — NOT NULL
  • user_id (Key3) — auto_increment — Foreign key → User.user_id — NOT NULL

Book (Untitled3)

  • book_id (Key) — varchar(60) — Primary key — NOT NULL
  • isbn (Field6)
  • title (Field) — varchar(200)
  • author (Field2) — varchar(200)
  • book_cover_image_url (Field3)
  • publisher (Field4)
  • publish_at (Field5) — timestamp

BookReport (Untitled5)

  • book_report_id (Key2) — auto_increment — Primary key — NOT NULL
  • book_shelf_id (Key) — auto_increment — Foreign key → BookShelf.book_shelf_id — NOT NULL
  • title (Field) — varchar
  • content (Field2) — varchar

BookShelf (Untitled6)

  • book_shelf_id (Key) — auto_increment — Primary key — NOT NULL
  • user_id (Key2) — auto_increment — Foreign key → User.user_id — NOT NULL
  • book_id (Key3) — varchar(60) — Foreign key → Book.book_id — NOT NULL
  • complete_reading (Field) — varchar(20)
  • page (Field2) — number
  • star (Field3) — number

Chat (Untitled2)

  • chat_id (Key) — auto_increment — Primary key — NOT NULL
  • user_id (Key2) — auto_increment — Foreign key → User.user_id — NOT NULL
  • chat_room_id (Key3) — auto_increment — Foreign key → ChatRoom.chat_room_id — NOT NULL
  • user_id (Key32) — auto_increment — Foreign key → ChatRoom.host_id — NOT NULL
  • message (Field) — varchar(500)
  • writeAt (Field2) — timestamp
  • readAt (Field3) — timestamp

ChatRoom (Untitled)

  • chat_room_id (Key) — auto_increment — Primary key — NOT NULL
  • host_id (Key3) — auto_increment — Foreign key → User.user_id — NOT NULL
  • book_id (Key2) — varchar(60) — Foreign key → Book.book_id — NOT NULL
  • roomName (Field) — varchar(200)
  • roomSize (Field3) — int
  • roomSID (Field2)

ChatRoom_HashTag (Untitled10)

  • id (Key) — auto_increment — Primary key — NOT NULL
  • chat_room_id (Key2) — auto_increment — Foreign key → ChatRoom.chat_room_id — NOT NULL
  • hashtag_id (Key3) — auto_increment — Foreign key → HashTag.hashtag_id — NOT NULL
  • user_id (Key32) — auto_increment — Foreign key → ChatRoom.host_id — NOT NULL

Device (Untitled12)

  • device_id (Key) — auto_increment — Primary key — NOT NULL
  • user_id (Key2) — auto_increment — Foreign key → User.user_id — NOT NULL
  • fcm_token (Field)

HashTag (Untitled11)

  • hashtag_id (Key) — auto_increment — Primary key — NOT NULL
  • tag (Field) — varchar

Participant (Untitled9)

  • participant_id (Key2) — auto_increment — Primary key — NOT NULL
  • chat_room_id (Key) — auto_increment — Foreign key → ChatRoom.chat_room_id — NOT NULL
  • user_id (Key3) — auto_increment — Foreign key → User.user_id — NOT NULL
  • participant_status (Field2) — varchat(20)
  • isConnected (Field) — boolean

User

  • user_id (Key) — auto_increment — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • email (Field2) — varchar(40)
  • profile_image (Field3) — varchar(45)