team3

Tables (5)

Auction (auction)

  • Id (id) — Int — Primary key — NOT NULL
  • Id (id3) — Int — Foreign key → User.Id — NOT NULL
  • create_date (created date) — Datetime
  • start_date — Datetime
  • end_date — Datetime
  • final_contract_price — Int
  • successful_bidder_id — Int
  • product_name (product id) — Product
  • user_name (seller id) — User
  • current_price — Int
  • Field

Category (category)

  • Id (id) — Int — Primary key — NOT NULL
  • Name (Field) — String

Product (product)

  • Id (id) — Int — Primary key — NOT NULL
  • Userid (userid) — Int — Foreign key → User.Id — NOT NULL
  • Categoryid (categoryid) — Int — Foreign key → Category.Id — NOT NULL
  • Name (name) — String
  • description — String
  • lower_limit_price — Int
  • img_path — String
  • user_id — Int
  • auction_id — Int
  • category_id — Int
  • start_date (start date) — Datetime
  • end_date — Datetime

Profile (profile)

  • id — Int — Primary key — NOT NULL
  • Userid (userid) — Int — Foreign key → User.Id — NOT NULL
  • img_path (profile image) — String
  • description — String

User (users)

  • Id (id) — Int — Primary key — NOT NULL
  • email — String
  • name — String
  • password (passoword) — String
  • phone_num (phone number) — String
  • battery_rating (user score) — Int
  • admin — Boolean
  • cash — Int
  • create_date (created date) — Datetime
  • update_date (updated date) — Datetime
  • products (product list) — Product