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