Side
Tables (7)
Untitled (User)
- Key (userId) — INT UNSIGNED — Primary key — NOT NULL
- Field (userName) — VARCHAR — NOT NULL
- Field (userEmail) — VARCHAR — NOT NULL
- Field2 (userPassword) — VARCHAR — NOT NULL
- Field (userImage) — TEXT
- Field (userLike) — INT UNSIGNED — NOT NULL
Untitled (Review)
- Key (reviewId) — INT UNSIGNED — Primary key — NOT NULL
- Field (reviewTitle) — VARCHAR — NOT NULL
- Field2 (reviewContent) — VARCHAR — NOT NULL
- Key (userId) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
Untitled (Store)
- Key (storeId) — INT UNSIGNED — Primary key — NOT NULL — 가게 도메인
- Field (storeName) — VARCHAR — NOT NULL
- Field (storeAddress) — VARCHAR — NOT NULL
- Field2 (storeCategory) — INT UNSIGNED — NOT NULL — ex) 1: 양식 2: 중식
Untitled (ReviewPhoto)
- Key (reviewPhotoId) — INT UNSIGNED — Primary key — NOT NULL
- Key (reviewId) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- Key (reviewPhoto) — VARCHAR — NOT NULL
Untitled (UserEtc)
- Key (userId) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- Field (userPoint) — INT UNSIGNED — NOT NULL
- Field2 (userCoupon) — VARCHAR
Untitled (UserPointUsageHistory)
- Key (userId) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- Field (history) — VARCHAR — NOT NULL — ex) history1, history2
- Field (usagePoint) — INT UNSIGNED — NOT NULL
- Field (createdAt) — TIMESTAMP
- Field (updatedAt) — TIMESTAMP
Untitled (ReviewLike)
- Key (reviewId) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- Key (userId) — INT UNSIGNED — Foreign key → Untitled.Key — NOT NULL
- Field (reviewLike) — ENUM — NOT NULL — ex) 0: 좋아요 X, 1: 좋아요 O