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)