Auction_ShoppingMall

Tables (9)

advertisements

  • advertisement_id — INT
  • image_url — VARCHAR(255) — NOT NULL
  • redirect_url — VARCHAR(255) — NOT NULL
  • active — BOOLEAN — NOT NULL

carts

  • cart_id — INT
  • user_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • quantity — INT
  • added_date — TIMESTAMP

categories

  • category_id — INT
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • parent_id — INT

events

  • event_id — INT
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • start_date — DATE
  • end_date — DATE
  • active — BOOLEAN — NOT NULL

orders

  • order_id — INT
  • user_id — INT — NOT NULL
  • total_price — DECIMAL(10, 2) — NOT NULL
  • order_date — TIMESTAMP
  • status — ENUM('pending', 'completed', 'cancelled')

payments

  • payment_id — INT
  • order_id — INT — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • payment_date — TIMESTAMP
  • payment_method — ENUM('credit card', 'paypal', 'bank transfer') — NOT NULL

products

  • product_id — INT
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10, 2) — NOT NULL
  • stock — INT — NOT NULL
  • category_id — INT
  • created_at — TIMESTAMP

shipments

  • shipment_id — INT
  • order_id — INT — NOT NULL
  • shipment_status — ENUM('preparing', 'shipped', 'delivered', 'returned')
  • tracking_number — VARCHAR(255)
  • estimated_delivery_date — DATE
  • actual_delivery_date — DATE

users

  • Key — Primary key — NOT NULL
  • user_id — INT
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • address — TEXT — NOT NULL
  • created_at — TIMESTAMP