Foreign Key to TYPO3 Frontend User
How can I set a ForeignKey to the TYPO3 FrontendUsers in the Extension Builder?
Do I have to set the param map to existing table? oder make a relation?
What I want to do:
I've got a Model (People) with its own fields and values. and now I want to have a new Releation between this Model and the TYPO3 FE Users
PeopleNr = fe_user with uid 123
Note: As stated in other question creating relations between tables/models doesn't require adding foreign keys
I'm not quite sure what do you need it for, but here's description of two most common cases (screenshot shows how to achieve each case with Extension Builder)
Creating relation to FrontendUser model / fe_user table
In TYPO3 ver. 6.2 fe_user has a model as well: \TYPO3\CMS\Extbase\Domain\Model\FrontendUser, you can just add this as common relation in Builder modeling tool (fig. 2 at screenshot) in the field \Fully\Qualified\Classname (you need to Show advanced fields to set it (fig. 1) use this FrontendUser and it will create proper SQL and TCA definitions.
Real extending FrontendUser (FU) model
On the other hand if your People* model just extends the fe_user table, because you want to reuse existing fe_user table for your people, you can also extend FrontendUser model for real (fig. 3) in that case you'll inherit all getters, setters from FU etc. and you won't need to write them yourself.
In such case your model will be a separate type of fe_user, the discriminator field is by default: tx_extbase_type and builder will add new type like Tx_YourExt_Employee
* note: For model names you should use singular form i.e Man instead of People
- sql:need to change constraint on rename table?
- Django - dynamically update a count model field when related objects are added or removed
- How to truncate a foreign key constrained table?
- Migration: Cannot add foreign key constraint
- Multiple foreign keys from one table to same field in another table in Laravel
- PostgreSQL array of elements that each are a foreign key
- Generic Foreign Key on unsaved model in Django
- How do I automatically insert the auth user id when creating a new model with a foreign key in Laravel?
- MySQL DROP all tables, ignoring foreign keys
- get unprocessed rows that have no association in processed table
- Delete rows with foreign key in PostgreSQL
- Add Foreign Key to existing table
- Laravel Relationship Using An OR Condition on the joining field
- How to change a default setting temporarily in PostgreSQL?
- JPA is duplicating a column when inserting. Multiple columns as primary and foreign key
- PostgreSQL zero-or-one to zero-or-one relationship
- How to resolve circular foreign key constraints with NOT NULL in Hibernate
- Does Foreign Key improve query performance?
- Get ID from Master table When Doing Input for Detail Table (Laravel 8)
- How to add a link to a foreign key object in the Django admin?
- Does SQL Server ALWAYS enforce referential integrity with foreign key constraints?
- MySQL Cannot Add Foreign Key Constraint
- How to select rows with no matching entry in another table?
- Stuck at (erno: 150 "Foreign key constraint is incorrectly formed,")
- How to make a relation between two tables without foreign key
- How can i create a relation beetwen two models and pass the model info on to the view through the controller?
- How can I know if a table column is a foreign key in Laravel through Model?
- Enforcing two M2M relationships with FK with SQL Server
- In Yii2, is it possible to get the unique objects in a hasMany relation via another hasMany relation?
- Cascade Delete in SqlAlchemy One-to-Many relationship made without relationships()