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