sss

Tables (6)

deliver

  • number — INT — Primary key — NOT NULL
  • code — INT — Foreign key → seller.code — NOT NULL

delivery_destination

  • code — INT — Primary key — NOT NULL
  • memberid — INT — Foreign key → member.memberid — NOT NULL
  • number — VARCHAR(255)
  • address — VARCHAR(255)

member

  • memberid — INT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • number — VARCHAR(255)

orders

  • orderid — INT — Primary key — NOT NULL
  • memberid — INT — Foreign key → member.memberid — NOT NULL
  • productid — INT — Foreign key → product.productid — NOT NULL
  • name — VARCHAR(255)
  • number — VARCHAR(255)

product

  • productid — INT — Primary key — NOT NULL
  • productname — VARCHAR(255)
  • price — DECIMAL(10, 2)

seller

  • code — INT — Primary key — NOT NULL