Recruit

Tables (23)

Apply1 (보훈)

  • id (Key) — Foreign key → Apply.id — NOT NULL
  • post_id (Key2) — Foreign key → Apply.post_id — NOT NULL
  • crew_id (Key22) — Foreign key → Apply.crew_id — NOT NULL
  • answer (Field)

Apply3 (학력)

  • id (Key) — Foreign key → Apply.id — NOT NULL
  • post_id (Key2) — Foreign key → Apply.post_id — NOT NULL
  • crew_id (Key22) — Foreign key → Apply.crew_id — NOT NULL
  • kind (Field)
  • name (Field2)
  • major (Field3)
  • start_dt (Field4)
  • end_dt (Field5)
  • current_yn (Field6)
  • eff_status (Field7)

ApplyProcess (지원자 전형단계)

  • id (Key) — Foreign key → Apply.id — NOT NULL
  • post_id (Key2) — Foreign key → Apply.post_id — NOT NULL
  • crew_id (Key22) — Foreign key → Apply.crew_id — NOT NULL
  • process_id (Key3) — Foreign key → Process.process_id — NOT NULL
  • process_name (Field)
  • process_kind (Field2)
  • seq (Field3)
  • add_Dt (Field4)
  • add_user (Field5)
  • upd_dt (Field6)
  • upd_user (Field7)
  • result (Field8)
  • avg_score (Field9)

Apply_Agree (동의서 동의 목록)

  • id (Key) — Foreign key → Apply.id — NOT NULL
  • post_id (Key2) — Foreign key → Apply.post_id — NOT NULL
  • crew_id (Key22) — Foreign key → Apply.crew_id — NOT NULL
  • agree_id (Key3) — Foreign key → Agree.agree_id — NOT NULL
  • agree_yn (Field)
  • add_dt (Field2)
  • add_user (Field3)

Jobs (Untitled6)

  • job_id (Key3) — Primary key — NOT NULL
  • post_id (Key) — Foreign key → JobPosts.post_id — NOT NULL
  • crew_id (Key2) — Foreign key → JobPosts.crew_id — NOT NULL
  • JobName (Field)
  • add_dt (Field2)
  • add_user (Field3)
  • upd_dt (Field4)
  • upd_user (Field5)

UserRoles (Untitled11)

  • role_id (Key) — Foreign key → SystemRole.role_id — NOT NULL
  • user_id (Key2) — Foreign key → Users.user_id — NOT NULL
  • crew_id (Key3) — Foreign key → Users.crew_id — NOT NULL
  • add_dt (Field)
  • add_user (Field2)
  • upd_dt (Field3)
  • upd_user (Field4)

email_log (Untitled17)

  • id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Primary key — NOT NULL
  • to_email (Field)
  • from_email (Field2)
  • name (Field3)
  • content (Field4)
  • title (Field5)
  • send_dt (Field6)
  • send_user (Field7)
  • process_name (Field8)
  • process_kind (Field9)
  • seq (Field10)

interview (Untitled15)

  • id (Key) — Foreign key → Apply.id — NOT NULL
  • post_id (Key2) — Foreign key → Apply.post_id — NOT NULL
  • crew_id (Key22) — Foreign key → Apply.crew_id — NOT NULL
  • process_kind (Field)
  • process_id (Field2)
  • seq (Field3)
  • assesser (Field4)
  • assess_Dt (Field5)
  • add_Dt (Field6)
  • add_user (Field7)
  • upd_dt (Field8)
  • upd_user (Field9)

Agree (Untitled13)

  • agree_id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → JobPosts.post_id — NOT NULL
  • crew_id (Key22) — Foreign key → JobPosts.crew_id — NOT NULL
  • content (Field)
  • add_dt (Field2)
  • add_user (Field3)
  • upd_dt (Field4)
  • upd_user (Field5)

Apply (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → JobPosts.post_id — NOT NULL
  • crew_id (Key22) — Foreign key → JobPosts.crew_id — NOT NULL
  • name (Field)
  • email (Field2)
  • birthday (Field3)
  • sex (Field4)
  • apply_route (Field5)
  • add_dt (Field6)
  • add_user (Field7)
  • upd_dt (Field9)
  • upd_user (Field10)
  • protfolio_url (Field8)
  • cv_url (Field11)

Apply2 (장애)

  • id (Key) — Foreign key → Apply.id — NOT NULL
  • post_id (Key2) — Foreign key → Apply.post_id — NOT NULL
  • crew_id (Key22) — Foreign key → Apply.crew_id — NOT NULL
  • answer (Field)

Apply_Question (자기소개서 제출)

  • id (Key) — Foreign key → Apply.id — NOT NULL
  • post_id (Key2) — Foreign key → Apply.post_id — NOT NULL
  • crew_id (Key22) — Foreign key → Apply.crew_id — NOT NULL
  • cv_id (Key3) — Foreign key → Question.cv_id — NOT NULL
  • content (Field)
  • answer (Field2)
  • seq (Field3)
  • add_Dt (Field4)
  • add_user (Field5)

Crews (Untitled2)

  • crew_id (Key) — Primary key — NOT NULL
  • crew_name (Field)
  • crew_info (Field2)
  • add_user (Field3)
  • add_dt (Field4)
  • upd_user (Field5)
  • upd_dt (Field6)

InterviewResult (Untitled16)

  • id (Key) — Foreign key → Apply.id — NOT NULL
  • post_id (Key2) — Foreign key → Apply.post_id — NOT NULL
  • crew_id (Key22) — Foreign key → Apply.crew_id — NOT NULL
  • process_kind (Field)
  • process_id (Field2)
  • seq (Field3)
  • assessor (Field4)
  • submit_dt (Field5)
  • submit (Field6)
  • score (Field7)
  • add_dt (Field8)
  • add_user (Field9)
  • upd_dt (Field10)
  • upd_user (Field11)

JobPosts (Untitled3)

  • post_id (Key) — Primary key — NOT NULL
  • crew_id (Key2) — Foreign key → Crews.crew_id — NOT NULL
  • title (Field)
  • hire_num (Field2)
  • start_dt (Field3)
  • end_dt (Field4)
  • manager (Field5)
  • open_status (Field6)
  • eff_staus (Field7)
  • eff_dt (Field8)
  • add_dt (Field9)
  • add_user (Field10)
  • upd_dt (Field11)
  • upd_user (Field12)
  • portfolio_yn (Field14)
  • CV_yn (Field13)

Process (Untitled9)

  • process_id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → JobPosts.post_id — NOT NULL
  • crew_id (Key22) — Foreign key → JobPosts.crew_id — NOT NULL
  • process_name (Field)
  • process_kind (Field2)
  • seq (Field3)
  • add_dt (Field4)
  • add_user (Field5)
  • upd_dt (Field6)
  • upd_user (Field7)

Question (Untitled10)

  • cv_id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → JobPosts.post_id — NOT NULL
  • crew_id (Key22) — Foreign key → JobPosts.crew_id — NOT NULL
  • content (Field)
  • essential_status (Field2)
  • min_char (Field3)
  • max_char (Field4)
  • seq (Field5)
  • add_Dt (Field6)
  • add_user (Field7)
  • upd_dt (Field8)
  • upd_user (Field9)

Resume (Untitled7)

  • post_id (Key) — Foreign key → JobPosts.post_id — NOT NULL
  • crew_id (Key2) — Foreign key → JobPosts.crew_id — NOT NULL
  • resume_id (Key3) — Foreign key → ResumeTemplates.resume_id — NOT NULL
  • gubun (Field)
  • seq (Field2)
  • add_dt (Field3)
  • add_user (Field4)
  • upd_dt (Field5)
  • upd_user (Field6)

ResumeTemplates (Untitled8)

  • resume_id (Key) — Primary key — NOT NULL
  • name (Field)
  • type (Field2)
  • gubun (Field3)
  • add_dt (Field4)
  • add_user (Field5)
  • upd_dt (Field6)
  • upd_user (Field7)

SystemRole (Untitled12)

  • role_id (Key) — Primary key — NOT NULL
  • role_name (Field)

TalentDB (Untitled4)

    Users (Untitled)

    • user_id (Key) — Primary key — NOT NULL
    • crew_id (Key3) — Foreign key → Crews.crew_id — NOT NULL
    • user_name (Field)
    • birthday (Field2)
    • email (Field3)
    • phone (Field4)
    • pwd (Field5)
    • add_dt (Field6)
    • add_user (Field7)
    • upd_dt (Field8)
    • upd_user (Field9)

    sms_log (Untitled18)

    • id (Key) — Primary key — NOT NULL
    • post_id (Key2) — Primary key — NOT NULL
    • to_phone (Field)
    • from_phone (Field2)
    • name (Field3)
    • content (Field4)
    • send_dt (Field5)
    • send_user (Field6)
    • process_name (Field7)
    • process_kind (Field8)
    • seq (Field9)