연월일시 백엔드 - 웹

테이블 (9)

devices

  • _id — VARCHAR(24) — 기본 키 — NOT NULL

emailverifications

  • _id — VARCHAR(24) — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • codeHash — VARCHAR(255) — NOT NULL
  • purpose — VARCHAR(20) — NOT NULL
  • expiresAt — DATETIME — NOT NULL
  • attempts — INT
  • consumed — TINYINT(1)
  • lastSentAt — DATETIME
  • createdAt — DATETIME
  • updatedAt — DATETIME

fortune_pics

  • _id — VARCHAR(24) — 기본 키 — NOT NULL
  • user — VARCHAR(24) — 외래 키 → users._id
  • name — VARCHAR(255)
  • year — INT — NOT NULL
  • month — INT — NOT NULL
  • day — INT — NOT NULL
  • hour — INT
  • isHourUnknown — TINYINT(1)
  • gender — VARCHAR(10)
  • language — VARCHAR(10)
  • theme — VARCHAR(50) — NOT NULL
  • talismanTheme — VARCHAR(50)
  • talismanImageStyle — VARCHAR(50)
  • auraIndex — INT
  • targetDate — JSON
  • code — VARCHAR(5) — NOT NULL
  • imageUrl — VARCHAR(512)
  • talismanImageUrl — VARCHAR(512)
  • result — JSON — NOT NULL
  • sajuData — JSON
  • storeId — VARCHAR(24) — 외래 키 → stores._id
  • deviceId — VARCHAR(24) — 외래 키 → devices._id
  • paymentId — VARCHAR(24) — 외래 키 → payments._id
  • printed — TINYINT(1)
  • viewCount — INT
  • isUserSaved — TINYINT(1)
  • inputTokens — INT
  • outputTokens — INT
  • totalTokens — INT
  • createdAt — DATETIME
  • updatedAt — DATETIME

identities

  • _id — VARCHAR(24) — 기본 키 — NOT NULL
  • userId — VARCHAR(24) — 외래 키 → users._id — NOT NULL
  • provider — VARCHAR(10) — NOT NULL
  • providerId — VARCHAR(255) — NOT NULL
  • linkedAt — DATETIME — NOT NULL

payments

  • _id — VARCHAR(24) — 기본 키 — NOT NULL

storage_items

  • _id — VARCHAR(24) — 기본 키 — NOT NULL
  • user — VARCHAR(24) — 외래 키 → users._id — NOT NULL
  • fortunePicId — VARCHAR(24) — 외래 키 → fortune_pics._id — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

stores

  • _id — VARCHAR(24) — 기본 키 — NOT NULL

users

  • _id — VARCHAR(24) — 기본 키 — NOT NULL
  • email — VARCHAR(255)
  • nickname — VARCHAR(255)
  • name — VARCHAR(255)
  • profileImage — VARCHAR(512)
  • gender — VARCHAR(10)
  • phone — VARCHAR(30)
  • ageGroup — VARCHAR(10)
  • birthDate — VARCHAR(10)
  • calendarType — VARCHAR(10)
  • hour — INT
  • minute — INT
  • isHourUnknown — TINYINT(1)
  • marketingConsent — TINYINT(1)
  • marketingConsentAt — DATETIME
  • messagingConsent — TINYINT(1)
  • messagingConsentAt — DATETIME
  • passwordHash — VARCHAR(255)
  • emailVerifiedAt — DATETIME
  • refreshTokenHash — VARCHAR(255)
  • lastLoginAt — DATETIME
  • createdAt — DATETIME
  • updatedAt — DATETIME

withdrawal_surveys

  • _id — VARCHAR(24) — 기본 키 — NOT NULL
  • reason — VARCHAR(30) — NOT NULL
  • feedback — TEXT
  • createdAt — DATETIME
  • updatedAt — DATETIME