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)