BbangBbang
Tables (6)
Bread (BreadUrl)
- Key (breadIdx) — Integer — Primary key — NOT NULL
- Field (breadImgUrl) — Text
BreadUrl (Bread)
- Key (breadIdx) — Primary key — NOT NULL
Shop
- Key (ShopIdx) — Primary key — NOT NULL
- Field
User
- Key (userIdx) — Integer — Primary key — NOT NULL
- Field (userName) — varchar(20)
- Field2 (userPhone) — varchar(15)
- Field (userEmail) — varchar(40)
- Field (isShop) — boolean — shop 권한이 있는 계정은 true, 없는 계정은 false
- Field (createdAt) — TIMESTAMP
- Field2 (updatedAt) — TIMESTAMP
- Field (shopIdx) — Integer — NOT NULL — isShop이 true인 경우, shopIdx를 지정해줌.