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)