hana
Tables (14)
admin (관리자)
- admin_id (관리자ID) — Long — Primary key — NOT NULL
- member_id (회원ID) — Long — Foreign key → member.member_id — NOT NULL
- role (권한레벨) — VARCHAR(30)
- Field
identityNumberReset (본인확인번호 재설정)
- reset_id (재설정ID) — Long — Primary key — NOT NULL
- member_id (회원ID) — Long — Foreign key → member.member_id — NOT NULL
- Field (기존본인확인번호) — VARCHAR(200)
- Field2 (새본인확인번호) — VARCHAR(200)
- Field (본인확인방식) — VARCHAR(20)
- Field (본인확인값) — VARCHAR(100)
- Field (요청IP) — VARCHAR(45)
- Field2 (요청일시) — DATETIME
- Field3 (완료일시) — DATETIME
- Field (상태) — VARCHAR(20)
- Field (변경사유) — VARCHAR(100)
member (회원)
- member_id (회원ID) — Long — Primary key — NOT NULL
- Field2 (회원유형(학생/학부모/교직원)) — VARCHAR(20)
- Field3 (사용자ID) — VARCHAR(50) UNIQUE
- Field4 (비밀번호해시) — VARCHAR(255)
memberAuthInfo (회원인증정보)
- auth_id (인증ID) — Long — Primary key — NOT NULL
- member_id (회원ID) — Long — Foreign key → member.member_id — NOT NULL
- Field2 (인증수단)
- Field3 (식별자)
- Field4 (비밀값해시)
- Field5 (비밀번호변경일시)
- Field6 (상태)
- Field7 (생성일시)
- Field8 (수정일시)
- Field
memberTypeChange (회원유형 변경)
- change_id (변경ID) — Long — Primary key — NOT NULL
- member_id (회원ID) — Long — Foreign key → member.member_id — NOT NULL
- old_type (이전유형) — VARCHAR(20)
- new_type (변경유형) — VARCHAR(20)
- reason (변경사유(전학,졸업,퇴사,권한 변경)) — VARCHAR(255)
- changed_at (변경일시) — DATETIME
- changed_by (변경자ID) — BIGINT
- note (비고) — VARCHAR(255)
parent (학부모)
- parent_id (학부모ID) — Long — Primary key — NOT NULL
- member_id (회원ID) — Long — Foreign key → member.member_id — NOT NULL
- name (이름) — VARCHAR(50)
- gender (성별) — CHAR(1)
- birth_date (생년월일) — DATE
- phone (휴대폰번호) — VARCHAR(20)
- email (이메일) — VARCHAR(100)
- guardian_type (보호자유형) — VARCHAR(20)
- occupation (직업) — VARCHAR(100)
- workplace (근무지) — VARCHAR(100)
- emergency_contact (비상연락처) — VARCHAR(20)
parentStudentRelation (학부모자녀관계)
- relation_id (관계ID) — Long — Primary key — NOT NULL
- student_id (학생ID) — Long — Foreign key → student.student_id — NOT NULL
- parent_id (학부모ID) — Long — Foreign key → parent.parent_id — NOT NULL
- member_id (회원ID) — Long — Foreign key → student.member_id — NOT NULL
- member_id (회원ID2) — Long — Foreign key → parent.member_id — NOT NULL
- relation_type (관계) — VARCHAR(20)
- note (비고)
passwordReset (비밀번호 재설정)
- reset_id (재설정ID) — Long — Primary key — NOT NULL
- member_id (회원ID) — Long — Foreign key → member.member_id — NOT NULL
- Field (요청아이디) — VARCHAR(50)
- Field2 (기존비밀번호) — VARCHAR(255)
- Field3 (새비밀번호) — VARCHAR(255)
- Field4 (본인인증방식) — VARCHAR(20)
- Field (본인확인값) — VARCHAR(100)
- Field (요청IP) — VARCHAR(45)
- Field2 (요청일시) — DATETIME
- Field3 (완료일시) — DATETIME
- Field (상태) — VARCHAR(20)
- Field2 (실패사유) — VARCHAR(100)
personalInfoAccess (개인정보 조회 확인)
- access_log_id (로그ID) — Long — Primary key — NOT NULL
- member_id (회원ID) — Long — Foreign key → member.member_id — NOT NULL
- accessor_id (조회자ID) — fk
- accessor_ip (조회자IP) — VARCHAR(45)
- access_type (조회구분(단건조회/명부조회/다운로드)) — VARCHAR(20)
- reason (조회사유) — VARCHAR(255)
- consent_flag (동의여부) — BOOLEAN
- consented_at (동의일시) — DATETIME
- accessed_at (조회일시) — DATETIME
- result (결과) — VARCHAR(20)
- note (비고) — VARCHAR(255)
staff (교직원)
- staff_id (교직원ID) — Long — Primary key — NOT NULL
- member_id (회원ID) — Long — Foreign key → member.member_id — NOT NULL
- name (이름) — VARCHAR(50)
- name_eng (영문이름) — VARCHAR(50)
- gender (성별(M/F)) — CHAR(1)
- birth_date (생년월일) — DATE
- national_id (주민등록번호(암호화필요)) — CHAR(14)
- phone (휴대폰번호) — VARCHAR(20)
- email (이메일) — VARCHAR(100)
- photo_path (사진) — VARCHAR(255)
- position_type (직위(교사/직원/1인2기강사)) — VARCHAR(30)
- job_title (직책) — VARCHAR(50)
- emergency_contact (비상연락처) — VARCHAR(20)
- major (전공) — VARCHAR(100)
- degree (최종학위(학사/석사/박사)) — VARCHAR(20)
- career_years (경력연수) — INT
- employment_type (근무형태(정규직,계약직,시간강사)) — VARCHAR(20)
- employment_status (근무상태(재직/휴직/퇴직)) — VARCHAR(20)
- hire_date (입사일) — DATE
- retire_date (퇴사일) — DATE
- bank_account (급여지급계좌) — VARCHAR(50)
- bank_name (은행명) — VARCHAR(50)
- note (비고) — VARCHAR(255)
staffAddress (교직원 주소)
- address_id (주소ID) — Long — Primary key — NOT NULL
- staff_id (교직원ID) — Long — Foreign key → staff.staff_id — NOT NULL
- country (국가) — VARCHAR(50)
- postal_code (우편번호) — VARCHAR(20)
- region (도/광역시) — VARCHAR(50)
- city (시/군/구) — VARCHAR(50)
- street (도로명주소) — VARCHAR(120)
- detail (상세주소) — VARCHAR(120)
student (학생)
- student_id (학생ID) — Long — Primary key — NOT NULL
- member_id (회원ID) — Long — Foreign key → member.member_id — NOT NULL
- name (이름) — VARCHAR(50)
- name_eng (영문이름) — VARCHAR(50)
- gender (성별(M/F)) — CHAR(1)
- birth_date (생년월일) — DATE
- national_id (주민등록번호(암호화필요)) — CHAR(14)
- admission_date (입학날짜) — DATE
- graduation_date (졸업날짜) — DATE
- grade (학년) — INT
- class (반) — INT
- class_no (번호) — INT
- student_number (학번) — VARCHAR(20)
- neis_number (NEIS 학번) — VARCHAR(20)
- phone (휴대폰번호) — VARCHAR(20)
- email (이메일) — VARCHAR(100)
- photo_path (사진) — VARCHAR(255)
- enrollment_status (재학여부) — VARCHAR(10)
- reason (사유(퇴학/휴학/전학 등 사유)) — VARCHAR(255)
- parent1_id (학부모1ID) — fk
- parent2_id (학부모2ID) — fk
studentParentAddress (학생학부모 주소)
- address_id (주소ID) — Long — Primary key — NOT NULL
- student_id (학생ID) — Long — Foreign key → student.student_id — NOT NULL
- parent_id (학부모ID) — Long — Foreign key → parent.parent_id — NOT NULL
- entity_type (대상유형) — VARCHAR(10)
- country (국가) — VARCHAR(50)
- postal_code (우편번호) — VARCHAR(20)
- region (도/광역시) — VARCHAR(50)
- city (시/군/구) — VARCHAR(50)
- street (도로명주소) — VARCHAR(120)
- detail (상세주소) — VARCHAR(120)
studentRoster (학생명부)
- roster_id (명부ID) — Long — Primary key — NOT NULL
- student_id (학생ID) — Long — Foreign key → student.student_id — NOT NULL
- member_id (회원ID) — Long — Foreign key → student.member_id — NOT NULL
- school_year (학년도) — INT
- semester (학기) — TINYINT
- grade (학년) — INT
- class (반) — INT
- class_no (번호) — INT
- student_number (학번) — VARCHAR(20)
- neis_number (NEIS 학번) — VARCHAR(20)
- enrollment_status (재학상태(재학/휴학/전학/퇴학/졸업)) — VARCHAR(20)
- enrolled_at (최초등록일자) — DATE
- exited_at (졸업/퇴학일자) — DATE
- reason (사유(퇴학/휴학/전학 등 사유)) — VARCHAR(255)
- note (비고) — VARCHAR(255)
- updated_at (수정일시) — DATETIME