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