multiple unique column
good evening, I have 3 tables users, jobs and finally the pivot table user_job with the pivot fields "start_date" and "end_date" and also
If possible, I would like some help to respect
thank you in advance for your help
$table->unique('user_id','job_id','start_date') Repeater::make('userJobs')
->label('')
->relationship()
->schema([
Select::make('job_id')
->options(Job::all()->pluck('name', 'id'))
->required()
->unique('user_job',ignoreRecord: true),
DatePicker::make('date_start')
->required()
->format('d/m/Y'),
DatePicker::make('date_end')
->format('d/m/Y'),
]),If possible, I would like some help to respect
$table->unique('user_id','job_id','start_date')thank you in advance for your help
