연월일시 백엔드 - 키오스크
테이블 (9)
contentclicks
- _id — VARCHAR(24) — 기본 키 — NOT NULL
- storeId — VARCHAR(24) — NOT NULL
- deviceId — VARCHAR(24) — 외래 키 → devices._id — NOT NULL
- contentType — ENUM('LIFETIME','COMPATIBILITY','PHYSIOGNOMY','AURA','TALISMAN','NAGGING') — NOT NULL
- sessionId — VARCHAR(64)
- converted — BOOLEAN
- paymentId — VARCHAR(24) — 외래 키 → payments._id
- createdAt — DATETIME
- updatedAt — DATETIME
coupons
- _id — VARCHAR(24) — 기본 키 — NOT NULL
- code — VARCHAR(64) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- type — ENUM('FIXED', 'PERCENT') — NOT NULL
- issuerType — ENUM('HEADQUARTER', 'DISTRIBUTOR', 'SELLER')
- duration — ENUM('DAYS_15', 'DAYS_30', 'MONTHS_3', 'MONTHS_6', 'YEAR_1', 'CUSTOM')
- value — INT — NOT NULL
- minOrderAmount — INT
- maxDiscountAmount — INT
- applicableStoreIds — JSON — ObjectId -> stores
- usageLimit — INT
- usedCount — INT
- perUserLimit — INT
- startDate — DATETIME — NOT NULL
- endDate — DATETIME — NOT NULL
- status — ENUM('ACTIVE', 'INACTIVE', 'EXPIRED')
- createdAt — DATETIME
- updatedAt — DATETIME
couponusages
- _id — VARCHAR(24) — 기본 키 — NOT NULL
- couponId — VARCHAR(24) — 외래 키 → coupons._id — NOT NULL
- paymentId — VARCHAR(24) — 외래 키 → payments._id — NOT NULL
- storeId — VARCHAR(24) — NOT NULL
- userId — VARCHAR(64)
- discountAmount — INT — NOT NULL
- usedAt — DATETIME — NOT NULL
- createdAt — DATETIME
- updatedAt — DATETIME
devices
- _id — VARCHAR(24) — 기본 키 — NOT NULL
- deviceCode — VARCHAR(64) — NOT NULL
- serialNumber — VARCHAR(64)
- name — VARCHAR(255) — NOT NULL
- storeId — VARCHAR(24) — NOT NULL
- installLocation — VARCHAR(255)
- installedAt — DATETIME
- programVersion — VARCHAR(50)
- status — ENUM('ACTIVE', 'WARNING', 'MAINTENANCE', 'ERROR', 'INACTIVE')
- statusDetail — VARCHAR(255)
- cardPrinter — JSON — {ribbon,film,totalPrintCount,lastPrintAt}
- photoPrinter — JSON — {ribbon,paper,totalPrintCount,lastPrintAt}
- lastSync — DATETIME
- deviceToken — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
fortune_pics
- _id — VARCHAR(24) — 기본 키 — NOT NULL
- name — VARCHAR(255)
- year — INT — NOT NULL
- month — INT — NOT NULL
- day — INT — NOT NULL
- hour — INT
- isHourUnknown — BOOLEAN
- gender — VARCHAR(10)
- language — VARCHAR(10)
- theme — VARCHAR(50) — NOT NULL — 1~5
- lifetime|compatibility|aura|talisman|nagging — 등'
- talismanImageStyle — VARCHAR(50)
- auraIndex — INT — {year,month,day}
- targetDate — JSON — 실데이터 대부분 비어있음
- code — VARCHAR(16) — NOT NULL
- imageUrl — VARCHAR(512)
- talismanImageUrl — VARCHAR(512)
- result — JSON — NOT NULL
- sajuData — JSON
- storeId — VARCHAR(24)
- deviceId — VARCHAR(24) — 외래 키 → devices._id
- paymentId — VARCHAR(24) — 외래 키 → payments._id — {name,printed,viewCount,expireAt}
- printed — BOOLEAN
- viewCount — INT
- isUserSaved — BOOLEAN
- inputTokens — INT
- outputTokens — INT
- totalTokens — INT
- createdAt — DATETIME
- updatedAt — DATETIME
minprices
- _id — VARCHAR(24) — 기본 키 — NOT NULL
- countryCode — ENUM('KR','CN','JP','EN') — NOT NULL
- minPrice — INT — NOT NULL
- currency — VARCHAR(10) — NOT NULL
- createdAt — DATETIME
- updatedAt — DATETIME
payments
- _id — VARCHAR(24) — 기본 키 — NOT NULL
- merchantUid — VARCHAR(64) — NOT NULL
- impUid — VARCHAR(64)
- storeId — VARCHAR(24) — NOT NULL
- deviceId — VARCHAR(24) — 외래 키 → devices._id — NOT NULL
- receipt — JSON — 단말기 원본(tranCode,amount,paymentMethod...)
- cancelReceipt — JSON
- productType — ENUM('LIFETIME', 'COMPATIBILITY', 'PHYSIOGNOMY', 'AURA', 'TALISMAN', 'NAGGING') — NOT NULL
- productQuantity — INT
- status — ENUM('READY', 'PAID', 'CANCELLED')
- couponId — VARCHAR(24) — 외래 키 → coupons._id
- paidAt — DATETIME
- cancelledAt — DATETIME
- cancelReason — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
pricings
- _id — VARCHAR(24) — 기본 키 — NOT NULL
- contentCode — ENUM('LIFETIME', 'COMPATIBILITY', 'TALISMAN', 'NAGGING', 'SAJU', 'TAROT') — NOT NULL
- countryCode — ENUM('KR', 'CN', 'JP', 'EN') — NOT NULL
- scope — ENUM('COUNTRY', 'DEVICE') — NOT NULL
- deviceId — VARCHAR(24) — 외래 키 → devices._id — scope=DEVICE 일 때만
- isFree — BOOLEAN — NOT NULL
- price — INT — NOT NULL
- currency — VARCHAR(10) — NOT NULL
- createdAt — DATETIME
- updatedAt — DATETIME
results
- _id — VARCHAR(24) — 기본 키 — NOT NULL
- resultCode — VARCHAR(32) — NOT NULL
- storeId — VARCHAR(24) — NOT NULL
- deviceId — VARCHAR(24) — 외래 키 → devices._id — NOT NULL
- paymentId — VARCHAR(24) — 외래 키 → payments._id — NOT NULL
- inputData — JSON
- updatedAt — DATETIME