프로젝트
테이블 (7)
card
- cardNum — varchar(300) — 기본 키 — NOT NULL
- userid — varchar(300) — 외래 키 → user.Key — NOT NULL
- Field (cardNick) — varchar(300)
- Field (cardCom) — varchar(300)
- Field (cardpw) — varchar(300)
- Field (cardValid) — varchar(300)
- Field (cardCVC) — int
cart (Untitled)
- Key (resNum) — int — 외래 키 → restaurant.Key — NOT NULL
- Key (foodNum) — int — 외래 키 → food.Key — NOT NULL
- Key (userid) — varchar(300) — 외래 키 → user.Key — NOT NULL
- Field (foodAmount) — int
food
- Key (foodNum) — int — 기본 키 — NOT NULL
- Key (resNum) — int — 외래 키 → restaurant.Key — NOT NULL
- Field (foodName) — varchar(300)
- Field (foodPrice) — int
heartlist
- userid — varchar(300) — 외래 키 → user.Key — NOT NULL
- Key (resNum) — int — 외래 키 → restaurant.Key — NOT NULL
orderlist
- userid — varchar(300) — 외래 키 → user.Key — NOT NULL
- Key (foodNum) — int — 외래 키 → food.Key — NOT NULL
- Key (resNum) — int — 외래 키 → restaurant.Key — NOT NULL
- Field (foodAmount) — int
- Field (orderTime) — varchar(300)
restaurant
- Key (resNum) — int — 기본 키 — NOT NULL
- Field (resName) — varchar(300)
- Field (resType) — varchar(300)
user
- Key (userid) — varchar(300) — 기본 키 — NOT NULL
- Field (userpw) — varchar(300)
- Field (userName) — varchar(300)
- Field (userAge) — int
- Field (userGender) — char(1)
- Field (userPhone) — varchar(300)
- Field (userAddr) — varchar(2000)
- Field (userNick) — varchar(300)