키스템프

테이블 (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)