삼정 KPMG 1차 프로젝트 개정판
테이블 (4)
Company
- Company_id — INT — 기본 키 — NOT NULL
- Name — VARCHAR(50)
- Category — VARCHAR(50)
- Created_at — DATETIME
Company_Detail
- Com_Det_id — INT — 기본 키 — NOT NULL
- Company_id — INT — 외래 키 → Company.Company_id — NOT NULL
- Content — TEXT
- Logo_url — VARCHAR(255)
- Created_at — DATETIME
- Website — VARCHAR(255)
- Esg_score — INT
Review_Reply (Review)
- Review_Reply_id — INT — 기본 키 — NOT NULL
- Company_id — INT — 외래 키 → Company.Company_id — NOT NULL
- User_id — INT — 외래 키 → User.User_id — NOT NULL
- Content — TEXT
- Created_at — DATETIME
User
- User_id — INT — 기본 키 — NOT NULL
- Password — VARCHAR(255)
- Email — VARCHAR(255)
- Nickname — VARCHAR(255)
- Role — ENUM
- Created_at — DATETIME