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 (전화번호)