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