bookMarket

Tables (13)

bookmarks

  • bookmark_id — INT — Primary key — NOT NULL
  • user_id — INT
  • item_id — INT
  • notification_enabled — BOOLEAN

categories

  • category_id — INT — Primary key — NOT NULL
  • category_name — VARCHAR(255)

chats

  • chat_id — INT — Primary key — NOT NULL
  • sender_id — INT
  • receiver_id — INT
  • message — TEXT
  • sent_time — DATETIME

evaluations

  • evaluation_id — INT — Primary key — NOT NULL
  • review — TEXT
  • rating — INT
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • item_id — INT — Foreign key → items.item_id — NOT NULL

follows

  • follow_id — INT — Primary key — NOT NULL
  • follower_id — INT
  • following_id — INT

items

  • item_id — INT — Primary key — NOT NULL
  • title — VARCHAR(255)
  • description — TEXT
  • price — INT
  • createdAt — DATE
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • location_id — INT — Foreign key → locations.location_id — NOT NULL
  • updatedAt — DATE

locations

  • location_id — INT — Primary key — NOT NULL
  • location_name — VARCHAR(255)

offers

  • offer_id — INT — Primary key — NOT NULL
  • sender_id — INT
  • receiver_id — INT
  • proposal — TEXT
  • negotiation_status — VARCHAR(50)
  • item_id — INT — Foreign key → items.item_id — NOT NULL

photos

  • photo_id — INT — Primary key — NOT NULL
  • image_url — VARCHAR(255)
  • item_id — INT — Foreign key → items.item_id — NOT NULL

profiles

  • profile_id — INT — Primary key — NOT NULL
  • profile_picture — VARCHAR(255)
  • personal_info — TEXT
  • exchange_history — TEXT
  • user_id — INT — Foreign key → users.user_id — NOT NULL

reports

  • report_id — INT — Primary key — NOT NULL
  • reporter_id — INT
  • reported_user_id — INT
  • description — TEXT
  • resolution_status — VARCHAR(50)

tags

  • tag_id — INT — Primary key — NOT NULL
  • tag_name — VARCHAR(255)

users

  • user_id — INT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • createdAt — DATE
  • location_id — INT — Foreign key → locations.location_id — NOT NULL
  • updatedAt — DATE