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 — 퇴소/재학