ValueConnect

Tables (5)

candidate (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • consultant_id (Key2) — Foreign key → consultant.id — NOT NULL
  • career (Field)
  • university (Field2)

candidate_position_apply (Untitled4)

  • position_id (Key) — Foreign key → position.id — NOT NULL
  • candidate_id (Key2) — Foreign key → candidate.id — NOT NULL
  • status (Field)

company (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

consultant (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

position (Untitled)

  • id (Key) — Primary key — NOT NULL
  • company_id (Key2) — Foreign key → company.id — NOT NULL
  • consultant_id (Key3) — Foreign key → consultant.id — NOT NULL
  • position (Field2)
  • job_description (Field3)