Fortune
Tables (10)
AiPrompt (AI 프롬프트 정보)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- system (시스템 프롬프트) — text
- prefix (프롬프트) — text
- version (프롬프트 버전) — text
AiRes (AI Response 정보)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- res_id (응답 아이디) — text
- res (응답 컨텐츠) — GPT_Response
- Field
- ai_prompt (AI 프롬프트 정보) — AiPrompt — Foreign key → AiPrompt.unique_id — NOT NULL
CalculateLog (사주계산 정보)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- res_id (응답 아이디) — text
- lunar_at (음력) — DateTime
- seasons (절기) — text
- heavenly_stems (천간) — text
- earthly_branches (지지) — text
- year_pillar (년주) — text
- month_pillar (월주) — text
- day_pillar (일주) — text
- hour_pillar (시주) — text
- total_score (종합 운 점수) — number
- wealth_score (재물운) — number
- health_score (건강운) — number
- love_score (애정운) — number
- success_score (성취운) — number
Certify (인증)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- certify_type (인증 유형) — CERTIFY_TYPE
- phone (휴대폰 번호) — text
- code (코드) — text
- expired_at (만료 시간) — DateTime
HomeRandom (홈 멘트)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- contents (내용) — text
- image (이미지) — image
Term (약관)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- term_type (약관 유형) — TERM_TYPE
- last_update_at (마지막 수정 일자) — DateTime
- contents (내용) — text
User (유저)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- email (이메일) — text
- password (비밀번호) — text
- init_password (초기 비밀번호) — text
- control_password (조작 비밀번호) — text
- phone (전화번호) — text
- user_type (유저 유형) — USER_TYPE
- user_state (유저 상태) — USER_STATE
- login_type (로그인 유형) — LOGIN_TYPE
- name (이름) — text
- birth_at (생년월일) — DateTime
- lunar_at (음력) — text
- heavenly_stems (천간) — text
- earthly_branches (지지) — text
- year_pillar (년주) — text
- month_pillar (월주) — text
- day_pillar (일주) — text
- hour_pillar (시주) — text
UserAiChat (유저 AI 챗)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- chat_date (채팅날짜) — text
- chat_at (채팅 일자) — DateTime
- contents (채팅 내용) — text
- user (유저) — User — Foreign key → User.unique_id — NOT NULL
- ai_res (AI Response 정보) — AiRes — Foreign key → AiRes.unique_id — NOT NULL
UserFortuneInfo (유저 운세)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- date (년월일) — text
- ganzhi (간지일) — text
- total_score (종합 운 점수) — number
- wealth_score (재물운) — number
- health_score (건강운) — number
- love_score (애정운) — number
- success_score (성취운) — number
- user (유저) — User — Foreign key → User.unique_id — NOT NULL
- calculate_log (계산 정보) — CalculateLog — Foreign key → CalculateLog.unique_id — NOT NULL
UserNotification (알림)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- notification_type (알림 유형) — NOTIFICATION_TYPE
- contents (내용) — text
- created_at (생성 일자) — DateTime
- user (유저) — User — Foreign key → User.unique_id — NOT NULL