khuthon2024
Tables (3)
Article (기사)
- article_id (Key) — BIGINT — Primary key — NOT NULL
- result_id (Key2) — BIGINT — Foreign key → Result.result_id — NOT NULL
- url — TEXT
ESG (esg)
- esg_id (Key) — BIGINT — Primary key — NOT NULL
- result_id (Key2) — BIGINT — Foreign key → Result.result_id — NOT NULL
- keyword (Field) — VARCHAR(45)
- context (내용) — TEXT
Result (result)
- result_id (Key) — BIGINT — Primary key — NOT NULL
- companName (회사이름) — VARCHAR(100)
- productName (제품명) — VARCHAR(100)
- Mark (Field) — BOOLEAN
- Grade (ESG등급) — VARCHAR(10)
- Environment (환경) — VARCHAR(10)
- Social (사회) — VARCHAR(10)
- Governance (지배구조) — VARCHAR(10)
- Result (결과) — VARCHAR(10)