ShiftTable::getMap

static function getMap()
{
	return [
		(new FieldsIntegerField('ID'))
			->configurePrimary(true)
			->configureAutocomplete(true)
		,
		(new FieldsStringField('NAME'))
			->configureDefaultValue(function () {
				return '';
			})
		,
		(new FieldsIntegerField('BREAK_DURATION'))
			->configureDefaultValue(function () {
				return 0;
			})
		,
		(new FieldsIntegerField('WORK_TIME_START'))
			->configureDefaultValue(function () {
				return 0;
			})
		,
		(new FieldsIntegerField('WORK_TIME_END'))
			->configureDefaultValue(function () {
				return 0;
			})
		,
		(new FieldsStringField('WORK_DAYS'))
			->configureDefaultValue(function () {
				return '';
			})
		,
		(new FieldsIntegerField('SCHEDULE_ID'))
		,
		(new FieldsBooleanField('DELETED'))
			->configureValues(static::DELETED_NO, static::DELETED_YES)
			->configureDefaultValue(false)
		,
		# relations
		(new FieldsRelationsReference(
			'SCHEDULE',
			ScheduleTable::class,
			Join::on('this.SCHEDULE_ID', 'ref.ID')->where('this.DELETED', static::DELETED_NO)
		))
			->configureJoinType('INNER')
		,
		(new FieldsRelationsReference(
			'SCHEDULE_WITH_ALL_SHIFTS',
			ScheduleTable::class,
			Join::on('this.SCHEDULE_ID', 'ref.ID')
		))
			->configureJoinType('INNER')
		,
	];
}