평행세계SSAFY
테이블 (4)
Consultants (consultants)
- Consultant Id (consultant_id) — Int(11) — 기본 키 — NOT NULL
- Class Key (class_key) — Int(11) — 외래 키 → classes.Class Key — NOT NULL
- First Name (first_name) — VARCHAR(255)
- Last Name (last_name) — VARCHAR(255)
- Gender (gender) — VARCHAR(11)
- Class (class) — INT(11)
Responsibilities (responsibilities)
- Responsibility Id (responsibility_id) — Int(11) — 기본 키 — NOT NULL
- Consultant Id (consultant_id) — Int(11) — 외래 키 → Consultants.Consultant Id — NOT NULL
- Class Key (class_key) — Int(11) — 외래 키 → Consultants.Class Key — NOT NULL
- Responsibility Name (responsibility_name) — VARCHAR(255)
Students (students)
- Student Id (student_id) — INT(11) — 기본 키 — NOT NULL
- Class Key (class_key) — Int(11) — 외래 키 → classes.Class Key — NOT NULL
- First Name (first_name) — VARCHAR(255)
- Last Name (last_name) — VARCHAR(255)
- Year (year) — INT(11)
- SW Major (sw_majored) — BOOLEAN
- Graduated (is_graduated) — BOOLEAN
- Gender (gender) — VARCHAR(11)
- Region (region) — VARCHAR(11)
classes
- Class Key (class_key) — Int(11) — 기본 키 — NOT NULL
- Class (class) — INT(11)