키스템프
테이블 (50)
AdvAnalysis (유입데이터)
- seq (Key) — 기본 키 — NOT NULL
- urlkey (key2) — 기본 키 — NOT NULL
- email (Key4) — 외래 키 → UserAdvKey.email — NOT NULL
- sugub_no (Key222) — 외래 키 → UserAdvKey.sugub_no — NOT NULL
- Key5 — 외래 키 → UserAdvKey.urlkey — NOT NULL
- Key (Key3) — 외래 키 → UserAdvKey.Key — NOT NULL
- sugub_no (Key6) — 외래 키 → UserAdvKey.sugub_no — NOT NULL
- email (Key23) — 외래 키 → UserAdvKey.email — NOT NULL
- sugub_no (Key32) — 외래 키 → UserAdvKey.sugub_no — NOT NULL
- Key3 (Key33) — 외래 키 → UserAdvKey.Key3 — NOT NULL
- companycode (Key2222) — 외래 키 → UserAdvKey.companycode — NOT NULL
- email (key) — 외래 키 → UserAdvKey.email — NOT NULL
- Key (Key322) — 외래 키 → UserAdvKey.Key — NOT NULL
- advid (Field)
- email (Field2)
- idaddr (Field3)
Advertise (공고테이블)
- sugub_no (Key) — 기본 키 — NOT NULL
- Key3 — 기본 키 — NOT NULL
- sugub_no (Key2) — 외래 키 → Sugub.sugub_no — NOT NULL
- companycode (Key22) — 외래 키 → Sugub.companycode — NOT NULL
- email (key) — 외래 키 → Sugub.email — NOT NULL
- Key (Key32) — 외래 키 → Sugub.Key — NOT NULL
- company_intro (Field2)
- company_intro_yn (Field)
- company_name (Field3)
- company_name_yn (Field4)
- main_work (Field5)
- main_work_yn (Field6)
- dpt_name (Field7)
- dpt_name_yn (Field8)
- salary (Field9)
- salary_yn (Field10)
- condition (Field11)
- condition_yn (Field12)
- special_condition (Field13)
- special_condition_yn (Field14)
- welfare (Field15)
- welfare_yn (Field16)
- location (Field17)
- location_yn (Field18)
Answer (답변테이블)
- jikcode_mid (Key) — varchar2(6) — 기본 키 — NOT NULL
- question_code (Key2) — varchar2(2) — 기본 키 — NOT NULL
- gubun (Key4) — char(1) — 기본 키 — NOT NULL
- answer_code (Key3) — varchar2(2) — 기본 키 — NOT NULL
- jikcode_mid (Key5) — varchar2(6) — 외래 키 → Question.jikcode_mid — NOT NULL
- question_code (Key22) — varchar2(2) — 외래 키 → Question.question_code — NOT NULL
- gubun (Key42) — varchar2(9) — 외래 키 → Question.gubun — NOT NULL
- answer_commnet (Field) — varchar2(1000)
- answer_option (Field2) — varchar2(9)
ApplyDetail (지원내역)
- sugub_no (Key) — 기본 키 — NOT NULL
- email (Key7) — 기본 키 — NOT NULL
- resume_id (Key8) — 기본 키 — NOT NULL
- sugub_no (Key22) — 외래 키 → Advertise.sugub_no — NOT NULL
- urlkey (Key5) — 외래 키 → UserAdvKey.urlkey — NOT NULL
- email (Key4) — 외래 키 → UserAdvKey.email — NOT NULL
- advid (Key3) — 외래 키 — NOT NULL
- sugub_no (Key222) — 외래 키 → UserAdvKey.sugub_no — NOT NULL
- Key (Key2) — 외래 키 → Advertise.sugub_no — NOT NULL
- sugub_no (Key6) — 외래 키 → UserAdvKey.sugub_no — NOT NULL
- email (Key23) — 외래 키 → UserAdvKey.email — NOT NULL
- sugub_no (Key32) — 외래 키 → UserAdvKey.sugub_no — NOT NULL
- Key3 (Key33) — 외래 키 → Advertise.Key3 — NOT NULL
- companycode (Key223) — 외래 키 → Advertise.companycode — NOT NULL
- email (key) — 외래 키 → Advertise.email — NOT NULL
- Key (Key322) — 외래 키 → Advertise.Key — NOT NULL
- urlkey (Field)
- succesyn (Field2)
- status (Field3)
- reasoncode (Field4)
COMCODE (상세코드)
- comidx (Field)
- code_id (Field2)
- code_name (Field3)
- code_topidx (Field4)
- code_topcd (Field5)
- code_use (Field6)
COMIDX (공통코드)
- Key — 기본 키 — NOT NULL
- idx_id (Field)
- idx_name (Field2)
- idx_use (Field3)
CRMURL (CRMURL전달)
Career (경력사항)
- email (Key) — 기본 키 — NOT NULL
- jikcode_top (Key2) — 기본 키 — NOT NULL
- resume_id (Key3) — 기본 키 — NOT NULL
- custid (Key6) — 기본 키 — NOT NULL
- sdate (Key7) — 기본 키 — NOT NULL
- seqno (Key4) — 기본 키 — NOT NULL
- emila (Key5) — 외래 키 → resume.emila — NOT NULL
- jikcode_top (Key22) — 외래 키 → resume.jikcode_top — NOT NULL
- resume_id (Key32) — 외래 키 → resume.resume_id — NOT NULL
- email (Key42) — 외래 키 → resume.email — NOT NULL
- jikcode_top (Key222) — 외래 키 → resume.jikcode_top — NOT NULL
- email (Key322) — 외래 키 → resume.email — NOT NULL
- edate (Field3)
- dpt_name (Field4)
- position (Field5)
CompanyBaseInfo (기업기본정보)
- companycode (Key) — 기본 키 — NOT NULL
- custid (Field)
- subject (Field2)
- main_category (Field3)
- mid_category (Field4)
- detail1_category (Field5)
- detail2_category (Field6)
- com_name (Field7)
- stock_code (Field8)
- finance_year (Field9)
- group_name (Field10)
- telno (w)
- faxno (Field11)
- found_date (Field12)
- website (Field13)
- corporation_num (Field14)
- remark (Field15)
- com_type (Field16)
- entrydate (Field17)
- entryid (Field18)
- moddate (Field19)
- modid (Field20)
- use_yn (Field21)
- emp_count (Field22)
- gross_total (Field23)
- partner_cnt (Field24)
- partner_emp_cnt (Field25)
- confirm_yn (Field26)
- typecode (Field27)
- title_code (Field28)
- hold_yn (Field29)
- hold_id (Field30)
- group_cd (Field31)
- company_stat (Field32)
- nation_code (Field33)
- second_comname (Field34)
CompanyChargeHistory (청구세팅 히스토리)
- companycode (Key) — 외래 키 → CompanyInfo.companycode — NOT NULL
- custid (Key2) — 외래 키 → CompanyInfo.custid — NOT NULL
- sugub_no (Key3) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- email (Key7) — 외래 키 → CompanyInfo.email — NOT NULL
- resume_id (Key8) — 외래 키 → CompanyInfo.resume_id — NOT NULL
- sugub_no (Key22) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- urlkey (Key5) — 외래 키 → CompanyInfo.urlkey — NOT NULL
- email (Key4) — 외래 키 → CompanyInfo.email — NOT NULL
- advid (Key32) — 외래 키 → CompanyInfo.advid — NOT NULL
- sugub_no (Key222) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- Key (Key23) — 외래 키 → CompanyInfo.Key — NOT NULL
- sugub_no (Key6) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- email (Key232) — 외래 키 → CompanyInfo.email — NOT NULL
- sugub_no (Key322) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- Key3 (Key33) — 외래 키 → CompanyInfo.Key3 — NOT NULL
- companycode (Key223) — 외래 키 → CompanyInfo.companycode — NOT NULL
- email (key) — 외래 키 → CompanyInfo.email — NOT NULL
- companycode (Key9) — 외래 키 → CompanyInfo.companycode — NOT NULL
- Key10 — 외래 키 → CompanyInfo.Key10 — NOT NULL
- Key (Key3222) — 외래 키 → CompanyInfo.Key — NOT NULL
CompanyChargeManager (기업청구담당자)
- custid (Key10) — 기본 키 — NOT NULL
- email (Key11) — 기본 키 — NOT NULL
- companycode (Key) — 외래 키 → CompanyInfo.companycode — NOT NULL
- custid (Key2) — 외래 키 → CompanyInfo.custid — NOT NULL
- sugub_no (Key3) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- email (Key7) — 외래 키 → CompanyInfo.email — NOT NULL
- resume_id (Key8) — 외래 키 → CompanyInfo.resume_id — NOT NULL
- sugub_no (Key22) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- urlkey (Key5) — 외래 키 → CompanyInfo.urlkey — NOT NULL
- email (Key4) — 외래 키 → CompanyInfo.email — NOT NULL
- advid (Key32) — 외래 키 → CompanyInfo.advid — NOT NULL
- sugub_no (Key222) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- Key (Key23) — 외래 키 → CompanyInfo.Key — NOT NULL
- sugub_no (Key6) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- email (Key232) — 외래 키 → CompanyInfo.email — NOT NULL
- sugub_no (Key322) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- Key3 (Key33) — 외래 키 → CompanyInfo.Key3 — NOT NULL
- companycode (Key223) — 외래 키 → CompanyInfo.companycode — NOT NULL
- email (key) — 외래 키 → CompanyInfo.email — NOT NULL
- companycode (Key9) — 외래 키 → CompanyInfo.companycode — NOT NULL
- Key10 (Key102) — 외래 키 → CompanyInfo.Key10 — NOT NULL
- Key (Key3222) — 외래 키 → CompanyInfo.Key — NOT NULL
- telno (Field)
- phoneno (Field2)
- keyman (Field3)
- character (Field4)
CompanyComment (기업특이사항)
- companycode (Key) — 외래 키 → CompanyInfo.companycode — NOT NULL
- custid (Key2) — 외래 키 → CompanyInfo.custid — NOT NULL
- sugub_no (Key3) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- email (Key7) — 외래 키 → CompanyInfo.email — NOT NULL
- resume_id (Key8) — 외래 키 → CompanyInfo.resume_id — NOT NULL
- sugub_no (Key22) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- urlkey (Key5) — 외래 키 → CompanyInfo.urlkey — NOT NULL
- email (Key4) — 외래 키 → CompanyInfo.email — NOT NULL
- advid (Key32) — 외래 키 → CompanyInfo.advid — NOT NULL
- sugub_no (Key222) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- Key (Key23) — 외래 키 → CompanyInfo.Key — NOT NULL
- sugub_no (Key6) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- email (Key232) — 외래 키 → CompanyInfo.email — NOT NULL
- sugub_no (Key322) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- Key3 (Key33) — 외래 키 → CompanyInfo.Key3 — NOT NULL
- companycode (Key223) — 외래 키 → CompanyInfo.companycode — NOT NULL
- email (key) — 외래 키 → CompanyInfo.email — NOT NULL
- companycode (Key9) — 외래 키 → CompanyInfo.companycode — NOT NULL
- Key10 — 외래 키 → CompanyInfo.Key10 — NOT NULL
- Key (Key3222) — 외래 키 → CompanyInfo.Key — NOT NULL
CompanyCommission (기업커미션)
- companycode (Key) — 외래 키 → CompanyInfo.companycode — NOT NULL
- custid (Key2) — 외래 키 → CompanyInfo.custid — NOT NULL
- sugub_no (Key3) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- email (Key7) — 외래 키 → CompanyInfo.email — NOT NULL
- resume_id (Key8) — 외래 키 → CompanyInfo.resume_id — NOT NULL
- sugub_no (Key22) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- urlkey (Key5) — 외래 키 → CompanyInfo.urlkey — NOT NULL
- email (Key4) — 외래 키 → CompanyInfo.email — NOT NULL
- advid (Key32) — 외래 키 → CompanyInfo.advid — NOT NULL
- sugub_no (Key222) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- Key (Key23) — 외래 키 → CompanyInfo.Key — NOT NULL
- sugub_no (Key6) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- email (Key232) — 외래 키 → CompanyInfo.email — NOT NULL
- sugub_no (Key322) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- Key3 (Key33) — 외래 키 → CompanyInfo.Key3 — NOT NULL
- companycode (Key223) — 외래 키 → CompanyInfo.companycode — NOT NULL
- email (key) — 외래 키 → CompanyInfo.email — NOT NULL
- companycode (Key9) — 외래 키 → CompanyInfo.companycode — NOT NULL
- Key10 — 외래 키 → CompanyInfo.Key10 — NOT NULL
- Key (Key3222) — 외래 키 → CompanyInfo.Key — NOT NULL
CompanyDetail (기업정보등록(내부))
CompanyHRManager (기업인사담당자)
- custid (Key10) — 기본 키 — NOT NULL
- email (Key11) — 기본 키 — NOT NULL
- companycode (Key) — 외래 키 → CompanyInfo.companycode — NOT NULL
- custid (Key2) — 외래 키 → CompanyInfo.custid — NOT NULL
- sugub_no (Key3) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- email (Key7) — 외래 키 → CompanyInfo.email — NOT NULL
- resume_id (Key8) — 외래 키 → CompanyInfo.resume_id — NOT NULL
- sugub_no (Key22) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- urlkey (Key5) — 외래 키 → CompanyInfo.urlkey — NOT NULL
- email (Key4) — 외래 키 → CompanyInfo.email — NOT NULL
- advid (Key32) — 외래 키 → CompanyInfo.advid — NOT NULL
- sugub_no (Key222) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- Key (Key23) — 외래 키 → CompanyInfo.Key — NOT NULL
- sugub_no (Key6) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- email (Key232) — 외래 키 → CompanyInfo.email — NOT NULL
- sugub_no (Key322) — 외래 키 → CompanyInfo.sugub_no — NOT NULL
- Key3 (Key33) — 외래 키 → CompanyInfo.Key3 — NOT NULL
- companycode (Key223) — 외래 키 → CompanyInfo.companycode — NOT NULL
- email (key) — 외래 키 → CompanyInfo.email — NOT NULL
- companycode (Key9) — 외래 키 → CompanyInfo.companycode — NOT NULL
- Key10 (Key102) — 외래 키 → CompanyInfo.Key10 — NOT NULL
- Key (Key3222) — 외래 키 → CompanyInfo.Key — NOT NULL
- telno (Field)
- phoneno (Field2)
- keyman (Field3)
- character (Field4)
CompanyInfo (기업정보(거래후))
- companycode (Key) — 기본 키 — NOT NULL
- custid (Key2) — 기본 키 — NOT NULL
- Key10 — 기본 키 — NOT NULL
- sugub_no (Key3) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- email (Key7) — 외래 키 → ApplyDetail.email — NOT NULL
- resume_id (Key8) — 외래 키 → ApplyDetail.resume_id — NOT NULL
- sugub_no (Key22) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- urlkey (Key5) — 외래 키 → ApplyDetail.urlkey — NOT NULL
- email (Key4) — 외래 키 → ApplyDetail.email — NOT NULL
- advid (Key32) — 외래 키 → ApplyDetail.advid — NOT NULL
- sugub_no (Key222) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- Key (Key23) — 외래 키 → ApplyDetail.Key — NOT NULL
- sugub_no (Key6) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- email (Key232) — 외래 키 → ApplyDetail.email — NOT NULL
- sugub_no (Key322) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- Key3 (Key33) — 외래 키 → ApplyDetail.Key3 — NOT NULL
- companycode (Key223) — 외래 키 → ApplyDetail.companycode — NOT NULL
- email (key) — 외래 키 → ApplyDetail.email — NOT NULL
- companycode (Key9) — 외래 키 → CompanyBaseInfo.companycode — NOT NULL
- Key (Key3222) — 외래 키 — NOT NULL
- subject (Field2)
- main_category (Field3)
- mid_category (Field4)
- detail1_category (Field5)
- detail2_category (Field6)
- com_name (Field7)
- stock_code (Field8)
- finance_year (Field9)
- group_name (Field10)
- telno (w)
- faxno (Field11)
- found_date (Field12)
- website (Field13)
- corporation_num (Field14)
- remark (Field15)
- com_type (Field16)
- entrydate (Field17)
- entryid (Field18)
- moddate (Field19)
- modid (Field20)
- use_yn (Field21)
- emp_count (Field22)
- gross_total (Field23)
- partner_cnt (Field24)
- partner_emp_cnt (Field25)
- confirm_yn (Field26)
- typecode (Field27)
- title_code (Field28)
- hold_yn (Field29)
- hold_id (Field30)
- group_cd (Field31)
- company_stat (Field32)
- nation_code (Field33)
- second_comname (Field34)
CompanyProfile (회사프로필)
- companycode (Key2) — 기본 키 — NOT NULL
- Key — 기본 키 — NOT NULL
- email (key) — 외래 키 → User.email — NOT NULL
- custid (Field20)
- companyname (Field2)
- revenue (Field4)
- cmp_manager (Field5)
- upjong (Field6)
- stock_gubun (Field7)
- group_company (Field8)
- road_addr_code (Field9)
- road_addr (Field10)
- road_addr_detail (Field11)
- post_addr_code (Field12)
- post_addr (Field13)
- post_addr_detail (Field14)
- homepage (Field15)
- nation (Field16)
- emp_count (Field17)
- manager_email (Field18)
- manager_phone (Field19)
- status (Field3)
CrmCompanyBaseInfo (CRM기업기본정보)
- companycode (Key) — number(7) — 기본 키 — NOT NULL
- custid (Field) — varchar2(12)
- subject (Field2) — varchar2(10)
- main_category (Field3) — varchar2(2)
- mid_category (Field4) — varchar2(3)
- detail1_category (Field5) — varchar2(4)
- detail2_category (Field6) — varchar2(5)
- com_name (Field7) — varchar2(100)
- stock_code (Field8) — varchar2(6)
- finance_year (Field9) — varchar2(6)
- group_name (Field10) — varchar2(100)
- telno (w) — varchar2(20)
- faxno (Field11) — varchar2(20)
- zipno (Field35) — varchar2(6)
- addr (Field36) — varchar2(300)
- addr_detail (Field37) — varchar2(500)
- found_date (Field12) — varchar2(8)
- website (Field13) — varchar2(50)
- corporation_num (Field14) — varchar2(30)
- mng_id (Field38) — varchar2(30)
- remark (Field15) — varchar2(4000)
- com_type (Field16) — varchar2(20)
- entrydate (Field17) — date
- entryid (Field18) — VARCHAR2(20)
- moddate (Field19) — date
- modid (Field20) — VARCHAR2(20)
- use_yn (Field21) — char(1)
- emp_count (Field22) — VARCHAR2(10)
- gross_total (Field23) — number(22)
- partner_cnt (Field24) — VARCHAR2(10)
- partner_emp_cnt (Field25) — VARCHAR2(10)
- confirm_yn (Field26) — char(1)
- typecode (Field27)
- title_code (Field28) — VARCHAR2(1)
- hold_yn (Field29) — char(1)
- hold_id (Field30) — VARCHAR2(20)
- group_cd (Field31) — VARCHAR2(10)
- company_stat (Field32) — VARCHAR2(9)
- nation_code (Field33) — VARCHAR2(9)
- second_comname (Field34) — VARCHAR2(100)
CrmCompanyManager (기업인사담당자등록)
- seqno (Key2) — number(5) — 기본 키 — NOT NULL
- companycode (Key) — number(7) — 외래 키 → CrmCompanyBaseInfo.companycode — NOT NULL
- custid (Field) — varchar2(12)
- mng_id (Field3) — varchar2(30)
- indamname (Field4) — varchar2(20)
- indamgrade (Field5) — varchar2(20)
- indampart (Field6) — varchar2(20)
- telno (Field7) — varchar2(50)
- hpno (Field8) — varchar2(50)
- email (Field9) — varchar2(100)
- indamcharacter (Field2) — varchar2(1000)
- remark (Field10) — varchar2(4000)
- keyman (Field15) — char(1)
- entrydate (Field11) — date
- entryid (Field12) — varchar2(30)
- moddate (Field13) — date
- modid (Field14) — varchar2(30)
CrmCompanyRemark (기업컨택일지)
- mng_id (Key) — varchar2(30) — 기본 키 — NOT NULL
- seqno (Key3) — 기본 키 — NOT NULL
- companycode (Key2) — number(7) — 외래 키 → CrmCompanyBaseInfo.companycode — NOT NULL
- custid (Field23) — varchar2(12)
- cust_mng (Field) — varchar2(30)
- telno (Field2) — varchar2(50)
- email (Field3) — varchar2(100)
- hpno (Field4) — varchar2(50)
- contact_date (Field5) — date
- predict_date (Field6) — date
- competition (Field7) — varchar2(1000)
- position (Field8) — varchar2(100)
- detail (Field9) — varchar2(1000)
- etcs (Field10) — varchar2(1000)
- etc2 (Field11) — varchar2(1000)
- tel_gubun (Field12) — char(1)
- email_gubun (Field13) — char(1)
- visit_gubun (Field14) — char(1)
- adjust_gubun (Field15) — char(1)
- request_gubun (Field16) — char(1)
- bigo (Field17) — varchar2(1000)
- cnt (Field18) — number(3)
- entrydate (Field19) — date
- entryid (Field20) — varchar2(30)
- moddate (Field21) — date
- modid (Field22) — varchar2(30)
CrmCompanySpec (기업채용스펙)
- companycode (Key2) — number(7) — 외래 키 → CrmCompanyBaseInfo.companycode — NOT NULL
- custid (Field) — varchar2(12)
- mng_id (Field2) — varchar2(30)
- dispatch_yn (v) — char(1)
- dispatch_capa (Field4) — number(3)
- agency_yn (Field5) — char(1)
- dogub_yn (Field6) — char(1)
- remark (Field7) — varchar2(1000)
- entrydate (Field8) — date
- entryid (Field9) — varchar2(30)
- moddate (Field10) — date
- modid (Field3) — varchar2(30)
ETC_DETAIL (수상 및 기타)
- email (Key) — 기본 키 — NOT NULL
- jikcode_top (Key2) — 기본 키 — NOT NULL
- resume_id (Key3) — 기본 키 — NOT NULL
- seqno (Key4) — 기본 키 — NOT NULL
- emila (Key5) — 외래 키 → resume.emila — NOT NULL
- jikcode_top (Key22) — 외래 키 → resume.jikcode_top — NOT NULL
- resume_id (Key32) — 외래 키 → resume.resume_id — NOT NULL
- email (Key42) — 외래 키 → resume.email — NOT NULL
- jikcode_top (Key222) — 외래 키 → resume.jikcode_top — NOT NULL
- email (Key322) — 외래 키 → resume.email — NOT NULL
- title (Field)
- title_detail (Field2)
Education (학력사항)
- email (Key) — 기본 키 — NOT NULL
- jikcode_top (Key2) — 기본 키 — NOT NULL
- resume_id (Key3) — 기본 키 — NOT NULL
- seqno (Key4) — 기본 키 — NOT NULL
- school_code (Key6) — 기본 키 — NOT NULL
- sdate (Key7) — 기본 키 — NOT NULL
- emila (Key5) — 외래 키 → resume.emila — NOT NULL
- jikcode_top (Key22) — 외래 키 → resume.jikcode_top — NOT NULL
- resume_id (Key32) — 외래 키 → resume.resume_id — NOT NULL
- email (Key42) — 외래 키 → resume.email — NOT NULL
- jikcode_top (Key222) — 외래 키 → resume.jikcode_top — NOT NULL
- email (Key322) — 외래 키 → resume.email — NOT NULL
- major_code (Field2)
- major_detail (Field3)
- edate (Field5)
- Field
EmpWorkCondition (근태)
- email (Key) — 기본 키 — NOT NULL
- sdate (Key2) — 기본 키 — NOT NULL
- workdate (Key3) — 기본 키 — NOT NULL
- 상태 (Field)
- 출근시간 (Field2)
Employee (사원등록테이블)
- empno (Key7) — 기본 키 — NOT NULL
- company (Key2) — 외래 키 → CompanyProfile.companycode — NOT NULL
- advid (Key) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- sugub_no (Key22) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- urlkey (Key5) — 외래 키 → ApplyDetail.urlkey — NOT NULL
- email (Key4) — 외래 키 → ApplyDetail.email — NOT NULL
- advid (Key3) — 외래 키 → ApplyDetail.advid — NOT NULL
- sugub_no (Key222) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- Key (Key23) — 외래 키 → ApplyDetail.Key — NOT NULL
- sugub_no (Key6) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- email (Key232) — 외래 키 → ApplyDetail.email — NOT NULL
- sugub_no (Key32) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- Key7 (Key72) — 외래 키 → ApplyDetail.email — NOT NULL
- Key8 (Key82) — 외래 키 → ApplyDetail.resume_id — NOT NULL
- Key3 (Key33) — 외래 키 — NOT NULL
- companycode (Key2222) — 외래 키 — NOT NULL
- email (key) — 외래 키 — NOT NULL
- Key (Key8) — 외래 키 → CompanyProfile.Key — NOT NULL
- juminno (Field)
- personname (Field2)
- ip_start (d)
- ip_end (Field4)
- Field3
EmployeeSalary (급여원장)
- email (Key) — 기본 키 — NOT NULL
- sdate (Key2) — 기본 키 — NOT NULL
- juminno (Field)
Employee_detail (근무이력테이블)
- empno (Key) — 기본 키 — NOT NULL
- Key2 — 기본 키 — NOT NULL
- Field
- Field2
- Field3
Jikjong (직종테이블)
- jikcode_mid (Key) — 기본 키 — NOT NULL
- jikcode_mid_name (Field)
- jikcode_top_name (Field2)
- use_yn (Field3)
- dispatch_yn (Field4)
- jikjong_image (Field5)
- jikjong_comment (Field6)
MembershipReview (환급금리뷰)
- email (Key) — 기본 키 — NOT NULL
- email (Key2) — 외래 키 → UserMembership.email — NOT NULL
- email (Key22) — 외래 키 → UserMembership.email — NOT NULL
- comment (Field)
- point (Field2)
- image (Field3)
Question (질문테이블)
- jikcode_mid (Key) — varchar2(6) — 기본 키 — NOT NULL
- question_code (Key2) — varchar2(2) — 기본 키 — NOT NULL
- gubun (Key4) — varchar2(9) — 기본 키 — NOT NULL
- question_commnet (Field2) — varchar2(1000)
Quotation (견적서)
- email (Key) — 기본 키 — NOT NULL
- sdate (Key2) — 기본 키 — NOT NULL
SubChargeManger (서브청구담당자)
- email (Key) — 기본 키 — NOT NULL
- companycode (Key2) — 외래 키 → CompanyProfile.companycode — NOT NULL
- email (key) — 외래 키 → CompanyProfile.email — NOT NULL
- Key (Key3) — 외래 키 → CompanyProfile.Key — NOT NULL
SubHRManager (서브인담자)
- email (Key) — 기본 키 — NOT NULL
- companycode (Key2) — 외래 키 → CompanyProfile.companycode — NOT NULL
- email (key) — 외래 키 → CompanyProfile.email — NOT NULL
- Key (Key3) — 외래 키 → CompanyProfile.Key — NOT NULL
Sugub (수급)
- sugub_no (Key) — 기본 키 — NOT NULL
- companycode (Key2) — 외래 키 → CompanyProfile.companycode — NOT NULL
- email (key) — 외래 키 → CompanyProfile.email — NOT NULL
- Key (Key3) — 외래 키 → CompanyProfile.Key — NOT NULL
- user (Field)
- Field24
- custid (Field2)
- chae_cd (Field3)
- sugub_end_dt (Field4)
- jikcode_mid (Field5)
- career_gb (Field6)
- career_start (Field7)
- career_end (Field8)
- work_role (Field9)
- position_name (Field10)
- educationlevel (Field11)
- gender_gb (Field12)
- age_start (Field13)
- age_end (Field14)
- road_addr_code (Field15)
- road_addr (Field16)
- road_addr_detail (Field17)
- post_addr_code (Field18)
- post_addr (Field19)
- post_addr_detail (Field20)
- salary_start (Field21)
- salary_end (Field22)
- (Field23)
- answer_code (Field25)
SugubDetail (수급상세(질문))
- sugub (Field)
- question_code (Field2)
- anwser (Field3)
SugubReview (수급리뷰테이블)
- sugub_no (Key) — 기본 키 — NOT NULL
- email (Key2) — 기본 키 — NOT NULL
- sugub_no (Key3) — 외래 키 → Sugub.sugub_no — NOT NULL
- companycode (Key22) — 외래 키 → Sugub.companycode — NOT NULL
- email (key) — 외래 키 → Sugub.email — NOT NULL
- Key (Key32) — 외래 키 → Sugub.Key — NOT NULL
- entry_gubun (Field)
- jikcode_mid (Field2)
- comment (Field3)
- point (Field4)
- image (Field5)
Sugub_Searcher (해당서쳐)
- sugub_no (Key) — 기본 키 — NOT NULL
- email (Key2) — 기본 키 — NOT NULL
- sugub_no (Key3) — 외래 키 → Sugub.sugub_no — NOT NULL
- companycode (Key22) — 외래 키 → Sugub.companycode — NOT NULL
- email (key) — 외래 키 → Sugub.email — NOT NULL
- Key (Key32) — 외래 키 → Sugub.Key — NOT NULL
- urlkey (Field)
Untitled2 (직종별 질문)
- code_id (직종코드)
- seq (순번)
- question (질문내용)
User (유저)
- email (Key) — 기본 키 — NOT NULL
- password (Field2)
UserAdvKey (공고공유키)
- urlkey (Key5) — 기본 키 — NOT NULL
- email (Key4) — 외래 키 → User.email — NOT NULL
- sugub_no (Key22) — 외래 키 → Advertise.sugub_no — NOT NULL
- Key (Key3) — 외래 키 → Advertise.sugub_no — NOT NULL
- sugub_no (Key6) — 외래 키 → Sugub_Searcher.sugub_no — NOT NULL
- email (Key23) — 외래 키 → Sugub_Searcher.email — NOT NULL
- sugub_no (Key32) — 외래 키 → Sugub_Searcher.sugub_no — NOT NULL
- Key3 (Key33) — 외래 키 → Advertise.Key3 — NOT NULL
- companycode (Key222) — 외래 키 → Advertise.companycode — NOT NULL
- email (key) — 외래 키 → Advertise.email — NOT NULL
- Key (Key322) — 외래 키 → Advertise.Key — NOT NULL
- advid (Key) — NOT NULL
- email (Key2) — NOT NULL
UserMembership (사용자환급금)
- email (Key) — 기본 키 — NOT NULL
- email (Key2) — 외래 키 → User.email — NOT NULL
- acount (Field)
- totalamt (Field1)
- outputamt (Field2)
- balanceamt (Field3)
UserProfile (유저프로필)
- email (Key) — 외래 키 → User.email — NOT NULL
- user (Field)
- username (Field2)
- phone (Field3)
- gender (Field4)
- birthday (Field5)
UserSpecial (전문분야설정)
- email (Key) — 기본 키 — NOT NULL
- jikcode_top (Key2) — 기본 키 — NOT NULL
- email (Key3) — 외래 키 → UserProfile.email — NOT NULL
- jikcode_mid (Field)
- jikcode_low (Field6)
- career_gigan (Field2)
- final_education (Field12)
- salary_gb (Field3)
- currency_gb (Field4)
- salary_amt (Field5)
- urlkey (Field7)
- except_company (Field8)
- answer_code (Field13)
- open_yn (Field9)
- entrydate (Field10)
- moddate (Field11)
calculate_history (정산내역history)
- Key9 — 기본 키 — NOT NULL
- seq (Key) — 외래 키 → AdvAnalysis.seq — NOT NULL
- urlkey (key2) — 외래 키 → AdvAnalysis.urlkey — NOT NULL
- email (Key4) — 외래 키 → AdvAnalysis.email — NOT NULL
- sugub_no (Key222) — 외래 키 → AdvAnalysis.sugub_no — NOT NULL
- Key5 — 외래 키 → AdvAnalysis.Key5 — NOT NULL
- Key (Key3) — 외래 키 → AdvAnalysis.Key — NOT NULL
- sugub_no (Key6) — 외래 키 → AdvAnalysis.sugub_no — NOT NULL
- email (Key23) — 외래 키 → AdvAnalysis.email — NOT NULL
- sugub_no (Key32) — 외래 키 → AdvAnalysis.sugub_no — NOT NULL
- advid (Key2) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- sugub_no (Key22) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- urlkey (Key52) — 외래 키 → ApplyDetail.urlkey — NOT NULL
- email (Key42) — 외래 키 → ApplyDetail.email — NOT NULL
- advid (Key33) — 외래 키 → ApplyDetail.advid — NOT NULL
- sugub_no (Key2222) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- Key (Key24) — 외래 키 → ApplyDetail.Key — NOT NULL
- sugub_no (Key62) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- email (Key232) — 외래 키 → ApplyDetail.email — NOT NULL
- sugub_no (Key322) — 외래 키 → ApplyDetail.sugub_no — NOT NULL
- Key7 — 외래 키 → ApplyDetail.email — NOT NULL
- Key8 — 외래 키 → ApplyDetail.resume_id — NOT NULL
- Key3 (Key332) — 외래 키 → AdvAnalysis.Key3 — NOT NULL
- companycode (Key22222) — 외래 키 → AdvAnalysis.companycode — NOT NULL
- email (key) — 외래 키 → AdvAnalysis.email — NOT NULL
- Key (Key3222) — 외래 키 → AdvAnalysis.Key — NOT NULL
career_link (커리어링크)
- email (Key) — 기본 키 — NOT NULL
- jikcode_top (Key2) — 기본 키 — NOT NULL
- resume_id (Key3) — 기본 키 — NOT NULL
- seqno (Key4) — 기본 키 — NOT NULL
- emila (Key5) — 외래 키 → resume.emila — NOT NULL
- jikcode_top (Key22) — 외래 키 → resume.jikcode_top — NOT NULL
- resume_id (Key32) — 외래 키 → resume.resume_id — NOT NULL
- email (Key42) — 외래 키 → resume.email — NOT NULL
- jikcode_top (Key222) — 외래 키 → resume.jikcode_top — NOT NULL
- email (Key322) — 외래 키 → resume.email — NOT NULL
- link_addr (Field)
contract (근로계약서)
- email (Key) — 기본 키 — NOT NULL
- sdate (Key2) — 기본 키 — NOT NULL
- delaysdate (Key3) — 기본 키 — NOT NULL
language (외국어능력)
- email (Key) — 기본 키 — NOT NULL
- jikcode_top (Key2) — 기본 키 — NOT NULL
- resume_id (Key3) — 기본 키 — NOT NULL
- language_code (Key5) — 기본 키 — NOT NULL
- seqno (Key4) — 기본 키 — NOT NULL
- emila (Key6) — 외래 키 → resume.emila — NOT NULL
- jikcode_top (Key22) — 외래 키 → resume.jikcode_top — NOT NULL
- resume_id (Key32) — 외래 키 → resume.resume_id — NOT NULL
- email (Key42) — 외래 키 → resume.email — NOT NULL
- jikcode_top (Key222) — 외래 키 → resume.jikcode_top — NOT NULL
- email (Key322) — 외래 키 → resume.email — NOT NULL
- Level (Field)
language_detail (어학시험)
- email (Key) — 기본 키 — NOT NULL
- jikcode_top (Key2) — 기본 키 — NOT NULL
- resume_id (Key3) — 기본 키 — NOT NULL
- language_code (Key4) — 기본 키 — NOT NULL
- seqno (Key5) — 기본 키 — NOT NULL
- language_code_mid (Key6) — 기본 키 — NOT NULL
- email (Key7) — 외래 키 → language.email — NOT NULL
- jikcode_top (Key22) — 외래 키 → language.jikcode_top — NOT NULL
- resume_id (Key32) — 외래 키 → language.resume_id — NOT NULL
- language_code (Key52) — 외래 키 → language.language_code — NOT NULL
- seqno (Key42) — 외래 키 → language.seqno — NOT NULL
- emila (Key62) — 외래 키 → language.emila — NOT NULL
- jikcode_top (Key222) — 외래 키 → language.jikcode_top — NOT NULL
- resume_id (Key322) — 외래 키 → language.resume_id — NOT NULL
- email (Key422) — 외래 키 → language.email — NOT NULL
- jikcode_top (Key2222) — 외래 키 → language.jikcode_top — NOT NULL
- email (Key3222) — 외래 키 → language.email — NOT NULL
- levelpoint (Field)
- getdate (Field2)
main_result (주요성과)
- email (Key) — 기본 키 — NOT NULL
- jikcode_top (Key2) — 기본 키 — NOT NULL
- resume_id (Key3) — 기본 키 — NOT NULL
- custid (Key4) — 기본 키 — NOT NULL
- sdate (Key5) — 기본 키 — NOT NULL
- seqno (Key6) — 기본 키 — NOT NULL
- email (Key7) — 외래 키 → Career.email — NOT NULL
- jikcode_top (Key22) — 외래 키 → Career.jikcode_top — NOT NULL
- resume_id (Key32) — 외래 키 → Career.resume_id — NOT NULL
- custid (Key62) — 외래 키 → Career.custid — NOT NULL
- sdate (Key72) — 외래 키 → Career.sdate — NOT NULL
- seqno (Key42) — 외래 키 → Career.seqno — NOT NULL
- emila (Key52) — 외래 키 → Career.emila — NOT NULL
- jikcode_top (Key222) — 외래 키 → Career.jikcode_top — NOT NULL
- resume_id (Key322) — 외래 키 → Career.resume_id — NOT NULL
- email (Key422) — 외래 키 → Career.email — NOT NULL
- jikcode_top (Key2222) — 외래 키 → Career.jikcode_top — NOT NULL
- email (Key3222) — 외래 키 → Career.email — NOT NULL
- result_title (Field)
- result_sdate (Field2)
- result_edate (Field3)
- result_detail (Field4)
resume (이력서)
- emila (Key) — 기본 키 — NOT NULL
- jikcode_top (Key2) — 기본 키 — NOT NULL
- resume_id (Key3) — 기본 키 — NOT NULL
- email (Key4) — 외래 키 → UserSpecial.email — NOT NULL
- jikcode_top (Key22) — 외래 키 → UserSpecial.jikcode_top — NOT NULL
- email (Key32) — 외래 키 → UserSpecial.email — NOT NULL
- entrydate (Field)
- state (Field2)
- moddate (Field3)
- except_company (Field4)
- open_yn (Field5)
- urlkey (Field6)
- introduce (Field7)