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