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