삼정 KPMG 1차 프로젝트 초안

테이블 (8)

Answer (답변)

  • Inquiry_id (Key) — INT — 외래 키 → Inquiry.Inquiry_id — NOT NULL
  • User_id (Key2) — ID — 외래 키 → User.User_id — NOT NULL
  • Created_at (Field3) — DATETIME
  • Content (Field) — TEXT

BBS (자유게시판)

  • BBS_id (Field5) — INT — 기본 키
  • User_id (Field) — INT — 외래 키 → User.User_id — NOT NULL
  • Title (Field2) — VARCHAR(255)
  • Content (Field3) — TEXT
  • Created_at (Field4) — DATETIME

BBS_Reply (댓글)

  • BBS_Reply_id (Field5) — VARCHAR(50) — 기본 키 — NOT NULL
  • BBS_id (Field52) — INT — 외래 키 → BBS.BBS_id
  • User_id (Key2) — INT — 외래 키 → User.User_id — NOT NULL
  • Created_at (Field3) — DATETIME
  • Content (Field) — TEXT

Company (기업)

  • Company_id (Key) — INT — 기본 키 — NOT NULL
  • Name (Key2) — VARCHAR(50)
  • Category (Key5) — VARCHAR(50)
  • Created_at (Key8) — DATETIME

Company_Detail (활동)

  • Com_Det_id (Key) — INT — 기본 키 — NOT NULL
  • Company_id (Key2) — INT — 외래 키 → Company.Company_id — NOT NULL
  • Content (Key5) — TEXT
  • Logo_url (Key7) — VARCHAR(255)
  • Created_at (Key8) — DATETIME
  • Website (Field) — VARCHAR(255)
  • Esg_score (Field2) — INT

Inquiry (질문게시판)

  • Inquiry_id (Key) — INT — 기본 키 — NOT NULL
  • User_id (Field) — INT — 외래 키 → User.User_id — NOT NULL
  • Title (Field2) — VARCHAR(255)
  • Content (Field3) — TEXT
  • Created_at (Field4) — DATETIME

Review_Reply (리뷰)

  • Review_Reply_id (Key) — INT — 기본 키 — NOT NULL
  • Company_id (Key3) — INT — 외래 키 → Company.Company_id — NOT NULL
  • User_id (Key2) — INT — 외래 키 → User.User_id — NOT NULL
  • Content (Key6) — TEXT
  • Created_at (Key8) — DATETIME

User (사용자)

  • User_id (Key) — INT — 기본 키 — NOT NULL
  • Password (Key2) — VARCHAR(255)
  • Email (Key3) — VARCHAR(255)
  • Nickname (Key4) — VARCHAR(255)
  • Role (Key5) — ENUM
  • Created_at (Key6) — DATETIME