인재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