1

Tables (50)

client

  • client_id — varchar(6)
  • client_name — varchar(100)
  • client_type — varchar(100)
  • client_bizr_number — varchar(13)
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

company

  • company_id — varchar(12)
  • comp_official_name — varchar(255)
  • comp_name_en — varchar(255)
  • comp_name — varchar(255)
  • corp_number — varchar(13)
  • bizr_number — varchar(13)
  • is_listed — boolean
  • dart_code — varchar(10)
  • nice_code — varchar(10)
  • fnguide_code — varchar(7)
  • old_id — varchar(7)
  • establishment_date — date
  • emp_num — int
  • ceo_name — varchar(255)
  • address — varchar(255)
  • homepage — varchar(255)
  • phone — varchar(50)
  • close_date — date
  • fiscal_month — varchar(6)
  • meta_at — timestamp
  • meta_by — varchar(100)

company_alias

  • alias_id — varchar(20)
  • company_id — varchar(12) — Foreign key → company.company_id
  • alias_name — varchar(255)
  • is_general — boolean
  • language — varchar(10)
  • valid_from — date
  • valid_to — date
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

company_collect_point

  • company_id — varchar(12) — Foreign key → company.company_id
  • collection_date — date
  • data_table — varchar(50)
  • data_column — varchar(50)
  • data_source_id — varchar(5) — Foreign key → data_source.data_source_id
  • collected_at — timestamp
  • collection_status — varchar(20)
  • error_message — text
  • meta_at — timestamp
  • meta_by — varchar(100)

company_financial

  • company_id — varchar(12) — Foreign key → company.company_id
  • fiscal_date — date
  • fin_period_id — varchar(2) — Foreign key → financial_period.fin_period_id
  • fin_item_map_id — int — Foreign key → financial_item_map.fin_item_map_id
  • fin_value — decimal(20,2)
  • document_id — varchar(50)
  • document_link — varchar(500)
  • meta_at — timestamp
  • meta_by — varchar(100)

company_group

  • group_id — varchar(8)
  • group_update_date — date
  • group_name — varchar(100)
  • head_name — varchar(100)
  • representative_company — varchar(100)
  • company_count — int
  • asset_classification_code — varchar(100)
  • public_enterprise_code — varchar(100)
  • meta_at — timestamp
  • meta_by — varchar(100)

company_group_map

  • company_id — varchar(12) — Foreign key → company.company_id
  • group_id — varchar(6) — Foreign key → company_group.group_id
  • group_update_date — date — Foreign key → company_group.group_update_date
  • start_date — date
  • end_date — date
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

company_history

  • company_id — varchar(12) — Foreign key → company.company_id
  • change_type — varchar(50)
  • start_date — date
  • end_date — date
  • old_value — text
  • new_value — text
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

company_industry_map

  • company_id — varchar(12) — Foreign key → company.company_id
  • standard_id — varchar(5) — Foreign key → industry_standard.standard_id
  • industry_id — varchar(50) — Foreign key → industry.industry_id
  • apply_date — date
  • end_date — date
  • is_active — boolean
  • meta_at — timestamp
  • meta_by — varchar(100)

company_ownership

  • ownership_id — varchar(18)
  • owner_type — varchar(20)
  • owner_company_id — varchar(12) — Foreign key → company.company_id
  • owner_person_id — varchar(20) — Foreign key → company_person.person_id
  • owner_name — varchar(255)
  • target_company_id — varchar(12) — Foreign key → company.company_id
  • relation_type — varchar(50)
  • ownership_ratio — decimal(5,2)
  • shares_owned — bigint
  • stock_kind — varchar(50)
  • update_date — date
  • is_major_shareholder — boolean
  • meta_at — timestamp
  • meta_by — varchar(100)

company_person

  • person_id — varchar(12)
  • company_id — varchar(12) — Foreign key → company.company_id
  • base_date — date
  • full_name_kr — varchar(100)
  • gender — varchar(2)
  • birth_ym — varchar(9)
  • role — varchar(200)
  • executive_type — varchar(50)
  • full_time_status — varchar(50)
  • job_desc — text
  • career — text
  • shareholder_relation — varchar(200)
  • tenure_period — varchar(200)
  • end_date — date
  • document_id — varchar(50)
  • document_link — varchar(500)
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

company_relation

  • company_id — varchar(12) — Foreign key → company.company_id
  • related_company_id — varchar(12) — Foreign key → company.company_id
  • ownership — decimal(5,2)
  • relation_type — varchar(50)
  • relation_description — text
  • start_date — date
  • end_date — date
  • meta_at — timestamp
  • meta_by — varchar(100)

company_time_series

  • company_id — varchar(12) — Foreign key → company.company_id
  • update_date — date
  • comp_official_name — varchar(255)
  • comp_name_en — varchar(255)
  • comp_name — varchar(255)
  • corp_number — varchar(13)
  • bizr_number — varchar(13)
  • is_listed — boolean
  • dart_code — varchar(10)
  • nice_code — varchar(10)
  • fnguide_code — varchar(7)
  • old_id — varchar(7)
  • establishment_date — date
  • emp_num — int
  • ceo_name — varchar(255)
  • address — varchar(255)
  • homepage — varchar(255)
  • phone — varchar(50)
  • close_date — date
  • fiscal_month — varchar(6)
  • meta_at — timestamp
  • meta_by — varchar(100)

contract

  • client_id — varchar(6) — Foreign key → client.client_id
  • contract_id — varchar(4)
  • contract_name — varchar(100)
  • contract_type — varchar(50)
  • start_date — date
  • end_date — date
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

country

  • country_id — varchar(2)
  • country_name_kr — varchar(50)
  • country_name_en — varchar(50)
  • meta_at — timestamp
  • meta_by — varchar(100)

data_source

  • data_source_id — varchar(5)
  • source_name_kr — varchar(255)
  • source_name_en — varchar(255)
  • source_type — varchar(100)
  • source_url — varchar(500)
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

esg_coverage

  • framework_id — varchar(12) — Foreign key → esg_framework.framework_id
  • esg_period_id — varchar(8) — Foreign key → esg_period.esg_period_id
  • company_id — varchar(12) — Foreign key → company.company_id
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

esg_coverage_contract_map

  • client_id — varchar(6) — Foreign key → contract.client_id
  • contract_id — varchar(4) — Foreign key → contract.contract_id
  • framework_id — varchar(12) — Foreign key → esg_coverage.framework_id
  • esg_period_id — varchar(8) — Foreign key → esg_coverage.esg_period_id
  • company_id — varchar(12) — Foreign key → esg_coverage.company_id
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

esg_data_point

  • framework_id — varchar(12) — Foreign key → esg_framework.framework_id
  • data_point_id — varchar(10)
  • data_point_name_kr — varchar(255)
  • data_point_name_en — varchar(255)
  • data_source_id — varchar(5) — Foreign key → data_source.data_source_id
  • sub_source_id — varchar(5) — Foreign key → sub_source.sub_source_id
  • unit_kr — varchar(100)
  • unit_en — varchar(100)
  • calculation — text
  • is_on_hold — boolean
  • description_kr — text
  • description_en — text
  • meta_at — timestamp
  • meta_by — varchar(100)

esg_data_point_company

  • company_id — varchar(12) — Foreign key → company.company_id
  • framework_id — varchar(12) — Foreign key → esg_data_point.framework_id
  • data_point_id — varchar(12) — Foreign key → esg_data_point.data_point_id
  • esg_period_id — varchar(6) — Foreign key → esg_period.esg_period_id
  • data_source_id — varchar(5) — Foreign key → esg_data_point.data_source_id
  • sub_source_id — varchar(5) — Foreign key → esg_data_point.sub_source_id
  • information_date — date
  • esg_value — text
  • is_verified — boolean
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

esg_framework

  • framework_id — varchar(12)
  • framework_name — varchar(100)
  • framework_owner_type — varchar(20)
  • version — varchar(10)
  • client_id — varchar(6) — Foreign key → client.client_id
  • description — text
  • is_used — boolean
  • effective_date — date
  • meta_at — timestamp
  • meta_by — varchar(100)

esg_period

  • esg_period_id — varchar(8)
  • esg_period_date — date
  • esg_period_half — varchar(6)
  • esg_period_year — int
  • esg_period_name_kr — varchar(20)
  • esg_period_name_en — varchar(20)
  • description_kr — text
  • description_en — text
  • db_period — varchar(6)
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

esg_rank_company

  • company_id — varchar(12) — Foreign key → company_industry_map.company_id
  • standard_id — varchar(5) — Foreign key → company_industry_map.standard_id
  • industry_id — varchar(50) — Foreign key → company_industry_map.industry_id
  • industry_apply_date — date — Foreign key → company_industry_map.apply_date
  • framework_id — varchar(12) — Foreign key → esg_score.framework_id
  • score_id — varchar(6) — Foreign key → esg_score.score_id
  • esg_period_id — varchar(8) — Foreign key → esg_period.esg_period_id
  • score_value — decimal(4,1)
  • universe_rank — int
  • universe_total — int
  • universe_percentile — decimal(5,2)
  • industry_rank — int
  • industry_total — int
  • industry_percentile — decimal(5,2)
  • meta_at — timestamp
  • meta_by — varchar(100)

esg_raw_company_map

  • company_id — varchar(12) — Foreign key → company.company_id
  • raw_data_id — varchar(6) — Foreign key → esg_raw_data.raw_data_id
  • information_date — date
  • data_source_id — varchar(5) — Foreign key → data_source.data_source_id
  • sub_source_id — varchar(5) — Foreign key → sub_source.sub_source_id
  • esg_value — text
  • collected_date — date
  • is_verified_by — varchar(200)
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

esg_raw_company_map_log

  • timestamp — TIMESTAMP
  • username — VARCHAR(100)
  • action_type — VARCHAR(20)
  • company_id — VARCHAR(12)
  • raw_data_id — VARCHAR(6)
  • information_date — DATE
  • data_source_id — VARCHAR(5)
  • sub_source_id — VARCHAR(5)
  • previous_esg_value — TEXT
  • new_esg_value — TEXT
  • previous_collected_date — DATE
  • new_collected_date — DATE
  • previous_is_verified_by — VARCHAR(200)
  • new_is_verified_by — VARCHAR(200)
  • previous_notes — TEXT
  • new_notes — TEXT
  • meta_at — TIMESTAMP
  • meta_by — VARCHAR(100)

esg_raw_data

  • raw_data_id — varchar(6)
  • data_source_id — varchar(5) — Foreign key → data_source.data_source_id
  • sub_source_id — varchar(5) — Foreign key → sub_source.sub_source_id
  • raw_data_name_kr — varchar(255)
  • raw_data_name_en — varchar(255)
  • unit_kr — varchar(50)
  • unit_en — varchar(50)
  • collect_type — varchar(50)
  • description_kr — text
  • description_en — text
  • meta_at — timestamp
  • meta_by — varchar(100)

esg_score

  • framework_id — varchar(12) — Foreign key → esg_framework.framework_id
  • score_id — varchar(5)
  • score_level — varchar(20)
  • level_name_kr — varchar(20)
  • level_name_en — varchar(20)
  • parent_framework_id — varchar(12) — Foreign key → esg_score.framework_id
  • parent_score_id — varchar(5) — Foreign key → esg_score.score_id
  • score_name_kr — varchar(255)
  • score_name_en — varchar(255)
  • max_scale — decimal(4,1)
  • min_scale — decimal(4,1)
  • description — text
  • meta_at — timestamp
  • meta_by — varchar(100)

esg_score_company

  • company_id — varchar(12) — Foreign key → company.company_id
  • framework_id — varchar(12) — Foreign key → esg_score.framework_id
  • score_id — varchar(6) — Foreign key → esg_score.score_id
  • esg_period_id — varchar(6) — Foreign key → esg_period.esg_period_id
  • score_value — decimal(5,2)
  • rating — varchar(2)
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

esg_score_rule

  • framework_id — varchar(12) — Foreign key → esg_score.framework_id
  • metric_id — varchar(5) — Foreign key → esg_score.score_id
  • data_point_id — varchar(6) — Foreign key → esg_data_point.data_point_id
  • calculation_rule — varchar(50)
  • rule_type — varchar(50)
  • scoring_rule — varchar(50)
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

esg_weight

  • framework_id — varchar(12) — Foreign key → esg_score.framework_id
  • esg_period_id — varchar(6) — Foreign key → esg_period.esg_period_id
  • score_id — varchar(6) — Foreign key → esg_score.score_id
  • standard_id — varchar(5) — Foreign key → industry.standard_id
  • industry_id — varchar(50) — Foreign key → industry.industry_id
  • ind_apply_date — date — Foreign key → industry.industry_id
  • industry_weight — decimal(5,4)
  • unit — varchar(50)
  • is_applicable — boolean
  • meta_at — timestamp
  • meta_by — varchar(100)

financial_item

  • fin_item_id — varchar(6)
  • fin_report_id — varchar(2) — Foreign key → financial_report.fin_report_id
  • item_name_kr — varchar(100)
  • item_name_en — varchar(100)
  • unit_kr — varchar(100)
  • unit_en — varchar(100)
  • currency — varchar(10)
  • desc_kr — text
  • desc_en — text
  • meta_at — timestamp
  • meta_by — varchar(100)

financial_item_map

  • fin_item_map_id — int
  • fin_item_id — varchar(6) — Foreign key → financial_item.fin_item_id
  • fin_standard_id — varchar(9) — Foreign key → financial_standard.fin_standard_id
  • data_source_id — varchar(5) — Foreign key → data_source.data_source_id
  • sub_source_id — varchar(5) — Foreign key → sub_source.sub_source_id
  • ind_standard_id — varchar(5) — Foreign key → industry.standard_id
  • industry_id — varchar(50) — Foreign key → industry.industry_id
  • ind_apply_date — date — Foreign key → industry.apply_date
  • data_source_item_id — varchar(50)
  • data_source_item_name — varchar(100)
  • meta_at — timestamp
  • meta_by — varchar(100)

financial_period

  • fin_period_id — varchar(2)
  • fin_period_name_kr — varchar(50)
  • fin_period_name_en — varchar(50)
  • meta_at — timestamp
  • meta_by — varchar(100)

financial_report

  • fin_report_id — varchar(2)
  • fin_report_name_kr — varchar(100)
  • fin_report_name_en — varchar(100)
  • meta_at — timestamp
  • meta_by — varchar(100)

financial_standard

  • fin_standard_id — varchar(9)
  • fin_standard_name_kr — varchar(100)
  • fin_standard_name_en — varchar(100)
  • fin_account_type — varchar(100)
  • meta_at — timestamp
  • meta_by — varchar(100)

industry

  • industry_id — varchar(50)
  • standard_id — varchar(5) — Foreign key → industry_standard.standard_id
  • apply_date — date
  • industry_name_kr — varchar(255)
  • industry_name_en — varchar(255)
  • level — varchar(20)
  • parent_id — varchar(50) — Foreign key → industry.industry_id
  • meta_at — timestamp
  • meta_by — varchar(100)

industry_standard

  • standard_id — varchar(5)
  • standard_name_kr — varchar(100)
  • standard_name_en — varchar(100)
  • description — text
  • is_active — boolean
  • meta_at — timestamp
  • meta_by — varchar(100)

proxy_agenda

  • vote_event_id — varchar(12) — Foreign key → proxy_event.vote_event_id
  • company_id — varchar(12) — Foreign key → proxy_event.company_id
  • agenda_number — varchar(50)
  • agenda_name — varchar(600)
  • meeting_type — varchar(50)
  • resolution_date — date
  • announcement_date — date
  • meeting_date — date
  • meeting_time — time
  • location — varchar(500)
  • res_document_id — varchar(50)
  • res_document_link — varchar(500)
  • ann_document_id — varchar(50)
  • ann_document_link — varchar(500)
  • is_changed — boolean
  • meta_at — timestamp
  • meta_by — varchar(100)

proxy_agenda_coverage_map

  • vote_event_id — varchar(12) — Foreign key → proxy_agenda.vote_event_id
  • company_id — varchar(12) — Foreign key → proxy_agenda.company_id
  • agenda_number — varchar(50) — Foreign key → proxy_agenda.agenda_number
  • agenda_name — varchar(600) — Foreign key → proxy_agenda.agenda_name
  • client_id — varchar(6) — Foreign key → proxy_coverage.client_id
  • contract_id — varchar(4) — Foreign key → proxy_coverage.contract_id
  • evaluation_date — date
  • framework_id — varchar(12) — Foreign key → proxy_coverage.framework_id
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

proxy_coverage

  • client_id — varchar(6) — Foreign key → contract.client_id
  • contract_id — varchar(4) — Foreign key → contract.contract_id
  • company_id — varchar(12) — Foreign key → company.company_id
  • framework_id — varchar(12) — Foreign key → esg_framework.framework_id
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

proxy_event

  • vote_event_id — varchar(12)
  • company_id — varchar(12) — Foreign key → company.company_id
  • meeting_type — varchar(50)
  • resolution_date — date
  • announcement_date — date
  • meeting_date — date
  • meeting_time — time
  • location — varchar(500)
  • res_document_id — varchar(50)
  • res_document_link — varchar(500)
  • ann_document_id — varchar(50)
  • ann_document_link — varchar(500)
  • is_changed — boolean
  • meta_at — timestamp
  • meta_by — varchar(100)

proxy_guideline

  • framework_id — varchar(12) — Foreign key → esg_framework.framework_id
  • guideline_id — varchar(6)
  • guideline_date — date
  • guideline — text
  • subsection_code — varchar(4)
  • subsection_name — varchar(200)
  • section_code — varchar(2)
  • section_name — varchar(200)
  • related_vote_item_id — varchar(2) — Foreign key → proxy_item.vote_item_id
  • meta_at — timestamp
  • meta_by — varchar(100)

proxy_item

  • vote_item_id — varchar(2)
  • vote_item_name_kr — varchar(200)
  • vote_item_name_en — varchar(200)
  • item_type_id — varchar(2)
  • item_type_kr — varchar(50)
  • item_type_en — varchar(50)
  • description_kr — text
  • description_en — text
  • meta_at — timestamp
  • meta_by — varchar(100)

proxy_result

  • vote_event_id — varchar(12) — Foreign key → proxy_agenda.vote_event_id
  • company_id — varchar(12) — Foreign key → proxy_agenda.company_id
  • agenda_number — varchar(50) — Foreign key → proxy_agenda.agenda_number
  • agenda_name — varchar(600) — Foreign key → proxy_agenda.agenda_name
  • vote_item_id — varchar(2) — Foreign key → proxy_item.vote_item_id
  • proxy_result_id — varchar(2) — Foreign key → proxy_result_item.proxy_result_id
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

proxy_result_item

  • proxy_result_id — varchar(2)
  • result_name_kr — varchar(200)
  • result_name_en — varchar(200)
  • meta_at — timestamp
  • meta_by — varchar(100)

proxy_vote_opinion

  • opinion_id — int
  • voter_id — varchar(7) — Foreign key → proxy_voter.voter_id
  • vote_event_id — varchar(12) — Foreign key → proxy_agenda.vote_event_id
  • company_id — varchar(12) — Foreign key → proxy_agenda.company_id
  • agenda_number — varchar(50) — Foreign key → proxy_agenda.agenda_number
  • agenda_name — varchar(600) — Foreign key → proxy_agenda.agenda_name
  • vote_item_id — varchar(2) — Foreign key → proxy_item.vote_item_id
  • vote_opinion — varchar(20)
  • reason — text
  • vote_date — date
  • meta_at — timestamp
  • meta_by — varchar(100)

proxy_voter

  • voter_id — varchar(7) — Foreign key → company.company_id
  • voter_name — varchar(100)
  • voter_type — varchar(50)
  • framework_id — varchar(12) — Foreign key → esg_framework.framework_id
  • client_id — varchar(6) — Foreign key → client.client_id
  • meta_at — timestamp
  • meta_by — varchar(100)

stock_market_collect_point

  • country_id — varchar(2) — Foreign key
  • stock_market_id — varchar(4) — Foreign key
  • collection_date — date
  • data_table — varchar(50)
  • data_column — varchar(50)
  • data_source_id — varchar(5) — Foreign key → data_source.data_source_id
  • collected_at — timestamp
  • collection_status — varchar(20)
  • error_message — text
  • meta_at — timestamp
  • meta_by — varchar(100)

sub_source

  • sub_source_id — varchar(5)
  • data_source_id — varchar(5) — Foreign key → data_source.data_source_id
  • sub_source_name — varchar(255)
  • sub_source_url — varchar(500)
  • report_name_one — varchar(255)
  • report_name_two — varchar(255)
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)

unknown_group_member

  • temp_id — int
  • group_id — varchar(8) — Foreign key → company_group.group_id
  • group_update_date — date — Foreign key → company_group.group_update_date
  • comp_name — varchar(255)
  • corp_number — varchar(13)
  • bizr_number — varchar(13)
  • ceo_name — varchar(255)
  • establishment_date — date
  • start_date — date
  • end_date — date
  • notes — text
  • meta_at — timestamp
  • meta_by — varchar(100)