연월일시 백엔드 - 웹
테이블 (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