shopping

Tables (12)

Untitled17

  • order_id — NUMBER(4) — Primary key — NOT NULL
  • order_date — TIMESTAMP
  • order_status — VARCHAR2(20)

cart (Untitled8)

  • cart_id — int — Primary key — NOT NULL
  • product_id — varchar(20) — Foreign key → product.product_id — NOT NULL
  • user_id — varchar(20) — Foreign key → user.user_id — NOT NULL
  • quantity — varchar(20)

cart (Untitled3)

  • shoppingcart_id — varchar2(50) — Primary key — NOT NULL
  • product_id — number — NOT NULL
  • user_id — varchar2(50) — NOT NULL
  • quantity — number
  • Field — VARCHAR(255)

inquiry (Untitled6)

  • user_id — int — Foreign key → user.user_id — NOT NULL
  • content — varchar(200)
  • answer — varchar(500)
  • status — varchar(20)
  • created_at — datetime

orders (CopyOfUntitled3)

  • order_id — varchar2(50) — Primary key — NOT NULL
  • user_id — varchar2(50) — NOT NULL
  • order_price — number
  • order_date — Date
  • order_address — varchar2(50)

orders (Untitled9)

  • order_id — int — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → user.user_id — NOT NULL
  • product_id — int — Foreign key → product.product_id — NOT NULL
  • total_price — int
  • status — varchar(20)
  • order_date — datetime
  • address — varchar(20)

product (untitled)

  • product_id — int — Primary key — NOT NULL
  • name — varchar(100)
  • description — varchar(100)
  • category — varchar(100)
  • img_url — varchar(100)
  • price — int
  • mall_name — varchar(100)

product (Untitled)

  • product_id — varchar2(50) — Primary key — NOT NULL
  • product_name — varchar2(50)
  • product_price — number
  • product_img — varchar2(50)
  • product_desc — varchar2(50)

product_info (CopyOfuntitled2)

  • product_id — int — Foreign key → product.product_id — NOT NULL
  • made_in — varchar(100)
  • color — varchar(100)
  • release_date — date
  • tel — varchar2(100)

productimg (Untitled11)

  • image_id — number(4) — Primary key — NOT NULL
  • image_url — varchar2(250)
  • image_type — varchar(10 char)

review (Untitled5)

  • review_id — int — Primary key — NOT NULL
  • product_id — int — Foreign key → product.product_id — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • rating — int
  • content — varchar(20)
  • created_at — varchar(20)

user (Untitled7)

  • user_id — int — Primary key — NOT NULL
  • Field — VARCHAR(255)