ERD

Tables (11)

APPLICANT_APPLICATION_FORM_TB (지원서)

  • id — varchar — Primary key — NOT NULL
  • applicant_profile_id (id2) — varchar — Foreign key → APPLICANT_PROFILE_TB.id — NOT NULL
  • company_profile_id (id3) — varchar — Foreign key → COMPANY_PROFILE_TB.id — NOT NULL

APPLICANT_CAREER_TB (CopyOf학력)

  • id — varchar — Primary key — NOT NULL
  • applicant_profile_id (id2) — varchar — Foreign key → APPLICANT_PROFILE_TB.id — NOT NULL
  • joining_date (Field2) — varchar
  • quit_date (Field3) — varchar
  • workplace_name (Field4) — varchar
  • position (Field5) — varchar
  • work (Field6) — varchar

APPLICANT_EDUCATION_TB (학력)

  • id — varchar — Primary key — NOT NULL
  • applicant_profile_id (id2) — varchar — Foreign key → APPLICANT_PROFILE_TB.id — NOT NULL
  • school_name (Field2) — varchar
  • major (Field3) — varchar
  • admission_year (Field4) — datetime
  • graduation_year (Field5) — datetime

APPLICANT_PROFILE_TB (프로필)

  • id — varchar — Primary key — NOT NULL
  • name (varchar) — varchar
  • phone_number (Field2) — varchar
  • email (Field3) — varchar

APPLICANT_RESUME_TB (이력서)

  • id — varchar — Primary key — NOT NULL
  • applicant_profile_id (id2) — varchar — Foreign key → APPLICANT_PROFILE_TB.id — NOT NULL
  • text (Field2) — varchar

COMPANY_ALRAM_TB (알람)

  • id — varchar — Primary key — NOT NULL
  • company_profile_id (id2) — varchar — Foreign key → COMPANY_PROFILE_TB.id — NOT NULL
  • type (Field2) — varchar
  • message (Field3) — varchar

COMPANY_INFO_TB (기업 정보)

  • id — varchar — Primary key — NOT NULL
  • reg_number (Field) — varchar

COMPANY_JOB_TB (기업 포스팅)

  • id — varchar — Primary key — NOT NULL
  • company_profile_id (id22) — varchar — Foreign key → COMPANY_PROFILE_TB.company_info_id — NOT NULL
  • posting (Field2) — varchar

COMPANY_MESSAGE_TB (메시지)

  • id — varchar — Primary key — NOT NULL
  • company_profile_id (id2) — varchar — Foreign key → COMPANY_PROFILE_TB.id — NOT NULL
  • applicant_id (id3) — varchar — Foreign key → APPLICANT_PROFILE_TB.id — NOT NULL
  • message (Field3) — varchar

COMPANY_PAYMENT_TB (기업 결제 정보)

  • id — varchar — Primary key — NOT NULL
  • company_profile_id (id22) — varchar — Foreign key → COMPANY_PROFILE_TB.company_info_id — NOT NULL
  • payment_method (Field2) — varchar
  • card_number (Field3) — varchar
  • refund_policy (Field4) — varchar

COMPANY_PROFILE_TB (기업 프로필)

  • id — varchar — Primary key — NOT NULL
  • company_info_id (id2) — varchar — Foreign key → COMPANY_INFO_TB.id — NOT NULL
  • company_name (Field2) — varchar
  • representation_name (Field3) — varchar
  • logo (Field4) — varchar
  • sales (Field5) — varchar
  • item (Field6) — varchar
  • address (Field7) — varchar