rocket-market
Tables (8)
cart
- cart_id — INT
- user_id — INT
- created_at — TIMESTAMP
cart_items
- cart_item_id — INT
- cart_id — INT
- product_id — INT
- quantity — INT — NOT NULL
categories
- category_id — INT
- name — VARCHAR(50) — NOT NULL
- description — TEXT
order_items
- order_item_id — INT
- order_id — INT
- product_id — INT
- quantity — INT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
orders
- order_id — INT
- user_id — INT
- total_price — DECIMAL(10, 2) — NOT NULL
- order_date — TIMESTAMP
- status — VARCHAR(50)
products
- product_id — INT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- price — DECIMAL(10, 2) — NOT NULL
- stock — INT — NOT NULL
- category_id — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
shipping
- shipping_id — INT
- order_id — INT
- tracking_number — VARCHAR(100)
- status — VARCHAR(50)
- estimated_delivery_date — DATE
users
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP