product
Tables (8)
cart (Untitled6)
- pno (Key) — Primary key — NOT NULL
- pno (Key2) — Foreign key → my_wish.pno — NOT NULL
- product_name (Field)
- product_picture (Field2)
- price (Field3)
- quantity (Field4)
- order_at (Field5)
comment_picture (Untitled8)
member (Untitled7)
- id (Key) — Primary key — NOT NULL
- name (Field)
my_wish (Untitled4)
- pno (Key) — Primary key — NOT NULL
- pno (Key2) — Foreign key → product.pno — NOT NULL
- id (Key3) — Foreign key → member.id — NOT NULL
- product_name (Field)
- product_picture (Field2)
- price (Field3)
- wish_at (Field4)
- id (Field5)
order (Untitled2)
- pno (Key) — Primary key — NOT NULL
- pno (Key2) — Foreign key → cart.pno — NOT NULL
- id (Field)
- price (Field2)
- quantity (Field3)
- order_at (Field4)
product (Untitled)
- pno (Key) — Primary key — NOT NULL
- price (Field)
- product_picture (Field2)
- product_detail (Field3)
- classification (Field5)
- rating (Field7)
- product_name (Field4)
- product_quantity (Field6)
product_comment (Untitled5)
- cno (Key) — Primary key — NOT NULL
- pno (Key2) — Foreign key → product.pno — NOT NULL
- pno (Field)
- id (Field2)
- content (Field3)
- comment_picture (Field4)
- reg_at (Field5)
product_picture (Untitled3)
- uuid (Key) — Primary key — NOT NULL
- pno (Key2) — Foreign key → product.pno — NOT NULL
- pno (Field)
- file_name (Field2)
- save_dir (Field3)
- picture_size (Field4)
- reg_at (Field5)