ㄴ
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 — 이력서