entry-v0

Tables (14)

academic_records (학교 성적)

  • academic_records_id (Key) — Primary key — NOT NULL
  • volunteer_time (봉사 시수) — int
  • applicant_id (지원자 id) — Foreign key → applicants.applicant_id — NOT NULL
  • is_dsm_algorithm_awarded (dsm 알고리즘 입상) — boolean
  • is_programming_certified (프로그래밍 기능사)

admins (관리자)

  • id (관리자 id) — UUID — Primary key — NOT NULL
  • username (로그인용 아이디)
  • password (비밀번호)
  • status (ACTIVE, DELETE, SUSPEND)

applicant_forms (지원서)

  • applicant_id (지원자 id) — Foreign key → applicants.applicant_id — NOT NULL
  • admission_type (REGULAR, MEISTER, SOCIAL)
  • graduation_type (학력(PROSPECTIVE, GRADUATED, GED))
  • region (지역(DAEJEON, NATIONAL))
  • introduction (자기소개서) — text
  • study_plan (학업계획서) — text
  • graduation_date (졸업 날짜) — date
  • special_note (사회통합 유형(VETERAN(국가유공자), SPECAIL_ADMISSION(특례입학 대상)))

applicants (지원자 인적사항)

  • applicant_id (지원자 id) — Primary key — NOT NULL
  • name (이름)
  • birthdate (생년월일) — varchar(8)
  • score (성적) — int
  • gender (성별(MALE, FEMALE))
  • address_detail (상세 주소)
  • address_base (도로명 주소)
  • zip_code (우편번호)
  • student_id (학생 id) — UUID — Foreign key → students.id — NOT NULL
  • status (지원 상태)
  • document_pass_result (서류 통과 여부)
  • final_pass_result (최종 합격 여부)

attendances (탈주 횟수)

  • academic_records_id (Key) — Foreign key → academic_records.academic_records_id — NOT NULL
  • grade (학년) — int
  • absent_count (미인정 결석) — int
  • late_arrival (지각) — int
  • early_leave (조퇴) — int
  • class_skip (결과) — int

files (파일)

  • id (Key) — uuid — Primary key — NOT NULL
  • path (파일 저장 경로) — varchar
  • name (파일명) — varchar
  • reference_id (공지사항 id) — int — Foreign key → notices.id — NOT NULL
  • reference_id (지원자 id) — Foreign key → applicants.applicant_id — NOT NULL
  • reference_type (참조 타입)

guardian (보호자)

  • id (보호자 아이디) — UUID — Primary key — NOT NULL
  • applicant_id (지원자 id) — Foreign key → applicants.applicant_id — NOT NULL
  • name (보호자 성명) — varchar
  • phone_number (보호자 연락처) — varchar
  • relation (자녀와의 관계(FATHER, MOTHER, OTHER)) — varchar(8)
  • gender (FEMALE, MALE)

notices (공지사항)

  • id — int — Primary key — NOT NULL
  • title (제목)
  • content (내용)
  • category (카테고리) — varchar
  • view_count (조회 수) — int
  • created_at (생성일)

qnas (QnA)

  • id (Key) — int — Primary key — NOT NULL
  • question (질문)
  • answer (답변)
  • no (번호) — int
  • category (카테고리)

schedules (일정)

  • id — int — Primary key — NOT NULL
  • title (일정 이름) — varchar
  • start_at (시작일) — timestamp
  • end_at (종료일) — timestamp

school_infos (학업 정보)

  • applicant_id (지원자 id) — Foreign key → applicants.applicant_id — NOT NULL
  • school_name (학교 이름) — varchar(8)
  • student_number (학번) — varchar(8)
  • school_phone (학교 연락처) — varchar(16)
  • teacher_name (교사 성명) — varchar(8)

students (학생 계정)

  • id (학생 id) — UUID — Primary key — NOT NULL
  • phone_number (폰번호) — varchar
  • password (비밀번호) — varchar
  • status (ACTIVE, DELETE, SUSPEND) — varchar(8)

subject_grades (과목별 등급)

  • grade (학년) — Primary key — NOT NULL
  • semester (학기) — Primary key — NOT NULL
  • academic_records_id (Key) — Foreign key → academic_records.academic_records_id — NOT NULL
  • korean (국어) — varchar(2)
  • math (수학)
  • english (영어)
  • science (과학)
  • society (사회)
  • technology (기술가정)
  • history (역사)

subject_scores (과목별 성적 (검정고시))

  • academic_records_id (Key) — Foreign key → academic_records.academic_records_id — NOT NULL
  • korean (국어) — int
  • math (수학)
  • english (영어)
  • science (과학)
  • society (사회)
  • technology (기술가정)
  • history (역사)