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