e-commerce
Tables (8)
Categories (Untitled2)
- category_id (Key) — String — Primary key — NOT NULL
- name (Field) — NOT NULL
- image (Field6)
Order (Untitled3)
- order_id (session_id) — String — Primary key — NOT NULL
- user_id — String — Foreign key → User.user_id — NOT NULL
- ammount (Field) — String — NOT NULL
- shipping_address (Field2) — NOT NULL
- shipping_postal_code (Field5) — NOT NULL
- order_status (Field4) — NOT NULL
- order_address (Field3)
- order_date (Field6) — NOT NULL
Orderdetails (Untitled6)
- detail_id (Key) — String — Primary key — NOT NULL
- order_id (session_id) — String — Foreign key → Order.order_id — NOT NULL
- product_id (Field3) — String — Foreign key → product.product_id — NOT NULL
- price (Field) — String — NOT NULL
- quantity (Field2) — String — NOT NULL
User (Untitled)
- user_id — String — Primary key — NOT NULL
- username — NOT NULL
- password (id) — NOT NULL
- first_name — NOT NULL
- last_name — NOT NULL
- phone — NOT NULL
- createdat — NOT NULL
- modifiedat
- auth (Field) — NOT NULL
options (Untitled1)
- option_id (method_id) — String — Primary key — NOT NULL
- option_name (expiration) — NOT NULL
product (Untitled5)
- product_id (Field) — String — Primary key — NOT NULL
- name (Field2) — NOT NULL
- desc (Field3) — NOT NULL
- price (Field4) — NOT NULL
- created_at (Field5) — NOT NULL
- modified_at (Field6) — NOT NULL
- deleted_at (Field7) — NOT NULL
- stock (Field8) — String — NOT NULL
product_category (Untitled7)
- pc_id (Key) — String — Primary key — NOT NULL
- product_id (Key2) — String — Foreign key → Categories.category_id — NOT NULL
product_options (Untitled4)
- po_id (cart_id) — String — Primary key — NOT NULL
- product_id (Field) — String — Foreign key → product.product_id — NOT NULL
- option_id (method_id) — String — Foreign key → options.option_id — NOT NULL