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