db erd

Tables (27)

blocks

  • block_id — int — Primary key — NOT NULL
  • blocker_id — varchar(50)
  • blocked_id — varchar(50)
  • created_at — timestamp

bookmarks

  • bookmark_id — int — Primary key — NOT NULL
  • board_id — int
  • user_id — varchar(50)
  • created_at — timestamp

books

  • book_id — int — Primary key — NOT NULL
  • seller_id — varchar(50) — Foreign key → users.user_id — NOT NULL
  • category — varchar(20) — NOT NULL
  • major_name — varchar(50)
  • subject_name — varchar(50)
  • title — varchar(100) — NOT NULL
  • price — int — NOT NULL
  • description — text — NOT NULL
  • status — varchar(20)
  • is_deleted — int
  • created_at — datetime

chat

  • message_id — int — Primary key — NOT NULL
  • book_id — int — NOT NULL
  • sender_id — varchar(50) — Foreign key → users.user_id — NOT NULL
  • receiver_id — varchar(50) — Foreign key → users.user_id — NOT NULL
  • content — text — NOT NULL
  • is_read — int
  • send_time — datetime
  • sender_visible — int
  • receiver_visible — int
  • chat_type — varchar(10)

chat_reports

  • reportID — int — Primary key — NOT NULL
  • bookID — int
  • reporterID — varchar(20)
  • reportedID — varchar(20)
  • reason — varchar(255)
  • reportDate — datetime

comment_likes

  • like_id — int — Primary key — NOT NULL
  • comment_id — int
  • user_id — varchar(50)
  • created_at — timestamp

comments

  • commentID — int — Primary key — NOT NULL
  • boardID — int — Foreign key → community.boardID
  • userID — varchar(20)
  • commentContent — text
  • commentDate — datetime
  • is_anonymous — int
  • parent_comment_id — int

community

  • boardID — int — Primary key — NOT NULL
  • userID — varchar(20)
  • title — varchar(100)
  • content — text
  • postDate — datetime
  • hit — int
  • likeCount — int
  • category — varchar(30)
  • is_anonymous — int
  • fileName — varchar(300)
  • isSecret — int

favoriteboards

  • favoriteID — int — Primary key — NOT NULL
  • userID — varchar(50) — Foreign key → users.user_id — NOT NULL
  • category — varchar(50) — NOT NULL

follows

  • follower_id — varchar(50) — Primary key — NOT NULL
  • following_id — varchar(50) — Primary key — NOT NULL
  • created_at — timestamp

likes

  • likeID — int — Primary key — NOT NULL
  • userID — varchar(50) — Foreign key → users.user_id
  • marketID — int — Foreign key → market.marketID

market

  • marketID — int — Primary key — NOT NULL
  • userID — varchar(50)
  • title — varchar(100)
  • content — text
  • price — int
  • department — varchar(50)
  • course — varchar(50)
  • tradeType — varchar(20)
  • location — varchar(100)
  • fileName — varchar(200)
  • status — int
  • postDate — datetime
  • hit — int
  • deliveryFee — int
  • buyerID — varchar(50)
  • latitude — varchar(50)
  • longitude — varchar(50)

market_reports

  • reportID — int — Primary key — NOT NULL
  • marketID — int — Foreign key → market.marketID
  • reporterID — varchar(50)
  • reason — text
  • reportDate — datetime

marketreview

  • reviewID — int — Primary key — NOT NULL
  • marketID — int
  • targetID — varchar(50)
  • writerID — varchar(50)
  • reviewType — varchar(20)
  • rating — int
  • content — text
  • regDate — datetime

note_room_titles

  • room_hash — varchar(100) — Primary key — NOT NULL
  • user_id — varchar(20) — Primary key — NOT NULL
  • custom_title — varchar(100)

notes

  • note_id — int — Primary key — NOT NULL
  • room_hash — varchar(100)
  • board_id — int
  • sender_id — varchar(20)
  • receiver_id — varchar(20)
  • content — text
  • is_anonymous — int
  • is_read — int
  • send_time — datetime
  • sender_visible — int
  • receiver_visible — int
  • chat_type — varchar(10)

notifications

  • notif_id — int — Primary key — NOT NULL
  • user_id — varchar(20)
  • type — varchar(20)
  • message — varchar(255)
  • target_url — varchar(255)
  • is_read — int
  • created_at — datetime

openchatmember

  • user_id — varchar(50) — Primary key — NOT NULL
  • room_id — int — Foreign key → openchatroom.room_id — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • joined_at — datetime
  • last_read_msg_id — int
  • is_muted — tinyint
  • profile_image — varchar(255)

openchatmessage

  • message_id — int — Primary key — NOT NULL
  • room_id — int — Foreign key → openchatroom.room_id
  • sender_id — varchar(50)
  • content — text
  • message_type — varchar(20)
  • created_at — datetime

openchatroom

  • room_id — int — Primary key — NOT NULL
  • title — varchar(100) — NOT NULL
  • created_at — datetime
  • room_image — varchar(255)

orders

  • order_id — int — Primary key — NOT NULL
  • buyer_id — varchar(50) — Foreign key → users.user_id — NOT NULL
  • book_id — int — NOT NULL
  • trade_type — varchar(20) — NOT NULL
  • address — varchar(255)
  • fee_type — varchar(20)
  • status — varchar(20)
  • created_at — datetime

polloptions

  • optionID — int — Primary key — NOT NULL
  • boardID — int
  • optionText — varchar(200)
  • voteCount — int

pollvotes

  • voteID — int — Primary key — NOT NULL
  • boardID — int
  • userID — varchar(50)
  • optionID — int

postlikes

  • likeID — int — Primary key — NOT NULL
  • boardID — int — Foreign key → community.boardID
  • userID — varchar(20)

reports

  • report_id — int — Primary key — NOT NULL
  • reporter_id — varchar(50)
  • target_type — varchar(10)
  • target_id — int
  • reason — varchar(255)
  • status — varchar(20)
  • created_at — timestamp

userroommute

  • user_id — varchar(50) — Primary key — NOT NULL
  • room_key — varchar(100) — Primary key — NOT NULL

users

  • user_id — varchar(50) — Primary key — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(50) — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • birth_date — date
  • phone — varchar(20) — NOT NULL
  • email — varchar(100) — NOT NULL
  • address — varchar(255)
  • profile_image — varchar(255)
  • role — varchar(20)
  • status — varchar(20)
  • ban_timer — datetime
  • created_at — datetime
  • balance — int