summerpjt
Tables (7)
Coach (코치)
- coach_id (코치번호) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR(20)
- tel (전화번호) — VARCHAR(20)
Consultant (컨설턴트)
- pro_id (운영프로번호) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR(20)
- tel (전화번호) — VARCHAR(20)
Region (지역)
- region_id (지역번호) — BIGINT — Primary key — NOT NULL
- region_name (지역이름) — VARCHAR(20)
- region_address (지역캠퍼스주소) — VARCHAR(20)
- region_tel (대표 전화번호) — VARCHAR(20)
class (반)
- 반번호 (class_id) — BIGINT — Primary key — NOT NULL
- pro_id (담당운영프로번호) — BIGINT — Foreign key → Consultant.pro_id — NOT NULL
- coach_id (코치번호) — BIGINT — Foreign key → Coach.coach_id — NOT NULL
- region_id (지역번호) — BIGINT — Foreign key → Region.region_id — NOT NULL
project (프로젝트)
- project_id (프로젝트ID) — BIGINT — Primary key — NOT NULL
- project_type (공통/특화/자율) — ENUM
- subject (프로젝트명) — VARCHAR(30)
project_member (프로젝트 참여 교육생)
- project_id (프로젝트ID) — BIGINT — Foreign key → project.project_id — NOT NULL
- student_id (교육생번호) — BIGINT — Foreign key → student.student_id — NOT NULL
- 반번호 (class_id) — BIGINT — Foreign key → student.반번호 — NOT NULL
student (교육생)
- student_id (교육생번호) — BIGINT — Primary key — NOT NULL
- 반번호 (class_id) — BIGINT — Foreign key → class.반번호 — NOT NULL
- is_out (퇴소여부) — BOOLEAN
- is_major (전공여부) — BOOLEAN