sseuksseo
Tables (20)
Veteran (보훈)
- veteran_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → members.member_id — NOT NULL
- service_num (Field) — NOT NULL — 보훈번호
- relation (Field2) — varchar — NOT NULL — 관계
- rate (Field3) — enum — NOT NULL — 보훈비율
academic_thesis (Untitled2)
- academic_thesis_id (Key) — Primary key — NOT NULL
- member_id (Key3) — Foreign key → members.member_id — NOT NULL
- thesis_detail_id (Key2) — Foreign key → thesis_detail.thesis_detail_id — NOT NULL
- type (Field) — enum — NOT NULL
- contest_name (Field2) — varchar — 대회명
- host_name (Field3) — 주최기관
- sort (Field4) — 정렬기준
award (Untitled10)
- award_id (Key) — Primary key — NOT NULL
- award_name (Field) — 상훈명
- issuance (Field2) — 수여기관
- date (Field3) — 수상일자
- award_content (Field4) — 수상내역
- member_id (Key2) — Foreign key → members.member_id — NOT NULL
certificate (Untitled9)
- certificate_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → members.member_id — NOT NULL
- issuance (Field) — 발급기관
- ragister_num (Field2) — 등급번호
- date (Field3)
- sort (Field4)
disability (Untitled3)
- disorder_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → members.member_id — NOT NULL
- DISABILITY_LEVEL (Field) — enum — NOT NULL — 장애정도
- DISABILITY_TYPE (Field2) — enum — NOT NULL — 장애 내용
education (Untitled11)
- education_id (Key) — Primary key — NOT NULL
- education_name (Field)
- Field2
education (학력)
- education_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → members.member_id — NOT NULL
- education_level (Field) — 학력 구분
- start_date (Field2) — date — 입학 날짜
- admission_type (Field3) — 입학구분
- end_date (Field4) — 졸업일자
- graduation_type (Field5) — 졸업 구분
- school_name (Field6) — 학교이름
- shcool_branch (Field10) — 본교/분교 구분
- school_location (Field7) — 소재지
- class_time_type (Field8) — 주/야간
foreign_language (Untitled8)
- foreign_language_id (Key) — Primary key — NOT NULL
- name (Field) — NOT NULL
foreign_language_register (Untitled7)
- foreign_language_register_id (Key) — Primary key — NOT NULL
- member_id (Key3) — Foreign key → members.member_id — NOT NULL
- foreign_language_id (Key2) — Foreign key → foreign_language.foreign_language_id — NOT NULL
- name (Field) — NOT NULL
- regist_num (Field2) — NOT NULL
- date (Field3) — NOT NULL
- value (Field4)
- value_standard (Field5)
- rating (Field6) — 등급
graduation _thesis (논문)
- graduation_thesis_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → members.member_id — NOT NULL
- education_type (associate,) — enum — NOT NULL
- title (Field)
- summary (Field2) — 내용요약
major (전공)
- major_id (Key) — Primary key — NOT NULL
- major_series_key (Key2) — Foreign key → major_series.major_series_key — NOT NULL
- major_name (Field)
major_series (학과 및 고등학교 계열)
- major_series_key (Key) — Primary key — NOT NULL
- major_name (Field)
members (Untitled)
- member_id (Key) — Primary key — NOT NULL
- korean_name (Field) — varchar — 한글이름
- hanja_name (Field2) — varchar — 한자이름
- english_name (Field3) — varchar — 영어이름
- gender (Field4) — enum — NOT NULL — 성별
- profile (Field5) — varchar — 프로필 이미지
- contry (Field6) — enum — 국적
- address (Field7) — varchar — 주소
- address_detail (Field8) — varchar — 상세주소
- address_num (Field9) — 우편주소
- email (Field10) — varchar
- phone_num (Field11)
- birthday (Field13) — date — 생년월일
- employment availability_date (Field12) — date — 입사가능일자
military (병역)
- military_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → members.member_id — NOT NULL
- military_service_type (Field) — enum — NOT NULL — 군별
- military_rank (Field2) — enum — NOT NULL — 계급
- military_branch (Field3) — enum — NOT NULL — 병과
- discharge_type (Field4) — enum — NOT NULL — 제대구분
- start_date (Field5) — date — NOT NULL — 시작일
- end_date (Field6) — date — NOT NULL — 종료일
my_major (전공 수강)
- my_major_id (Key) — Primary key — NOT NULL
- major_id (Key2) — Foreign key → major.major_id — NOT NULL
- education_id (Key3) — Foreign key → education.education_id — NOT NULL
- major_kind (Field) — enum — NOT NULL
- score (Field2) — double — 점수
- standard (Field3) — enum — 만점기준
- credits_earned (Field4) — 이수학점
- major_score (Field5) — 전공학점
- major_stadard (Field6) — 전공 만점 기준
project (Untitled6)
- project_id (Key) — Primary key — NOT NULL
- work_experience_id (Key2) — Foreign key → work_experience.work_experience_id — NOT NULL
- project_name (Field) — NOT NULL
- order (Field2) — NOT NULL — 발주처
- working_place (Field3) — 근무처
- start_date (Field4)
- end_date (Field5)
- contribution (Field6) — doble — 기여도
- role (Field7) — 참여역할
- sort (Field8) — 정렬
research_thesis (연구논문)
- research_thesis_id (Key) — Primary key — NOT NULL
- thesis_detail_id (Key2) — Foreign key → thesis_detail.thesis_detail_id — NOT NULL
- member_id (Key3) — Foreign key → members.member_id — NOT NULL
- publication (Field) — enum — NOT NULL — 게재 구분
- type (Field2) — NOT NULL — 논문 구분
- title (Field3) — NOT NULL — 논문제목
- publication_title (Field4) — varchar — NOT NULL — 게시지명
- sort (Field5) — 정렬기준
study_experience (Untitled5)
- study_experience_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → members.member_id — NOT NULL
- order_name (Field) — NOT NULL — 발주기관명
- role (Field2) — varchar — 역할
- start_date (Field3)
- end_date (Field4)
- sort (Field5) — 정렬기준
thesis_detail (Untitled4)
- thesis_detail_id (Key) — Primary key — NOT NULL
- title (Field) — 제목
- date (Field2) — 날짜
- ranking (Field3) — 저자순위
- member (Field4) — 참여수
- role (Field5) — enum — 역할
work_experience (경력)
- work_experience_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → members.member_id — NOT NULL
- company_name (Field) — 회사명
- start_date (Field2)
- end_date (Field3)
- is_current (Field4) — enum — 재직 상태
- employment_type (Field5) — enum — 고용형태
- department (Field6) — varchar — 부서
- position (Field7) — varchar — 직위
- leave_reason (Field8) — varchar — 퇴사 이유
- job_description (Field9) — varchar — 업무내용
- experience (Field10) — 경험 및 경력기술서
- sort (Field11) — 정렬기준