Company_DB
Tables (6)
Company (회사)
- Stock_code (Key) — VARCHAR(6) — Primary key — NOT NULL
- name (Field2) — VARCHAR(30) — NOT NULL
- report_link (Field) — VARCHAR(255)
- E_score (Field3) — Float(4)
- S_score (Field4) — Float(4)
- G_score (Field5) — Float(4)
- sector_code (Field7) — int(3) — Foreign key → Sectors.sector_code
News (뉴스)
- id (Key2) — int — Primary key — NOT NULL
- press (Field) — VARCHAR(10)
- Writer (Field11) — VARCHAR(30)
- createdAt (Field3) — datetime
- quarter (Field2) — VARCHAR(10)
- title (Field4) — VARCHAR(30)
- contents (Field5) — mediumtext
- url (Field6) — VARCHAR(255)
- E (Field7) — VARCHAR(2)
- S (Field8) — VARCHAR(2)
- G (Field9) — VARCHAR(2)
- Tag (Field10) — VARCHAR(255)
- Stock_code (Key) — VARCHAR(6) — Foreign key → Company.Stock_code — NOT NULL
Sectors (업종)
- sector_code (Field) — int(3) — Primary key
- E_score (Field2) — Float(4)
- S_score (Field3) — Float(4)
- G_score (Field4) — Float(4)
- Sector_name (key) — VARCHAR(40)
report (Untitled2)
- year (Field2) — int(4)
- KCGS_sum (Field3) — VARCHAR(2)
- 한국ESG연구소 (Field4) — VARCHAR(2)
- 서스틴베스트 (Field5) — VARCHAR(2)
- moodys (Field6) — int(3)
- S&P (Field7) — int(3)
- 공시여부 (Field8) — bool
- MSCI (Field9) — VARCHAR(2)
- KCGS_E (Field10) — VARCHAR(2)
- KCGS_S (Field11) — VARCHAR(2)
- KCGS_G (Field12) — VARCHAR(2)
- Stock_code (Key) — VARCHAR(6) — Foreign key → Company.Stock_code — NOT NULL
stock (태블로용)
- createdAt (Field3) — datetime
- alpha (Field4) — Float(4)
- beta (Field5) — Float(4)
- x_return (Field6) — Float(4)
- m_return (Field7) — Float(4)
- SP500 (Field8) — Float(4)
- CAR0 (Field9) — Float(4)
- CAR (Field10) — Float(4)
- Stock_code (Key) — VARCHAR(6) — Foreign key → Company.Stock_code — NOT NULL
word_count (Untitled)
- quarter (Field2) — VARCHAR(7)
- token (Field3) — VARCHAR(20)
- Count (Field4) — int(3)
- sector_code (Field5) — int(3) — Foreign key → Sectors.sector_code