ㄴ

Tables (22)

Award

  • award_no — NUMBER — Primary key — NOT NULL — 수상
  • award_name — VARCHAR(50) — 수상/공모전
  • organizer — VARCHAR(50) — 주최
  • award_date — DATE — 수상
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL — 이력서

Business

  • business_no — NUMBER — Primary key — NOT NULL — 기업
  • user_no — NUMBER — Foreign key → Member.user_no — NOT NULL — 회원
  • registration_number — VARCHAR(12) — NOT NULL — xxx-xx-xxxxx
  • owner_name — VARCHAR(255)
  • company_name — VARCHAR(255)
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field5 — VARCHAR(255)
  • Field4 — VARCHAR(255)
  • Field3 — VARCHAR(255)

Business_bookmark

  • business_no — NUMBER — Foreign key → Business.business_no — NOT NULL — 기업
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL — 이력서
  • floer — VARCHAR(15) — 분류
  • add_date — TIMESTAMP

Experience

  • experience_no — NUMBER — Primary key — NOT NULL — 경험/활동/교육
  • activity_type — VARCHAR(50) — 활동
  • organization_name — VARCHAR(100) — 기관/장소명
  • start_date — DATE — 시작
  • end_date — DATE — 종료
  • description — VARCHAR(300) — 활동
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL — 이력서

Job_posting

  • recruitment_no — NUMBER — Primary key — NOT NULL — 공고
  • business_no — NUMBER — Foreign key → Business.business_no — NOT NULL — 기업
  • title — VARCHAR(50) — NOT NULL
  • representative_name — VARCHAR(15) — NOT NULL
  • representative_dept — VARCHAR(30) — NOT NULL
  • representative_eamil — VARCHAR(50) — NOT NULL
  • method — CHAR(1) — NOT NULL — 워크드림
  • start_date — TIMESTAMP — NOT NULL
  • deadline — TIMESTAMP — NOT NULL
  • posting_date — DATE — NOT NULL
  • content_img — VARCHAR(100) — 이미지
  • content_text — VARCHAR(3000)

Job_requirements

  • position_no — NUMBER — Primary key — NOT NULL — 포지션
  • recruitment_no — NUMBER — Foreign key → Job_posting.recruitment_no — NOT NULL — 공고
  • position_name — VARCHAR(50) — NOT NULL
  • employment_form — CHAR(1) — NOT NULL — 정규직:
  • recruited_people — NUMBER — NOT NULL
  • working_day — NUMBER — NOT NULL — 0:
  • working_time_start — TIMESTAMP — HH24:MI
  • working_time_end — TIMESTAMP
  • working_place — VARCHAR(50) — NOT NULL
  • min_salary — NUMBER — NOT NULL
  • max_salary — NUMBER — NOT NULL
  • academic_ability — CHAR(2) — NOT NULL — 학력
  • min_career — NUMBER — NOT NULL — 연
  • max_career — NUMBER — NOT NULL — 연

Member

  • user_no — NUMBER — Primary key — NOT NULL — 회원
  • user_type — CHAR(1) — NOT NULL — 기업:
  • user_id — VARCHAR(20) — NOT NULL — 영어
  • user_pwd — VARCHAR(16) — NOT NULL — 영문
  • email — VARCHAR(30) — NOT NULL
  • eroll_date — DATE — NOT NULL
  • modify_date — TIMESTAMP — NOT NULL — 마지막
  • status — CHAR(1) — NOT NULL — 가입:

Person

  • person_no — NUMBER — Primary key — NOT NULL — 개인
  • user_no — NUMBER — Foreign key → Member.user_no — NOT NULL — 회원
  • name — VARCHAR(15) — NOT NULL
  • birthday — DATE
  • gender — VARCHAR(3) — 남
  • phone — VARCHAR(13) — 개인
  • address — VARCHAR(100)
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL — 이력서

Person_bookmark

  • person_no — NUMBER — Foreign key → Person.person_no — NOT NULL — 개인
  • recruitment_no — NUMBER — Foreign key → Job_posting.recruitment_no — NOT NULL — 공고
  • folder — VARCHAR(15) — 분류
  • add_date — TIMESTAMP — NOT NULL

Portfolio

  • portfolio_no — NUMBER — Primary key — NOT NULL — 포트폴리오
  • title — VARCHAR(100) — NOT NULL — 포트폴리오
  • type — ENUM('파일', 'URL') — NOT NULL — 포트폴리오
  • file_url — VARCHAR(200) — 파일
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL — 이력서

Resume

  • resume_no — NUMBER — Primary key — NOT NULL — 이력서
  • title — VARCHAR2(50) — NOT NULL — 이력서
  • create_date — DATE — NOT NULL — 작성일자
  • modified_date — DATE — NOT NULL — 수정일자
  • deleted — BOOLEAN — NOT NULL — 삭제여부

career

  • work_ex_no — NUMBER — Primary key — NOT NULL — 경력
  • company_title — VARCHAR2(50) — NOT NULL — 회사명
  • position — VARCHAR2(20) — NOT NULL — 직책
  • department — VARCHAR2(20) — NOT NULL — 부서
  • start_date — DATE — NOT NULL — 근무시작일
  • end_date — DATE — 근무종료일
  • status — BOOLEAN — NOT NULL — 근무여부
  • job_content — VARCHAR2(100) — NOT NULL — 주요
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL — 이력서

collage

  • education_no — NUMBER — Primary key — NOT NULL — 학력
  • classification — VARCHAR2(10) — NOT NULL — 대학
  • school_name — VARCHAR2(30) — NOT NULL — 학교명
  • degree — VARCHAR2(10) — NOT NULL — 학위
  • major — VARCHAR2(30) — NOT NULL — 전공
  • start_date — DATE — NOT NULL — 입학일자
  • end_date — DATE — 졸업일자
  • status — VARCHAR2(10) — NOT NULL — 졸업상태
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL — 이력서

employment_preferences

  • employment_preferences_no — NUMBER — Primary key — NOT NULL — 취업우대사항
  • is_marriage_target — BOOLEAN — NOT NULL — 보훈
  • marriage_reason — VARCHAR(200) — 보훈
  • is_military_target — BOOLEAN — NOT NULL — 병역
  • military_target_type — VARCHAR(50) — 병역
  • is_employment_support_target — BOOLEAN — NOT NULL — 고용
  • employment_support_types — VARCHAR(200) — 고용
  • agreed_privacy_collection — VARCHAR(255) — NOT NULL — 민감정보
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL — 이력서

high

  • education_no — NUMBER — Primary key — NOT NULL
  • school_name — VARCHAR2(30) — NOT NULL
  • major_field — VARCHAR2(10) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • status — VARCHAR2(10) — NOT NULL
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL

language

  • language_no — NUMBER — Primary key — NOT NULL — 어학
  • language_name — VARCHAR(30) — 언어
  • proficiency_level — VARCHAR(30) — 숙련도
  • acquisition_date — DATE — 취득일
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL — 이력서

license

  • license_no — NUMBER — Primary key — NOT NULL — 자격증
  • license_name — VARCHAR(30) — 자격증이름
  • issued_by — VARCHAR(30) — 발급
  • issue_date — DATE — 발급
  • passing_category — VARCHAR(30) — 합격구분
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL — 이력서

posting

  • posting_no — NUMBER — Primary key — NOT NULL — 게시글
  • posting_title — VARCHAR2(100) — NOT NULL — 게시글
  • posting_content — VARCHAR2(5000CHAR) — NOT NULL — 게시글
  • category — VARCHAR2(10) — NOT NULL — 카테고리
  • image — BLOB — 이미지
  • hashtag — VARCHAR2(50) — 해시태그
  • user_no — NUMBER — Foreign key → Member.user_no — NOT NULL — 회원
  • view_count — NUMBER — NOT NULL — 게시글조회수

qualification

  • education_no — NUMBER — Primary key — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • pass_date — DATE — NOT NULL
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL

school

  • education_no — NUMBER — Primary key — NOT NULL — 학력
  • school_name — VARCHAR2(30) — NOT NULL — 학교명
  • start_date — DATE — NOT NULL — 입학일자
  • end_date — DATE — 졸업일자
  • status — VARCHAR2(10) — NOT NULL — 졸업상태
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL — 이력서

self-introduction

  • Primary — Key" — Primary key — NOT NULL — IS
  • Foreign — Key" — NOT NULL — IS
  • Field2 — VARCHAR(100) — NOT NULL — 자기소개서
  • Field3 — VARCHAR2(500 CHAR) — NOT NULL — 자기소개서
  • Field4 — DATE — NOT NULL — 작성
  • Field5 — DATE — 수정
  • Field6 — BOOLEAN — 삭제
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL — 이력서

skill

  • skill_no — NUMBER — Primary key — NOT NULL — 스킬
  • skill — VARCHAR2(1000) — NOT NULL — 스킬
  • resume_no — NUMBER — Foreign key → Resume.resume_no — NOT NULL — 이력서