back erd

Tables (4)

consumer (Consumer)

  • consumer_id (Long) — Long — Primary key — NOT NULL
  • username (Field2) — String

product (Product)

  • product_id (Key) — Long — Primary key — NOT NULL
  • image_url (Field) — String
  • title (Field2) — String
  • content (Field3) — String
  • seller_id (Long) — Long — Foreign key → seller.seller_id — NOT NULL
  • price (Field4) — Long
  • salePrice (Field5) — Long

purchase (Untitled)

  • Key — Primary key — NOT NULL
  • consumer_id (Long) — Long — Foreign key → consumer.consumer_id — NOT NULL
  • product_id (Key2) — Long — Foreign key → product.product_id — NOT NULL

seller (Seller)

  • seller_id (Long) — Long — Primary key — NOT NULL
  • username (Field2) — String