biz news
Tables (5)
company
- company_id — VARCHAR(36)
- company — VARCHAR(255)
- company_name — VARCHAR(255)
- company_name_en — VARCHAR(255)
- representative_name — VARCHAR(100)
- business_registration_number — VARCHAR(50)
- address — VARCHAR(255)
- phone_number — VARCHAR(50)
- fax_number — VARCHAR(50)
- homepage_url — VARCHAR(255)
- standard_industry_classification — VARCHAR(255)
- main_business — VARCHAR(255)
- establishment_date — DATE
- kosdaq_listed_date — DATE
- employee_count — INT
- ticker — VARCHAR(20)
company_keyword
- keyword_id — VARCHAR(36)
- company_id — VARCHAR(36)
keyword
- keyword_id — VARCHAR(36)
- keyword — VARCHAR(255)
news
- news_id — VARCHAR(36)
- url — VARCHAR(255)
- title — VARCHAR(255)
- sub_title — TEXT
- article_text — TEXT
- date — DATETIME
news_keyword
- keyword_id — VARCHAR(36)
- news_id — VARCHAR(36)