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)