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 (역사)