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