Hiring

테이블 (11)

Jobs (job)

  • job_id — 기본 키 — NOT NULL
  • mem_hr_id (mem_hr_idy) — 외래 키 → User Companies(HR).mem_hr_id — NOT NULL
  • 직무 Title (job_title) — NOT NULL
  • 신입 혹은 경력(신입=0, 경력=1) (job_basic_phone)
  • 희망 나이대 시작(생년월일) (job_basic_dob_start) — NOT NULL
  • 희망 나이대 끝(생년월일) (job_basic_dob_end) — NOT NULL
  • 희망직무 (job_basic_position) — NOT NULL
  • 산업군 (job_basic_industry) — NOT NULL
  • 근무지역 (job_basic_location) — NOT NULL
  • 학교 레벨 범위 (모두;SKY;서성한;중겨외시;etc) (job_edu_range) — NOT NULL
  • 필수전공 (job_edu_major_required) — NOT NULL
  • 우대전공 (job_edu_major) — NULL
  • 지원자격(자격증명) (Field)
  • 우대사항(자격증명) (Field2)
  • 직무 Description(업무 카테고리 ex.잡코리아 경영/업무 섹션 추가 기획후 정리 예정) (Field3)

POINT (pt)

  • 포인트 고유 키 값 (pt_id) — 기본 키 — NOT NULL
  • 유저 기본 키값 (mem_id) — 외래 키 → Users.유저 기본 키값 — NOT NULL
  • 결제 txn 고유 키 값 (txn_id) — 외래 키 → Transactions.txn_id — NOT NULL
  • 포인트 (추가/차감) 여부 [ 0=추가, 1=차감 ] (pt_type)
  • (추가/차감)된 point amount (pt_point_added)
  • (추가/차감)된 point 날짜 (pt_datetime) — NOT NULL

Transactions (txn)

  • txn_id — 기본 키 — NOT NULL
  • 유저 기본 키값 (mem_id) — 외래 키 → Users.유저 기본 키값 — NOT NULL
  • 구매자 이름 (mem_name)
  • 구매자 연락처 (mem_phone)
  • 화폐 단위(임시) (txn_currency)
  • 서브토탈 금액 (txn_sub_total)
  • 쿠폰 할인 금액 (추후 도입될 수 있기에 NULL 로 미리 생성) (txn_coupon_discount) — NULL
  • txn_tax — NULL
  • 주문금액 (포인트 000원치사겠다 최초값) (txn_order_price_amount)
  • 결제금액 (실제 카드에서 빠저 나간돈) (txn_payment_amount) — NULL
  • 총 결제 금액 (최종 결제 금액) (txn_grand_total)
  • Description (txn_description) — NULL
  • 결제 수단 (txn_payment_method) — NOT NULL
  • PG 이름 (txn_pg_name) — NOT NULL
  • PG 결제 여부 (txn_pg_resultyn) — NOT NULL
  • 거래방식 (txn_type) — NOT NULL
  • 주문상태(번호)t (txn_status)
  • 주문상태명(txn_status의 이름) (txn_status_name)
  • txn_order_date — NOT NULL
  • txn_payment_date — NOT NULL
  • txn_cancel_date — NOT NULL
  • txn_refund_date — NOT NULL
  • txn_refunded_date — NOT NULL
  • txn_memo — NULL

User Companies(HR) (user_hr)

  • mem_hr_id (mem_hr_idy) — 기본 키 — NOT NULL
  • Field6
  • mem_hr_company — NOT NULL
  • mem_hr_company_dept — NOT NULL
  • mem_hr_company_incharge — NOT NULL
  • mem_hr_company_reg_number — NOT NULL
  • mem_hr_company_size — NOT NULL
  • mem_hr_company_establish
  • mem_hr_company_website — NOT NULL
  • mem_hr_company_info — NOT NULL

User Info Education (multiple로 변경필요*) (mem_edu)

  • mem_edu_id — 기본 키 — NOT NULL
  • mem_edu_highschool — NOT NULL
  • mem_edu_highschool_gpa — NULL
  • mem_edu_highschool_major — NULL
  • mem_edu_highschool_entered_date
  • mem_edu_highschool_graduated_date
  • mem_edu_college — NOT NULL
  • mem_edu_college_gpa — NULL
  • mem_edu_college_major — NULL
  • mem_edu_college_entered_date
  • mem_edu_college_graduated_date
  • mem_edu_master — NOT NULL
  • mem_edu_master_gpa — NULL
  • mem_edu_master_major — NULL
  • mem_edu_master_entered_date
  • mem_edu_master_graduated_date
  • mem_edu_phd — NOT NULL
  • mem_edu_phd_gpa — NULL
  • mem_edu_phd_major — NULL
  • mem_edu_else — NOT NULL
  • mem_edu_else_gpa — NULL
  • mem_edu_else_major — NULL
  • mem_edu_else_entered_date
  • mem_edu_else_graduated_date
  • 중퇴,졸업,재학중? (mem_edu_else_status) — NOT NULL

User License (mem_lic)

  • mem_lic_id — 기본 키 — NOT NULL
  • mem_lic_title — NULL

User Work Experience (mem_work_exp)

  • mem_work_exp_id — 기본 키 — NOT NULL
  • mem_work_exp_company1
  • mem_work_exp_company2
  • mem_work_exp_company3
  • mem_work_exp_company4
  • mem_work_exp_company5
  • mem_work_exp_period1
  • mem_work_exp_period2
  • mem_work_exp_period3
  • mem_work_exp_period4
  • mem_work_exp_period5
  • mem_work_exp_dep1
  • mem_work_exp_dep2
  • mem_work_exp_dep3
  • mem_work_exp_dep4
  • mem_work_exp_dep5
  • mem_work_exp_description1
  • mem_work_exp_description2
  • mem_work_exp_description3
  • mem_work_exp_description4
  • mem_work_exp_description5

Users (mem)

  • 유저 기본 키값 (mem_id) — 기본 키 — NOT NULL
  • 유저 이름(Full-name) (mem_name) — NOT NULL
  • 유저 이메일 (mem_email) — NOT NULL
  • 유저 비밀번호 (mem_password) — NOT NULL
  • 유저 연락처 (핸드폰 인증 필수) (mem_phone) — NOT NULL
  • mem_type (구인자 = 0, 구직자 =1) (mem_type)
  • mem_basic_id — 외래 키 → Users Info Basics.mem_basic_id — NOT NULL
  • mem_edu_id — 외래 키 → User Info Education (multiple로 변경필요*).mem_edu_id — NOT NULL
  • mem_work_exp_id — 외래 키 → User Work Experience.mem_work_exp_id — NOT NULL
  • mem_extra_cur_id — 외래 키 → Users Extra Curriculum.mem_extra_cur_id — NOT NULL
  • mem_lic_id — 외래 키 → User License.mem_lic_id — NOT NULL
  • mem_hr_id (mem_hr_idy) — 외래 키 → User Companies(HR).mem_hr_id — NOT NULL

Users Extra Curriculum (mem_extra_cur)

  • mem_extra_cur_id — 기본 키 — NOT NULL
  • mem_work_exp_company1 (mem_extra_cur_company1)
  • mem_work_exp_company2 (mem_extra_cur_company2)
  • mem_work_exp_company3 (mem_extra_cur_company3)
  • mem_work_exp_company4 (mem_extra_cur_company4)
  • mem_work_exp_company5 (mem_extra_cur_company5)
  • mem_work_exp_period1 (mem_extra_cur_period1)
  • mem_work_exp_period2 (mem_extra_cur_period2)
  • mem_work_exp_period3 (mem_extra_cur_period3)
  • mem_work_exp_period4 (mem_extra_cur_period4)
  • mem_work_exp_period5 (mem_extra_cur_period5)
  • mem_work_exp_dep1 (mem_extra_cur_dep1)
  • mem_work_exp_dep2 (mem_extra_cur_dep2)
  • mem_work_exp_dep3 (mem_extra_cur_dep3)
  • mem_work_exp_dep4 (mem_extra_cur_dep4)
  • mem_work_exp_dep5 (mem_extra_cur_dep5)
  • mem_work_exp_description1 (mem_extra_cur_description1)
  • mem_work_exp_description2 (mem_extra_cur_description2)
  • mem_work_exp_description3 (mem_extra_cur_description3)
  • mem_work_exp_description4 (mem_extra_cur_description4)
  • mem_work_exp_description5 (mem_extra_cur_description5)

Users Info Basics (mem_basic)

  • mem_basic_id — 기본 키 — NOT NULL
  • mem_basic_phone
  • 신입 혹은 경력 (신입=0, 경력=1) (mem_basic_experience)
  • 나이 (생년월일) (mem_basic_dob) — NOT NULL
  • 희망직무1 (mem_basic_position) — NOT NULL
  • 희망직무2 (mem_basic_position2) — NOT NULL
  • 희망직무3 (mem_basic_position3) — NOT NULL
  • 희망직무4 (mem_basic_position4) — NOT NULL
  • 희망직무5 (mem_basic_position5) — NOT NULL
  • 관심산업군 (mem_basic_industry) — NOT NULL
  • 희망 근무지역1 (mem_basic_location) — NOT NULL
  • 희망 근무지역2 (mem_basic_location2) — NOT NULL

alarm (CopyOfmem8)

  • alarm_id — NULL — 기본 키 — NOT NULL
  • mem_hr_id (mem_hr_idy) — 외래 키 → User Companies(HR).mem_hr_id — NOT NULL
  • job_id — 외래 키 → Jobs.job_id — NOT NULL
  • 유저 기본 키값 (mem_id) — 외래 키 → Users.유저 기본 키값 — NOT NULL