project

Tables (8)

Application (지원서 이력 테이블)

  • application_id (Key) — Primary key — NOT NULL
  • company_id (Field2)
  • job_id (Field3)
  • user_id (Field4)
  • cdate (Field5)
  • job_id (Key2) — Foreign key → Job.job_id — NOT NULL

C_address (회사 주소 테이블)

  • address (Field)
  • name (Field2)
  • company_uuid (Key) — Foreign key → Company.company_uuid — NOT NULL

C_fund (회사 투자 정보 테이블)

  • date (Field)
  • round_type (Field2)
  • raised (Field3)
  • currency (Field4)
  • company_uuid (Key) — Foreign key → Company.company_uuid — NOT NULL

Company (회사 정보 테이블)

  • company_uuid (Key) — Primary key — NOT NULL
  • cdate (Field)
  • mdate (Field2)
  • found_date (Field3)
  • employee_count (Field4)
  • view_count (Field5)
  • follow_count (Field6)
  • reference_count (Field7)

J_address (근무지 테이블)

  • name (Field)
  • address (Field2)
  • job_id (Key2) — Foreign key → Job.job_id — NOT NULL

J_bookmark (채용공고 북마크 이력 테이블)

  • cdate (Field)
  • uesr_id (Field3)
  • job_id (Key) — Foreign key → Job.job_id — NOT NULL

Job (채용공고 테이블)

  • job_id (Key) — Primary key — NOT NULL
  • company_uuid (Field)
  • cdate (Field2)
  • mdate (Field3)
  • job_field (Field4)
  • career_type (Field5)
  • start_date (Field6)
  • end_date (Field7)
  • allow_remote (Field8)
  • can_show_salary (Field9)

log (유저 로그 기록 테이블)

  • user_id (Field)
  • url (Field2)
  • timestamp (Field3)
  • date (Field4)
  • response_code (Field5)
  • method (Field6)