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