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 — 날짜