market

Tables (7)

Account

  • id — BIGINT — Primary key
  • Key — Primary key — NOT NULL
  • user_account (user_id) — BIGINT — Foreign key → User.id
  • balance — DECIMAL(10, 2)

ChatMessage

  • id — INT — Primary key
  • chatroom_product (chatroom_id) — BIGINT — Foreign key → ChatRoom.chatroom_product
  • sender_id — INT
  • message — TEXT
  • created_at — TIMESTAMP
  • Field

ChatRoom

  • id — BIGINT — Primary key
  • user-chat (seller_id, buyer_id) — INT — Foreign key → User.id
  • chatroom_product (product_id) — INT — Foreign key → Product.id
  • seller_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • Key — NOT NULL

Product

  • id — BIGINT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • seller_id — INT

ProductImage

  • id — INT — Primary key
  • product_id — INT
  • image_url — VARCHAR(255) — NOT NULL

Trade (Transaction)

  • id — BIGINT — Primary key
  • product_trade (product_id) — BIGINT — Foreign key → Product.id
  • buyer_id — INT
  • seller_id — INT
  • amount — DECIMAL(10, 2) — NOT NULL
  • status — ENUM('pending', 'completed', 'failed')
  • product_id (product_if) — BIGINT — NOT NULL

User

  • id — BIGINT — Primary key
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • address — VARCHAR(255)
  • role — ENUM('admin', 'user')