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