middle_project1

Tables (8)

Untitled (company address)

  • Key (company_id) — Foreign key → company.Key — NOT NULL
  • Field (address1)
  • Field (name)

Untitled (company_funding)

  • Key (company_id) — Foreign key → company.Key — NOT NULL
  • Field (date)
  • Field (round_type)
  • Field (raised)
  • Field (currency)

Untitled (job)

  • Key (id) — Primary key — NOT NULL
  • Key (company_id) — Foreign key → company.Key — NOT NULL
  • Field (cdate)
  • Field (mdate)
  • Field (job_field)
  • Field (career_type_string)
  • Field (start_date)
  • Field (end_date)
  • Field (allow_remote)
  • Field (can_show_salary)

Untitled (job address)

  • Key (job_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (name)
  • Field (address1)

Untitled (job bookmark)

  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (recruit_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (cdate)

Untitled (application)

  • Field (id)
  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (job_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (cdate)

Untitled (log)

  • Key (user_id) — Primary key — NOT NULL
  • Field (timestamp)
  • Field (date)
  • Field (path)
  • Field (response_code)
  • Field (method)

company

  • Key (id) — Primary key — NOT NULL
  • Field (cdate)
  • Field2 (mdate)
  • Field (found_date)
  • Field (employee_count)
  • Field (view_count)
  • Field (follow_count)
  • Field (reference_count)