SSAFY
Tables (12)
Class
- class_id — INTEGER — Primary key — NOT NULL
- region — VARCHAR(10) — NOT NULL — 서울/대전/구미/광주/부울경
- class_number — INTEGER — NOT NULL — 1~n
- batch_number — INTEGER — NOT NULL
- coach_id — INTEGER
- course_id — INTEGER — NOT NULL
- consultant_id — INTEGER — NOT NULL
Class_Trainee
- class_id — INTEGER — Primary key — NOT NULL
- trainee_id — INTEGER — Primary key — NOT NULL
- batch_number — INTEGER — NOT NULL
Coach
- coach_id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- responsibility — VARCHAR(255) — NOT NULL — 담당업무
Consultant
- consultant_id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- responsibility — VARCHAR(255) — NOT NULL — 담당업무
Course
- course_id — INTEGER — Primary key — NOT NULL
- course_type — VARCHAR(10) — NOT NULL — 공통/특화/자율
OperationProgram
- id — INT
- name — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(15) — NOT NULL
- region — VARCHAR(100) — NOT NULL
- class — VARCHAR(50) — NOT NULL
- team — VARCHAR(50) — NOT NULL
Project
- id — INT
- type — ENUM('Common', 'Specialized', 'Autonomous') — NOT NULL
- title — VARCHAR(100) — NOT NULL
ProjectStudent
- project_id — INT
- student_id — INT
Student
- id — INT
- name — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(15) — NOT NULL
- campus_region — VARCHAR(100) — NOT NULL
- operation_program_id — INT
StudentProject
- student_id — INT
- project_id — INT
TeachingMaterial
- id — INT
- title — VARCHAR(100) — NOT NULL
- purchase_date — DATE — NOT NULL
- rental_date — DATE
- renter_id — INT
- return_date — DATE
Trainee
- trainee_id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- is_major — BOOLEAN — NOT NULL — 전공자/비전공자
- is_dropped_out — BOOLEAN — NOT NULL — 퇴소/재학