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