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