SSAFY_HW
Tables (6)
CAMPUS (Untitled)
- campus_id (캠퍼스번호) — BIGINT — Primary key — NOT NULL
- reigion (지역명) — VARCHAR
- address (캠퍼스주소) — VARCHAR
CLASS (Untitled4)
- class_number (반 번호) — INT — Primary key — NOT NULL
- campus_id (캠퍼스번호) — BIGINT — Foreign key → CAMPUS.campus_id — NOT NULL
COACH (코치)
- coach_id (코치번호) — BIGINT — Primary key — NOT NULL
- class_number (반 번호) — INT — Foreign key → CLASS.class_number — NOT NULL
- job (담당업무) — VARCHAR
CONSULTANT (컨설턴트)
- consult_id (컨설턴트 아이디) — BIGINT — Primary key — NOT NULL
- class_number (반 번호) — INT — Foreign key → CLASS.class_number — NOT NULL
- job (담당업무) — VARCHAR
SESSION (교육과정)
- session_name (과정명) — VARCHAR — Primary key — NOT NULL
STUDENT (교육생)
- student_id (학번) — BIGINT — Primary key — NOT NULL
- generation (기수) — INT
- is_out (퇴소여부) — BOOLEAN
- is_major (전공여부) — BOOLEAN
- class_number (반 번호) — INT — Foreign key → CLASS.class_number — NOT NULL