MoHaeng

Tables (13)

Admin

  • username — VARCHAR(45) — Primary key — NOT NULL — unique username
  • password — VARCHAR(255) — NOT NULL — password
  • email — VARCHAR(45) — NOT NULL — email
  • phone — VARCHAR(45) — phone
  • role — ENUM — NOT NULL — role. user, admin, owner, master, ...
  • createdAt — TIMESTAMP — NOT NULL — createdAt
  • updatedAt — TIMESTAMP — NOT NULL — updatedAt
  • lastLogin — TIMESTAMP — lastLogin
  • status — ENUM — NOT NULL — status. active, inactive, deleted

BlackList

  • userId — INT — Foreign key → User.userId — NOT NULL — userId
  • blockedFeature — ENUM — NOT NULL — blockedFeature. ex) posting, commenting, messaging, ...
  • addedDate — DATETIME — NOT NULL — addedDate
  • removedDate — DATETIME — removedDate

Category (CommonCode)

  • Key (CODE) — VARCHGAR(45) — Primary key — NOT NULL
  • Field (CODE_TYPE) — VARCHAR(45) — NOT NULL — A00, A01, ...
  • name (CODE_NAME) — VARCHAR(45) — NOT NULL

Event

  • eventId — INT — Primary key — NOT NULL
  • shopId — INT — Foreign key → Shop.shopId — NOT NULL
  • Field (categoryCode) — VARCHAR(45) — NOT NULL — Common Code
  • details — ENUM — NOT NULL — 1+1, 2+1, 가격할인, 쿠폰, ...
  • price — DECIMAL(18, 0) — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • description — TEXT
  • imageURL — TEXT — NOT NULL
  • startDate — DATETIME — NOT NULL
  • endDate — DATETIME — NOT NULL
  • Field (createdBy) — ENUM — NOT NULL — crawler, user, owner
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • status — ENUM — NOT NULL — active, inactive, deleted

Favorite

  • favoriteId — INT — Primary key — NOT NULL — favoriteId
  • userId — INT — Foreign key → User.userId — NOT NULL — userId
  • eventId — INT — Foreign key → Event.eventId — NOT NULL
  • Key — Foreign key — NOT NULL

Location

  • Key (locationId) — INT — Primary key — NOT NULL
  • userId — INT — Foreign key → User.userId — NOT NULL — userId
  • name — VARCHAR(45) — NOT NULL
  • Field3 (address) — VARCHAR(255) — NOT NULL
  • Field (latitude) — DECIMAL(9, 6) — NOT NULL — latitude. 위도
  • Field2 (longitude) — DECIMAL(9, 6) — NOT NULL — longitude. 경도
  • createdAt — TIMESTAMP — NOT NULL — createdAt
  • updatedAt — TIMESTAMP — NOT NULL — updatedAt
  • Field (isBased) — boolean — NOT NULL
  • status — ENUM — NOT NULL — status. active, inactive, deleted

Owner

  • ownerId — INT — Primary key — NOT NULL
  • Key (shopName) — VARCHAR(45) — Foreign key → ShopDetail.Key — NOT NULL — shopName Unique
  • Key — Foreign key → ShopDetail.Key — NOT NULL

Payment

  • paymentid — INT — Primary key — NOT NULL
  • ownerId — INT — Foreign key → Owner.ownerId — NOT NULL
  • Key — Foreign key → Owner.Key — NOT NULL

PaymentProduct

  • paymentProductId — INT — Primary key — NOT NULL
  • paymentid — INT — Foreign key → Payment.paymentid
  • Key — Foreign key → Payment.Key — NOT NULL

Shop

  • shopId — INT — Primary key — NOT NULL
  • type — ENUM — NOT NULL — Franchise, Each
  • Field (brandCode) — VARCHAR(45) — NOT NULL — Common Code

ShopDetail

  • Key (shopName) — VARCHAR(45) — Primary key — NOT NULL — shopName Unique
  • Key (shopDetailId) — INT — Primary key — NOT NULL
  • shopId — INT — Foreign key → Shop.shopId — NOT NULL
  • address — VARCHAR(255) — NOT NULL — address
  • Field2 (localGoverment) — VARCHAR(45) — NOT NULL — 기초지방자치단체
  • latitude — DECIMAL(9, 6) — NOT NULL — latitude
  • logitude — DECIMAL(9, 6) — NOT NULL — longitude
  • imageURL — TEXT
  • createdAt — TIMESTAMP — NOT NULL — createdAt
  • updatedAt — TIMESTAMP — NOT NULL — updatedAt
  • status — ENUM — NOT NULL — status. active, inactive, deleted

User

  • userId — INT — Primary key — NOT NULL — userId
  • email — VARCHAR(255) — NOT NULL — email
  • username — VARCHAR(45) — username
  • provider — VARCHAR(255) — NOT NULL — provider. Kakao, Google, ...
  • providerId — VARCHAR(255) — NOT NULL — providerId
  • createdAt — TIMESTAMP — NOT NULL — createdAt
  • updatedAt — TIMESTAMP — NOT NULL — updatedAt
  • Field (role) — ENUM — NOT NULL — role. user, admin, owner, ...
  • status — ENUM — NOT NULL — status. active, inactive, deleted

View

  • viewId — INT — Primary key — NOT NULL
  • eventId — INT — Foreign key → Event.eventId — NOT NULL
  • viewCount — INT — NOT NULL — 조회수
  • date — DATETIME — NOT NULL — 날짜