auction

Tables (5)

Bid (입찰)

  • bidID (Key) — Primary key — NOT NULL
  • itemID (Key3) — Foreign key → Item.itemID — NOT NULL
  • price (Field2)
  • bidder (Field3)
  • date_posted (Field4)
  • closing_date (Field5)
  • Field6

Billing (청구서)

  • billingID (Key) — Primary key — NOT NULL
  • solditemID (Key2) — Foreign key → Item.itemID — NOT NULL
  • purchase_date (Field2)
  • seller_payamount (Field5)
  • buyer_payamount (Field6)
  • sellerID (2) — verchar — Foreign key → User.userID — NOT NULL
  • buyerID (3) — verchar — Foreign key → User.userID — NOT NULL

Item (Untitled2)

  • itemID (Key) — Primary key — NOT NULL
  • category (Field)
  • discription (Field2)
  • condition (Field3)
  • buy-it-now_price (Field5)
  • date_posted (Field6)
  • status (Field7)
  • sellerID (2) — verchar — Foreign key → User.userID — NOT NULL

User (Untitled)

  • userID — verchar — Primary key — NOT NULL
  • password (Field)
  • Field2
  • Field3

admin (Untitled3)

  • adminID (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4