LI-ON

Tables (11)

ALARM

  • id — INT — Primary key — NOT NULL
  • event_id — INT — Foreign key → CALENDAR_EVENT.id — NOT NULL
  • remind_at — DATETIME — NOT NULL
  • sent_at — DATETIME
  • status — VARCHAR(10) — NOT NULL — PENDING / SENT / FAILED

CALENDAR_EVENT

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.id — NOT NULL
  • roadmap_step_id — INT — Foreign key → ROADMAP_STEP.id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

CERTIFICATION

  • jm_cd — VARCHAR(10) — Primary key — NOT NULL — 종목코드
  • jm_nm — VARCHAR(100) — NOT NULL — 종목명
  • qual_gb_cd — VARCHAR(2) — NOT NULL — T S W C
  • series_nm — VARCHAR(100)
  • doc_pass_rate — FLOAT
  • prac_pass_rate — FLOAT
  • doc_fee — INT
  • prac_fee — INT
  • mdoblig_fld_nm — VARCHAR(100) — qual_detail 흡수
  • career — TEXT
  • job — TEXT
  • summary — TEXT
  • trend — TEXT
  • hist — TEXT

CHAT_MESSAGE

  • id — INT — Primary key — NOT NULL
  • session_id — INT — Foreign key → CHAT_SESSION.id — NOT NULL
  • sender — VARCHAR(10) — NOT NULL — USER / AI
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

CHAT_SESSION

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.id — NOT NULL
  • jm_cd — VARCHAR(10) — Foreign key → CERTIFICATION.jm_cd
  • title — VARCHAR(255) — NOT NULL
  • roadmap_title — VARCHAR(255) — roadmap 흡수
  • roadmap_created_at — DATETIME — 로드맵 미수립이면 NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

DEVICE_TOKEN

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.id — NOT NULL
  • token — VARCHAR(512) — NOT NULL — FCM 토큰(512)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

EXAM_SCHEDULE

  • impl_yy — SMALLINT — Primary key — NOT NULL
  • impl_seq — VARCHAR(10) — Primary key — NOT NULL
  • reg_key — DATE — Primary key — NOT NULL — STORED 생성 컬럼
  • jm_cd — VARCHAR(10) — Foreign key → CERTIFICATION.jm_cd — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • doc_reg_start_dt — DATE — NOT NULL
  • doc_reg_end_dt — DATE — NOT NULL
  • doc_exam_start_dt — DATE — NOT NULL
  • doc_exam_end_dt — DATE — NOT NULL
  • doc_pass_dt — DATE — NOT NULL
  • prac_reg_start_dt — DATE — NOT NULL
  • prac_reg_end_dt — DATE — NOT NULL
  • prac_exam_start_dt — DATE — NOT NULL
  • prac_exam_end_dt — DATE — NOT NULL
  • prac_pass_dt — DATE — NOT NULL

RECOMMENDATION

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.id — NOT NULL — UK, 사용자당 1건
  • items — JSON — NOT NULL — recommendation_item 대체
  • generated_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

RESOURCE

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.id — NOT NULL
  • session_id — INT — Foreign key → CHAT_SESSION.id
  • jm_cd — VARCHAR(10) — Foreign key → CERTIFICATION.jm_cd
  • title — VARCHAR(255) — NOT NULL
  • url — VARCHAR(500) — NOT NULL
  • type — VARCHAR(10) — NOT NULL — LINK 고정
  • memo — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

ROADMAP_STEP

  • id — INT — Primary key — NOT NULL
  • session_id — INT — Foreign key → CHAT_SESSION.id — NOT NULL — roadmap_id 대체
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • order_no — INT — NOT NULL
  • target_date — DATE

USER

  • id — INT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL — user_profile 흡수
  • is_onboarded — BOOLEAN — NOT NULL
  • onboarded_at — DATETIME
  • onboarding_answers — JSON — onboarding_answer, user_desired_field 대체
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • DeviceToken_id — INT — NOT NULL — FK