SSAUC 2
Tables (14)
Admin
- admin_id — INT
- user_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
Bid
- bid_id — INT
- product_id — INT — NOT NULL
- user_id — INT — NOT NULL
- bid_amount — DECIMAL(10,2) — NOT NULL
- bid_time — DATETIME
- auto_bid_max — DECIMAL(10,2)
Category
- category_id — INT
- name — VARCHAR(100) — NOT NULL
- parent_category_id — INT
ChatMessage
- message_id — INT
- chat_room_id — INT — NOT NULL
- sender_id — INT — NOT NULL
- message_text — TEXT — NOT NULL
- sent_at — DATETIME
ChatParticipant
- chat_room_id — INT — Primary key — NOT NULL
- user_id — INT — Primary key — NOT NULL
- joined_at — DATETIME
ChatRoom
- chat_room_id — INT
- created_at — DATETIME
MoneyTransaction
- transaction_id — INT
- user_id — INT — NOT NULL
- transaction_type — VARCHAR(50) — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
- transaction_date — DATETIME
- details — TEXT
Orders
- order_id — INT
- buyer_id — INT — NOT NULL
- seller_id — INT — NOT NULL
- order_date — DATETIME
- total_amount — DECIMAL(10,2) — NOT NULL
- recipient_name — VARCHAR(100) — NOT NULL
- recipient_phone — VARCHAR(20)
- shipping_address — VARCHAR(255) — NOT NULL
- postal_code — VARCHAR(20)
- shipping_status — VARCHAR(50)
- order_status — VARCHAR(50)
Payment
- payment_id — INT
- order_id — INT — NOT NULL
- payer_id — INT — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
- payment_method — VARCHAR(50)
- payment_status — VARCHAR(50)
- payment_date — DATETIME
Product
- product_id — INT
- seller_id — INT — NOT NULL
- category_id — INT — NOT NULL
- name — VARCHAR(200) — NOT NULL
- description — TEXT
- price — DECIMAL(10,2) — NOT NULL
- image_url — VARCHAR(255)
- status — VARCHAR(50) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
ProductLike
- user_id — INT — Primary key — NOT NULL
- product_id — INT — Primary key — NOT NULL
- liked_at — DATETIME
Review
- review_id — INT
- reviewer_id — INT — NOT NULL
- reviewee_id — INT — NOT NULL
- order_id — INT
- rating — INT — NOT NULL
- comment — TEXT — EX
- created_at — DATETIME
SearchDictionary
- entry_id — INT
- term — VARCHAR(100) — NOT NULL
- type — VARCHAR(50) — NOT NULL
- related_terms — TEXT
User
- user_id — INT
- user_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20)
- rating — DECIMAL(3,2)
- created_at — DATETIME
- updated_at — DATETIME