DBexam
Tables (7)
inventory
- product_id — BIGINT
- quantity — INT — NOT NULL
order_items
- order_id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Primary key — NOT NULL
- quantity — INT — NOT NULL
- unit_price — DECIMAL(10,2) — NOT NULL
orders
- order_id — BIGINT
- user_id — BIGINT — NOT NULL
- order_date — DATETIME
- status — ENUM('ORDER_PLACED','PAID','SHIPPED','CANCELLED')
payments
- payment_id — BIGINT
- order_id — BIGINT — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
- method — ENUM('CARD','BANK_TRANSFER') — NOT NULL
- status — ENUM('SUCCESS','FAIL','REFUND') — NOT NULL
- paid_at — DATETIME
products
- product_id — BIGINT
- name — VARCHAR(200) — NOT NULL
- description — TEXT
- price — DECIMAL(10,2) — NOT NULL
- status — ENUM('for_sale','out_of_stock','hidden')
- created_at — DATETIME
- created_by — BIGINT
shipments
- shipment_id — BIGINT
- order_id — BIGINT — NOT NULL
- carrier_name — VARCHAR(100)
- tracking_number — VARCHAR(100)
- status — ENUM('PREPARING','IN_TRANSIT','DELIVERED')
users
- user_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- status — ENUM('active','suspended','withdrawn')
- created_at — DATETIME