fleamarket

Tables (5)

chat_room

  • Key (post_id) — INT UNSIGNED AUTO_INCREMENT — Foreign key → post.Key — NOT NULL
  • Key (buyer_id) — INT UNSIGNED AUTO_INCREMENT — Foreign key → user.Key — NOT NULL

item_image

  • Key (image_id) — INT UNSIGNED AUTO_INCREMENT — Primary key — NOT NULL
  • Field (image_data) — BLOB — NOT NULL
  • Key (post_id) — INT UNSIGNED AUTO_INCREMENT — Foreign key → post.Key — NOT NULL

post

  • Key (post_id) — INT UNSIGNED AUTO_INCREMENT — Primary key — NOT NULL
  • Field (post_title) — VARCHAR(255) — NOT NULL
  • Field (post_description) — VARCHAR(255) — NOT NULL
  • Field (item_category) — VARCHAR(255) — NOT NULL
  • Field (item_price) — INT UNSIGNED
  • Key (seller_id) — INT UNSIGNED AUTO_INCREMENT — Foreign key → user.Key — NOT NULL
  • Field (createdAt) — DATETIME — NOT NULL
  • Field (updatedAt) — DATETIME — NOT NULL

user

  • Key (user_id) — INT UNSIGNED AUTO_INCREMENT — Primary key — NOT NULL
  • Field (login_id) — VARCHAR(20) — NOT NULL
  • Field (login_pw) — VARCHAR(20) — NOT NULL
  • Field (user_town) — VARCHAR(255) — NOT NULL

wish

  • Key (post_id) — INT UNSIGNED AUTO_INCREMENT — Foreign key → post.Key — NOT NULL
  • Key (buyer_id) — INT UNSIGNED AUTO_INCREMENT — Foreign key → user.Key — NOT NULL