중급프로젝트 3팀

테이블 (10)

application (Untitled)

  • application_uuid (Key) — 기본 키 — NOT NULL
  • user_uuid (Key4) — 외래 키 → user.user_uuid — NOT NULL
  • company_uuid (Key3) — 외래 키 → company.company_uuid — NOT NULL
  • job_uuid (Key2) — 외래 키 → job.job_uuid — NOT NULL
  • cdate (Field4)

company (Untitled2)

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

companyaddress (Untitled3)

  • company_uuid (Key) — 외래 키 → company.company_uuid — NOT NULL
  • name (Field)
  • address (Field3)

companyfund (Untitled6)

  • company_uuid (Key) — 외래 키 → company.company_uuid — NOT NULL
  • found_date (Field)
  • round_type (Field2)
  • raised (Field3)
  • currency (Field4)

job (Untitled4)

  • job_uuid (Key) — 기본 키 — NOT NULL
  • company_uuid (Key2) — 외래 키 → company.company_uuid — NOT NULL
  • cdate (Field)
  • mdate (Field2)
  • job_field (Field3)
  • career_type_string (Field4)
  • start_date (Field5)
  • end_date (Field6)
  • allow_remote (Field7)
  • can_show_salary (Field8)
  • Field9

jobaddress (Untitled7)

  • job_uuid (Key) — 외래 키 → job.job_uuid — NOT NULL
  • name (Field)
  • address (Field3)

jobbookmark (Untitled5)

  • user_uuid (Key2) — 외래 키 → user.user_uuid — NOT NULL
  • job_uuid (Key) — 외래 키 → job.job_uuid — NOT NULL
  • cdate (Field)

log_2022 (Untitled8)

  • user_uuid (Key) — 외래 키 → user.user_uuid — NOT NULL
  • URL (Field2)
  • timestamp (Field3)
  • response_code (Field4)
  • method (Field5)

log_2023 (Untitled9)

  • URL (Field2)
  • timestamp (Field3)
  • response_code (Field4)
  • method (Field5)
  • user_uuid (Key) — 외래 키 → user.user_uuid — NOT NULL

user (Untitled10)

  • user_uuid (Key) — 기본 키 — NOT NULL