higher-match-erd

Tables (4)

tb_job_posts

  • id — BIGINT — Primary key — NOT NULL
  • job_type — VARCHAR
  • name (Field7) — VARCHAR
  • address (Field8) — VARCHAR
  • addressDetail (Field9) — VARCHAR
  • created_date_time (Field3) — DATETIME
  • updated_date_time (Field4) — DATETIME
  • deleted_date_time (Field5) — DATETIME
  • deleted (Field6) — TINYINT
  • employer_id — BIGINT — Foreign key → tb_users.id — NOT NULL

tb_match_result

  • id — BIGINT — Primary key — NOT NULL
  • resume_id (Field2)
  • created_date_time (Field3)
  • updated_date_time (Field4)
  • deleted_date_time (Field5)
  • deleted (Field6)
  • job_post_id — BIGINT — Foreign key → tb_job_posts.id — NOT NULL

tb_pharmacy_preferences (tb_pharamacy_preferences)

  • id — BIGINT — Primary key — NOT NULL
  • address — VARCHAR
  • prefer_nearest — INT
  • prefer_computer (Field3) — INT
  • prefer_experience (Field4) — INT
  • work_type — VARCHAR
  • job_post_id — BIGINT — Foreign key → tb_job_posts.id — NOT NULL

tb_users

  • id — BIGINT — Primary key — NOT NULL
  • role — VARCHAR