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