pacx rel create nn

Creates a many-to-many relationship between two tables

This command reduces to almost 0 the effort required to create implicit or explicit many-to-many relationships between Dataverse tables.

An implicit many-to-many relationship is the classic many-to-many relationship, where the relationship table is created automatically by Dataverse when you create the relationship between two tables.

An explicit many-to-many relationship is a relationship where you create the relationship table manually, and then you create the relationship between the relationship table and the two tables you want to relate. Explicit many-to-many relationships can have a lot of advantages (e.g. you can add additional attributes in the relationship table), and tipically have a primary column of type autonumber. If you don't specify explicit information for the relationship talbe, the command will create it assuming that:

• The entity schema name is the concatenation between the schema names of the two tables to relate (publisher prefix removed automatically)
• The display name is the concatenation between the display names of the two tables to relate, separated by dash -
• The primary column is an autonumber with format {initial of table1}{initial of table2}-{SEQNUM:10} (e.g. if the two tables are Account and Contact, the primary column value will be AC-0000000001)
• Audit for the intersection table is disabled
• The intersection table ownership is UserOwned
• The primary column is not required (it's autogenerated)
• The lookup attributes against the two tables have display name equal to the display name of each table
• The lookup attributes against the two tables have schema name equal to the schema name of each table + id suffix
• The lookup attributes against the two tables have Referential/Restrict behavior

Thus, if you have two tables account and contact, and you want to create a many-to-many relationship between them, you can simply type:

pacx rel create nn -t1 account -t2 contact
 --- or ---
pacx rel create nn -t1 account -t2 contact --explicit

All other arguments are optional.

If you are creating an implicit many-to-many relationship, the schema name of the relationship is built concatenating the schema names of the two tables to relate (publisher prefix removed automatically). There are some cases where this concatenation is not enough to create a unique schema name for the relationship table. In this case, you can use the --suffix option to specify a suffix to apply on the relationship schema name, or you can use --schemaName option to explicitly indicate a custom schema name for the relationship.