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) — 정렬기준