삼정 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