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)