Open m-flak opened 6 months ago
Note: The db will need to be dropped 😄.
CREATE INDEX node_range_index_applicant_interviewingwith IF NOT EXISTS FOR (a:Applicant) ON (a.interviewingWith)
CREATE INDEX node_range_index_applicant_interviewdate IF NOT EXISTS FOR (a:Applicant) ON (a.interviewDate)
CREATE TEXT INDEX node_text_index_job_status IF NOT EXISTS FOR (j:Job) ON (j.status)
CREATE INDEX rel_range_index_hasappliedto_rejected IF NOT EXISTS FOR ()-[r:HAS_APPLIED_TO]-() ON (r.rejected)
interviewDate
IS_INTERVIEWING_FOR
Applicant
Note: The db will need to be dropped 😄.
Indexes
CREATE INDEX node_range_index_applicant_interviewingwith IF NOT EXISTS FOR (a:Applicant) ON (a.interviewingWith)CREATE INDEX node_range_index_applicant_interviewdate IF NOT EXISTS FOR (a:Applicant) ON (a.interviewDate)CREATE TEXT INDEX node_text_index_job_status IF NOT EXISTS FOR (j:Job) ON (j.status)CREATE INDEX rel_range_index_hasappliedto_rejected IF NOT EXISTS FOR ()-[r:HAS_APPLIED_TO]-() ON (r.rejected)Relationships
interviewDatefromIS_INTERVIEWING_FORand assign/query it directly on anApplicant.Models
interviewDateinApplicant