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