연월일시 백엔드 - 키오스크

테이블 (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