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