single

Tables (7)

auction (Untitled4)

  • no (Key) — Primary key — NOT NULL
  • name (Field)
  • limit (Field2)
  • picture (Field3)
  • startprice (Field4)
  • id (Key2) — Foreign key → human.id — NOT NULL

bidding (Untitled5)

  • bid_no (Key2) — Primary key — NOT NULL
  • no (Key) — Foreign key → auction.no — NOT NULL
  • price (Field)
  • id (Key3) — Foreign key → human.id — NOT NULL

goods (Untitled)

  • goods_id (Key) — Primary key — NOT NULL
  • name (Field)
  • unit (Field2)

history (Untitled7)

  • his_no (Key) — Primary key — NOT NULL
  • date (Field)
  • picture (Field2)
  • id (Key2) — Foreign key → human.id — NOT NULL
  • no (Key3) — Foreign key → auction.no — NOT NULL

human (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • pw (Field)
  • name (Field2)

register (Untitled2)

  • register_id (Key) — Primary key — NOT NULL
  • contents (Field)
  • register_name (Field2)

register_detail (Untitled3)

  • goods_id (Key) — Foreign key → goods.goods_id — NOT NULL
  • register_id (Key2) — Foreign key → register.register_id — NOT NULL
  • amount (Field)