인재DBv2
테이블 (50)
an_aptd_opt_dtl
- id — bigint — 기본 키 — NOT NULL
- fctr — text
- lbl_nm — text
- opt_no — integer
- high_fctr — text
- qitm_no — bigint — 외래 키 → an_aptd_qst_mst.id
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
an_aptd_qst_mst
- id — bigint — 기본 키 — NOT NULL
- qitm_txt — text — NOT NULL
- ordg — integer
- type — text — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
an_aptd_rslt_inf
- id — bigint — 기본 키 — NOT NULL
- reg_dtm — timestamp(6)
- high_fctr_json — text
- mem_no — character — NOT NULL
- fctr_json — text
- rgst_id — character
- rgst_ip — character
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
an_case_skill_det
- case_id — bigint — 외래 키 → an_success_case_mst.id — NOT NULL
- skl — character — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- skl_nm — character
an_market_trend_mst
- id — bigint — 기본 키 — NOT NULL
- reg_dtm — timestamp(6)
- imp_scor_val — integer — NOT NULL
- trgt_ind_nm — character — NOT NULL
- insg_cntn — text
- job_csf — character — NOT NULL
- pblc_dtm — timestamp(6)
- src_url_adr — character
- smry_cntn — text
- rgst_id — character
- rgst_ip — character
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- trnd_mst_id — bigint — NOT NULL
- ordg — integer
an_signal_radar
- sig_id — bigint — 기본 키 — NOT NULL
- chgp_id — character
- chgp_ip — character
- reg_dtm — timestamp(6)
- rgst_id — character
- rgst_ip — character
- chg_dtm — timestamp(6)
- lat — double — NOT NULL
- lng — double — NOT NULL
- status — character
- topic — character
- sig_type — character
- usr_id — bigint — 외래 키 — NOT NULL
- GREEN::character — varying)::text)))
- EXPIRED::character — varying
- CANCELLED::character — varying)::text)))
an_success_case_mst
- id — bigint — 기본 키 — NOT NULL
- trgt_ind_nm — character
- trgt_job_nm — character
- co_nm — character
- co_typ_cd — character
- univ_nm — character
- mjr_nm — character
- gpa_val — double
- exp_smry_cntn — text
- rsm_hi_cntn — text
- intv_q_cntn — text
- view_cnt — integer
- reg_dtm — timestamp
- rgst_id — character
- rgst_ip — character
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- succ_case_id — bigint — NOT NULL
- ordg — integer
an_swarm_msg_inf
- id — character — 기본 키 — NOT NULL
- author — character — NOT NULL
- avatar — character
- backstory — text
- board_id — character — NOT NULL
- debate_role — character
- debate_round — integer
- dislike_count — integer
- evidence — character
- external_url — character
- gender — character
- is_real_ai — boolean — NOT NULL
- is_user — boolean — NOT NULL
- like_cnt — integer
- related_source_id — character
- reply_to_id — character
- text — text
- vibe — character
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- user_id — bigint — 외래 키
an_swarm_psn_inf
- id — bigint — 기본 키 — NOT NULL
- avatar — character
- backstory — text
- company — character
- reg_dtm — timestamp(6)
- gender — character
- is_active — boolean
- level — character
- name — character — NOT NULL
- role — character
- tags — character
- vibe — character
- rgst_id — character
- rgst_ip — character
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
an_swarm_tag_dtl
- swarmmessage_id — character — 외래 키 → an_swarm_msg_inf.id — NOT NULL
- tags — character
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
an_trend_kwd_det
- trend_id — bigint — 외래 키 → an_market_trend_mst.id — NOT NULL
- keyword — character
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- kwd_nm — character
ap_aplt_act_dtl
- id — bigint — 기본 키 — NOT NULL
- actv_type — text
- description — text
- end_dt — text
- orgn_nm — text
- strt_dt — text
- snapshot_id — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no
- actv_typ_cd — character
- actv_cntn — text
- actv_strt_dt — character
- actv_end_dt — character
- actv_nm — character
ap_aplt_add_pnt_inf
- id — bigint — 기본 키 — NOT NULL
- dsb_type — text
- reg_num — text
- relation — text
- severity — text
- type — text
- vtrn_type — text
- snapshot_id — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- seq — bigint — NOT NULL
- add_pnt_type_gbcd — character
- dsbl_type_gbcd — character
- reg_no — character
- rel_gbcd — character
- svrt_gbcd — character
- vtrn_type_gbcd — character
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
ap_aplt_awrd_inf
- id — bigint — 기본 키 — NOT NULL
- date — text
- description — text
- issuer — text
- name — text
- snapshot_id — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- seq — bigint — NOT NULL
- awrd_cntn — text
- awrd_nm — character — NOT NULL
- awrd_dt — character
- awrd_istn — character
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
ap_aplt_carr_inf
- id — bigint — 기본 키 — NOT NULL
- department — text
- description — text
- industry — text
- is_current — boolean
- location — text
- position — text
- salary — text
- snapshot_id — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- business_type — character
- co_no — character
- carr_co_nm — character
- end_dt — character
- job_rank — character
- strt_dt — character
- seq — bigint — NOT NULL
- biz_typ_nm — character
- carr_co_cd — character
- curr_wrk_yn — boolean
- dept_nm — character
- carr_end_dt — character
- ind_nm — character
- pstn_nm — character
- job_rnk_nm — character
- loc_nm — character
- slry_amt_cntn — character
- carr_strt_dt — character
- rspt_tsk — text
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no
ap_aplt_chg_log
- id — bigint — 기본 키 — NOT NULL
- change_description — text
- itm_nm — text
- section — text — NOT NULL
- snapshot_id — bigint — 외래 키 → ap_aplt_inf.aplt_no
- user_id — bigint — 외래 키 — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- chg_type — character — NOT NULL
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no
- UPDATED::character — varying
- DELETED::character — varying)::text)))
ap_aplt_edu_inf
- id — bigint — 기본 키 — NOT NULL
- dgr_nm — text
- end_dt — date
- gpa_val — double
- grd_stat_cd — text
- mjr_nm — text
- strt_dt — date
- univ_nm — text
- snps_id — bigint — 외래 키 — NOT NULL
- univ_id — bigint — 외래 키
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- seq — bigint — NOT NULL
- edu_gbcd — character
- edu_end_dt — date
- edu_time — double
- edu_lvl_gbcd — character
- edu_curs_nm — character
- edu_strt_dt — date
- edu_istn_nm — character
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
- GRADUATED::character — varying
- GRADUATION_EXPECTED::character — varying
- LEAVE_OF_ABSENCE::character — varying
- DROPOUT::character — varying)::text)))
ap_aplt_exp_inf
- seq — bigint — 기본 키 — NOT NULL
- exp_end_dt — character
- exp_cntn — text
- exp_nm — character — NOT NULL
- proj_url — character
- role_nm — character
- exp_strt_dt — character
- tech_stck_cntn — character
- sn_expr_id — bigint — 외래 키 → ap_aplt_carr_inf.id
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
ap_aplt_expc_inf
- id — bigint — 기본 키 — NOT NULL
- perf_cntn — text
- wrk_cntn — text
- end_dt — date
- posi_nm — text
- strt_dt — date
- co_id — bigint — 외래 키 → cm_co_mst.id
- snps_id — bigint — 외래 키 — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- seq — bigint — NOT NULL
- expc_end_dt — date
- expc_main_tsk — text
- expc_titl — character
- expc_strt_dt — date
- expc_cntn — text
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
ap_aplt_file_inf
- id — bigint — 기본 키 — NOT NULL
- pdf_url — text
- template_type — text
- title — text — NOT NULL
- snapshot_id — bigint — 외래 키 — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- seq — bigint — NOT NULL
- fpath — character
- file_gbcd — character
- fnm — character — NOT NULL
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
ap_aplt_goal_inf
- id — bigint — 기본 키 — NOT NULL
- completed_at — timestamp
- description — text
- status — text — NOT NULL
- title — text — NOT NULL
- source_answer_id — bigint — 외래 키 → bd_answ_mst.id
- user_id — bigint — 외래 키 — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
ap_aplt_inf
- aplt_no — bigint — 기본 키 — NOT NULL
- carer_stg_cd — text
- core_kwd_cntn — text
- curr_cncr_cntn — text
- edu_cntn — text
- emot_cntn — text
- mndst_cntn — text
- skll_cntn — text
- strg_othr_cntn — text
- trgt_co_typ_cd — text
- wrk_yy_cnt — integer
- trgt_duty_ctgr_id — bigint — 외래 키 → cm_job_cate_mst.job_ctgr_id
- trgt_duty_loc_id — bigint — 외래 키 → cm_job_psn_mst.job_pos_id
- mem_no — bigint — 외래 키 — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
ap_aplt_it_use_dtl
- id — bigint — 기본 키 — NOT NULL
- category — text
- level — text
- name — text
- snapshot_id — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no
- it_use_nm — character
- it_use_typ_cd — character
- it_use_lvl_cd — character
ap_aplt_it_use_inf
- id — bigint — 기본 키 — NOT NULL
- category — text
- level — text
- name — text — NOT NULL
- snapshot_id — bigint — 외래 키 — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- seq — bigint — NOT NULL
- it_lang_type_nm — character
- use_lvl — character
- it_lang_nm — character — NOT NULL
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
- INTERMEDIATE::character — varying
- ADVANCED::character — varying
- EXPERT::character — varying)::text)))
ap_aplt_lang_exam_inf
- id — bigint — 기본 키 — NOT NULL
- grade — text
- name — text
- score — text
- snapshot_id — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- exam_date — character
- seq — bigint — NOT NULL
- lang_exam_nm — character — NOT NULL
- exam_obtn_dt — character
- exam_lvl — character
- exam_scrg — character
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
ap_aplt_lcns_inf
- id — bigint — 기본 키 — NOT NULL
- issuer — text
- lcns_nm — text
- snapshot_id — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- issue_date — character
- seq — bigint — NOT NULL
- lcns_reg_no — character
- lcns_obtn_dt — character
- lcns_pblc — character
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no
ap_aplt_ledu_inf
- id — bigint — 기본 키 — NOT NULL
- advisor — text
- day_night — text
- degree — text
- degree_type — text
- gpa — double
- graduation_year — text
- is_transfer — boolean
- lab — text
- location — text
- major — text
- snapshot_id — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- end_dt — character
- graduation_status — character
- strt_dt — character
- univ_cd — character
- univ_nm — character
- seq — bigint — NOT NULL
- advs_prof_nm — character
- day_ngt_cd — character
- dmj_cd — character
- degr_typ_cd — character
- ledu_end_dt — character
- gpa_val — double
- grdt_gbcd — character
- grdt_yy — character
- lab_nm — character
- loc_nm — character
- dmj_nm — character
- univ_no — character
- ledu_strt_dt — character
- trsf_yn — boolean
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no
ap_aplt_prj_dtl
- id — bigint — 기본 키 — NOT NULL
- description — text
- name — text
- role — text
- experience_id — bigint — 외래 키 → ap_aplt_carr_inf.id
- snapshot_id — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- end_dt — character
- strt_dt — character
- tech_stack — character
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no
- prj_nm — character
- prj_cntn — text
- prj_role_nm — character
- prj_strt_dt — character
- prj_end_dt — character
- prj_tech_stack_cntn — text
ap_aplt_psn_inf
- id — bigint — 기본 키 — NOT NULL
- snapshot_id — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- strength_type — character — NOT NULL
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no
- WORK_EXP::character — varying
- EDUCATION::character — varying
- CERTIFICATE::character — varying
- PORTFOLIO::character — varying
- OTHER::character — varying)::text)))
ap_aplt_rcrt_his_log
- id — bigint — 기본 키 — NOT NULL
- analysis_json — text
- archived_at — timestamp(6)
- ats_score — integer
- company_name — character — NOT NULL
- job_title — character — NOT NULL
- snapshot_url — text
- status — character
- url — text — NOT NULL
- verified — boolean — NOT NULL
- user_id — bigint — 외래 키 — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
ap_aplt_trng_dtl
- id — bigint — 기본 키 — NOT NULL
- description — text
- institution — text
- snapshot_id — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- end_dt — character
- strt_dt — character
- training_hours — character
- training_name — character
- training_type — character
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no
- trng_nm — character
- trng_cntn — text
- trng_istn_nm — character
- trng_strt_dt — character
- trng_end_dt — character
- trng_time — character
- trng_typ_cd — character
ap_aplt_vtwrk_inf
- seq — bigint — 기본 키 — NOT NULL
- vt_cntn — text
- vt_nm — character — NOT NULL
- vt_end_dt — character
- vt_istn_nm — character
- vt_strt_dt — character
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no — NOT NULL
ap_squad_match_inf
- id — bigint — 기본 키 — NOT NULL
- requester_id — bigint — 외래 키 — NOT NULL
- target_user_id — bigint — 외래 키 — NOT NULL
- synergy_score — integer
- synergy_reason — text
- status — character
- created_at — timestamp
- rgst_id — character
- rgst_ip — character
- chgp_id — character
- chgp_ip — character
- updated_at — timestamp
au_eml_log
- eml_log_id — bigint — 기본 키 — NOT NULL
- msg_id — character
- rcv_eml_addr — character — NOT NULL
- send_eml_addr — character — NOT NULL
- sbjt_cntn — character
- send_cntn — text
- send_rsn — character
- send_stat_cd — character
- fail_rsn — text
- send_dtm — timestamp
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
bd_answ_mst
- id — bigint — 기본 키 — NOT NULL
- adopted_at — timestamp
- authordesc — text
- authorrole — text
- content — text
- currwork — text
- prevwork — text
- skills — text
- author_id — bigint — 외래 키
- post_id — bigint — 외래 키 → bd_post_mst.pst_id
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- author_desc — character
- author_name — character
- author_role — character
- curr_work — character
- is_adopted — boolean — NOT NULL
- prev_work — character
- answ_id — bigint — NOT NULL
- adpt_dtm — timestamp(6)
- adpt_yn — boolean
- answ_cntn — text — NOT NULL
- autr_desc_cntn — character
- autr_nm — character
- autr_role_cd — character
- curr_wrk_cntn — character
- prev_wrk_cntn — character
- skll_cntn — character
- usr_id — bigint — 외래 키
- pst_id — bigint — 외래 키 → bd_post_mst.pst_id
bd_post_mst
- pst_id — bigint — 기본 키 — NOT NULL
- autr_spec_titl — text
- pst_cat_nm — text
- pst_cntn — text
- advc_typ_cntn — text
- cons_usr_id — bigint
- alum_only_yn — boolean
- optn_a_cntn — text
- optn_b_cntn — text
- tags — text
- co_typ_trgt_cntn — text
- trgt_grp_nm — text
- trgt_ind_nm — text
- trgt_job_nm — text
- univ_trgt_nm — text
- pst_titl — text
- usr_id — bigint — 외래 키
- snps_id — bigint — 외래 키
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- author_spec_title — character
- desired_advice_types — character
- direct_senior_id — bigint
- target_company_type — character
- target_group — character
- target_industry — character
- target_job — character
- target_university_name — character
- actv_yn — boolean
- view_cnt — integer
- like_cnt — integer
- pts_amt — integer — 포인트
- rct_stat_cd — character — 모집
- rgn_nm — character
- edu_lvl_nm — character
- exp_year_cnt — character
- std_kind_cd — character — 스터디
- std_form_cd — character
- max_mbr_cnt — integer
- curr_mbr_cnt — integer
- dur_week_cnt — integer
- aprv_mode_cd — character
- nxt_act_cd — character — 차기
- task_rule_cntn — text
- week_goal_cntn — text
- nxt_sesn_dtm — timestamp
- loop_act_cnt — integer
- prog_rate — numeric(38,2)
- engg_rate — numeric(38,2)
- tot_outc_cnt — integer
- app_cnt — integer
- scrap_url_addr — text
- scrap_rmk_cntn — text
- aplt_no — bigint — 외래 키 → ap_aplt_inf.aplt_no
bd_std_inf
- id — bigint — 기본 키 — NOT NULL
- host_id — bigint — 외래 키
- title — text — NOT NULL
- description — text
- tags — text
- status — text
- max_members — integer
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
bd_std_mbr_dtl
- id — bigint — 기본 키 — NOT NULL
- study_id — bigint — 외래 키 → bd_std_inf.id
- user_id — bigint — 외래 키
- status — text
- application_memo — text
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
bd_std_post_inf
- id — bigint — 기본 키 — NOT NULL
- study_id — bigint — 외래 키 → bd_std_inf.id
- user_id — bigint — 외래 키
- title — text — NOT NULL
- content — text
- tags — text
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
checkins
- id — uuid — 기본 키 — NOT NULL
- user_id — uuid
- basecamp_id — uuid
- check_in_time — timestamp
- check_out_time — timestamp
- lat — double
- lng — double
- is_verified — boolean
- checkin_type — text
- comment — text — ex
- created_at — timestamp
cm_cd_mst
- csf_cd — text — 기본 키 — NOT NULL
- cd — text — 기본 키 — NOT NULL
- cd_nm — text — NOT NULL
- high_csf_cd — text
- sort_ordg — integer
- cd_desc — text
- use_yn — character — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
cm_cmn_dom_mst
- id — bigint — 기본 키 — NOT NULL
- domain_code — character — NOT NULL
- domain_name — character — NOT NULL
- ordg — integer — NOT NULL
- active_yn — boolean — NOT NULL
- note — text
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
cm_co_ideal_dtl
- id — bigint — 기본 키 — NOT NULL
- agility — double
- challenge — double
- clashpoints — text
- collaboration — double
- communication — double
- description — text
- expertise — double
- growth — double
- industry — text
- innovation — double
- logourl — text
- matchtags — text
- name — text — NOT NULL
- proactivity — double
- responsibility — double
- synergypoints — text
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- clash_points — character
- logo_url — character
- match_tags — character
- synergy_points — character
cm_co_mst
- id — bigint — 기본 키 — NOT NULL
- code — text — NOT NULL
- industry — text
- name — text — NOT NULL
- size — text
- rgst_id — character
- rgst_ip — character
- created_at — timestamp
- chgp_id — character
- chgp_ip — character
- updated_at — timestamp
cm_crwl_log
- id — text — 기본 키 — NOT NULL
- itemsfound — integer — NOT NULL
- itemssaved — integer — NOT NULL
- message — text
- sourcename — text
- status — text
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- source_id — text — 외래 키 → cm_crwl_src_mst.id
- batch_key — character
- trigger_type — character
- started_at — timestamp
- finished_at — timestamp
- fetched_count — integer
- inserted_count — integer
- normalized_count — integer
- updated_count — integer
- duplicate_count — integer
- invalid_count — integer
- http_status — integer
- request_url — text
- error_code — character
- error_detail — text
- source_name — character
- btch_key_val — character
- crwl_end_dtm — timestamp(6)
- crwl_src_id — character
- crwl_src_nm — character
- crwl_stat_cd — character
- crwl_strt_dtm — timestamp(6)
- dup_cnt — integer
- err_cd — character
- err_detl_cntn — text
- fnd_cnt — integer
- fth_cnt — integer
- http_stat_cd — integer
- ins_cnt — integer
- invld_cnt — integer
- msg_cntn — text
- norm_cnt — integer
- req_url_addr — text
- sav_cnt — integer
- trig_typ_cd — character
- upd_cnt — integer
- createdat — timestamp
cm_crwl_src_mst
- id — text — 기본 키 — NOT NULL
- compliancecheck — text
- contentselector — text
- isactive — boolean — NOT NULL
- lastcrawledat — timestamp
- linkselector — text
- listselector — text
- name — text — NOT NULL
- titleselector — text
- type — text — NOT NULL
- url — text — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
- source_code — character
- source_name — character
- source_group — character
- source_kind — character
- source_scope — character
- default_common_domain_id — bigint — 외래 키 → cm_cmn_dom_mst.id
- default_job_category_id — bigint — 외래 키 → cm_job_cate_mst.job_ctgr_id
- default_job_position_id — bigint — 외래 키 → cm_job_psn_mst.job_pos_id
- base_url — text
- rss_url — text
- request_method — character
- crawl_interval_min — integer
- ordg — integer
- active_yn — boolean
- summary_enabled_yn — boolean
- classifier_enabled_yn — boolean
- local_llm_model — character
- compliance_status — character
- note — text
- base_url_addr — character
- clsf_actv_yn — boolean
- cmpl_chk_cntn — character
- cmpl_stat_cd — character
- cntn_selr_cntn — character
- crwl_cycl_mm — integer
- crwl_src_cd — character
- crwl_src_nm — character
- def_cat_id — bigint
- def_dmn_id — bigint
- def_pos_id — bigint
- last_crwl_dtm — timestamp(6)
- link_selr_cntn — character
- list_selr_cntn — character
- llm_mdl_nm — character
- req_mthd_cd — character
- rmrk_cntn — character
- rss_url_addr — character
- smry_actv_yn — boolean
- src_grp_cd — character
- src_kind_cd — character
- src_scop_nm — character
- src_typ_cd — character
- titl_selr_cntn — character
- … +6
cm_job_cate_mst
- job_ctgr_id — bigint — 기본 키 — NOT NULL
- ctgr_nm — text — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
cm_job_kwd_dtl
- job_kwrd_id — bigint — 기본 키 — NOT NULL
- job_kwrd_nm — text — NOT NULL
- job_pos_id — bigint — 외래 키 → cm_job_psn_mst.job_pos_id — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
cm_job_psn_mst
- job_pos_id — bigint — 기본 키 — NOT NULL
- job_nm — text — NOT NULL
- job_ctgr_id — bigint — 외래 키 → cm_job_cate_mst.job_ctgr_id — NOT NULL
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp
cm_mkt_sig_mst
- id — bigint — 기본 키 — NOT NULL
- signal_code — character — NOT NULL
- signal_name — character — NOT NULL
- ordg — integer — NOT NULL
- active_yn — boolean — NOT NULL
- note — text
- rgst_id — character
- rgst_ip — character
- reg_dtm — timestamp
- chgp_id — character
- chgp_ip — character
- chg_dtm — timestamp