Hailey

Tables (8)

Customer (User)

  • CustomerID (user_id) — int — Primary key — NOT NULL
  • Name (user_name) — var(10)
  • Email (user_email) — var
  • Mobile (user_mobile) — int
  • Language (user_language) — var(10)
  • Country (user_country) — var(10)
  • Industry (user_industry) — var

Inquiry

  • Invoice ID (inq_id) — int — Primary key — NOT NULL
  • CustomerID (user_id) — int — Foreign key → Customer.CustomerID — NOT NULL
  • Budget (inq_budget) — int

Job Category (Category)

  • Category ID (cat_id) — int — Primary key — NOT NULL
  • Category Name (cat_name) — var

Order

  • OrderID (order_id) — int — Primary key — NOT NULL
  • CustomerID (user_id) — int — Foreign key → Customer.CustomerID — NOT NULL
  • Transaction Amount (order_amount) — float
  • order date (order_status) — var

Payment

  • Payment ID (pay_Id) — int — Primary key — NOT NULL
  • OrderID (order_id) — int — Foreign key → Order.OrderID — NOT NULL
  • CustomerID (user_id) — int — Foreign key → Customer.CustomerID — NOT NULL
  • Payment Method (pay_method) — var
  • Transaction Amount (order_amount) — float
  • Time (pay_date) — timestamp

Review

  • ReviewID (rev_id) — int — Primary key — NOT NULL
  • SellerID (sell_id) — int — Foreign key → Seller.SellerID — NOT NULL
  • Category ID (cat_id) — int — Foreign key → Seller.Category ID — NOT NULL
  • CustomerID (user_id) — int — Foreign key → Customer.CustomerID — NOT NULL
  • Rate (rev_rate) — int
  • Sell Name (sell_name) — text

Seller

  • SellerID (sell_id) — int — Primary key — NOT NULL
  • Category ID (cat_id) — int — Foreign key → Job Category.Category ID — NOT NULL
  • Name (sell_name) — var(10)
  • Email (sell_email) — var
  • Language (sell_language) — var(10)
  • Country (sell_country) — var
  • Industry (sell_industry) — var

Service

  • ServiceID (ser_id) — int — Primary key — NOT NULL
  • SellerID (sell_id) — int — Foreign key → Seller.SellerID — NOT NULL
  • Category ID (cat_id) — int — Foreign key → Seller.Category ID — NOT NULL
  • Content (content) — text