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)