final2
Tables (8)
News (뉴스)
- idx — INT — Primary key — NOT NULL
- Date (뉴스 날짜) — DATE
- Media (뉴스 매체) — VARCHAR(150)
- Contributor (작성자) — VARCHAR(100)
- Title (뉴스제목) — VARCHAR(250)
- Keywords (주요키워드) — TEXT
- Feature_Extraction_Top50 (추출된 주요 특징) — VARCHAR(500)
- Context (본문) — LONGTEXT
- URL (주소) — VARCHAR(255)
bs (재무상태표)
- idx — INT — Primary key — NOT NULL
- corp_code (기업코드) — VARCHAR(8) — Foreign key → company_list.corp_code — NOT NULL
- date (연도) — VARCHAR(8)
- concept_id (계정ID) — VARCHAR(150)
- label_ko (계정명(KO)) — VARCHAR(150)
- label_en (계정명(EN)) — VARCHAR(200)
- class1 (계정명1) — VARCHAR(150)
- class2 (계정명2) — VARCHAR(150)
- class3 (계정명3) — VARCHAR(150)
- class (계정명(1~3)) — VARCHAR(150)
- consolidated (연결재무제표) — DOUBLE
- seperate (별도재무제표) — DOUBLE
cf (현금흐름표)
- idx — INT — Primary key — NOT NULL
- corp_code (기업코드) — VARCHAR(8) — Foreign key → company_list.corp_code — NOT NULL
- concept_id (계정ID) — VARCHAR(100)
- label_ko (계정명(KO)) — VARCHAR(150)
- label_en (계정명(EN)) — VARCHAR(200)
- class1 (계정명1) — VARCHAR(150)
- class2 (계정명2) — VARCHAR(150)
- consolidated (연결재무제표) — DOUBLE
- seperate (별도재무제표) — DOUBLE
- data (연도) — VARCHAR(8)
cis (포괄손익계산서)
- idx — INT — Primary key — NOT NULL
- corp_code (기업코드) — INT — Foreign key → company_list.corp_code — NOT NULL
- date (연도) — VARBINARY(8)
- concept_id (계정ID) — VARCHAR(150)
- label_ko (계정명(KO)) — VARCHAR(150)
- label_en (계정명(EN)) — VARCHAR(200)
- class1 (계정명1) — VARCHAR(150)
- class2 (계정명2) — VARCHAR(150)
- class3 (계정명3) — VARCHAR(150)
- class (계정명(1~3)) — VARCHAR(150)
- consolidated (연결재무제표) — DOUBLE
- seperate (별도재무제표) — DOUBLE
company_executive (임원 현황)
- idx — INT — Primary key — NOT NULL
- corp_code (기업코드) — VARCHAR(8) — Foreign key → company_list.corp_code — NOT NULL
- report_no (접수번호) — VARCHAR(14)
- corp_name (법인명) — VARCHAR(60)
- name (성명) — VARCHAR(30)
- gender (성별) — VARCHAR(3)
- birth (출생년월) — VARCHAR(12)
- position (직위) — VARCHAR(50)
- job_role (담당업무) — VARCHAR(50)
- tenure (재직기간) — VARCHAR(50)
- age (나이) — INT
- age_group ((시각화)) — INT
company_list
- corp_code (기업코드) — VARCHAR(8) — Primary key — NOT NULL
- corp_name — VARCHAR(50)
- stock_name — VARCHAR(100)
- stock_code — VARCHAR(6)
- ceo_nm — VARCHAR(50)
- corp_cls — VARCHAR(10)
- jurir_no — VARCHAR(50)
- bizr_no — VARCHAR(50)
- adres — VARCHAR(255)
- hm_url — VARCHAR(255)
- ir_url — VARCHAR(255)
- phn_no — VARCHAR(50)
- fax_no — VARCHAR(100)
- induty_code — VARCHAR(10)
- est_dt — DATE
- acc_mt — VARCHAR(50)
- a — TEXT
company_worker (직원 현황)
- idx — INT — Primary key — NOT NULL
- corp_code (기업코드) — VARCHAR(8) — Foreign key → company_list.corp_code — NOT NULL
- report_no (접수번호) — VARCHAR(14)
- corp_name (법인명) — VARCHAR(60)
- department (사업부문) — VARCHAR(50)
- gender (성별) — VARCHAR(3)
- full_time_employee (정규직) — INT
- contract_worker (계약직수) — INT
- total_staff (합계) — INT
- avg_tenure (평균근속연수) — VARCHAR(50)
- avg_salary_per_employee (1인평균) — INT
finance_word (재무회계개념체계)
- idx — INT — Primary key — NOT NULL
- context (내용) — VARCHAR(2048)