biddy

Tables (5)

Bid (Untitled4)

  • id (경매일련번호) — Primary key — NOT NULL
  • store_id (스토어일련번호) — Foreign key → Store.id — NOT NULL
  • item_id (제품일련번호) — Foreign key → Item.id — NOT NULL
  • isSet (낙찰여부)
  • maxPrice (현재 최고가격)

Deal (Untitled5)

  • id (입찰일련번호) — Primary key — NOT NULL
  • user_id (유저일련번호) — Foreign key → User.id — NOT NULL
  • bid_id (경매일련번호) — Foreign key → Bid.id — NOT NULL
  • store_id (스토어일련번호) — Foreign key → Bid.store_id — NOT NULL
  • item_id (제품일련번호) — Foreign key → Bid.item_id — NOT NULL
  • price (가격)

Item (Untitled2)

  • id (제품일련번호) — Primary key — NOT NULL
  • product (제품명)
  • type (제품종류)

Store (Untitled)

  • id (스토어일련번호) — Primary key — NOT NULL
  • username (아이디)
  • password (비밀번호)
  • email (이메일)
  • name (사용자이름)

User (Untitled3)

  • id (유저일련번호) — Primary key — NOT NULL
  • username (아이디)
  • password (비밀번호)
  • email (이메일)
  • name (이름)
  • phoneNum (전화번호)