newdevs:db:fm
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
newdevs:db:fm [2025/03/28 13:51] – [permacrud xmlns] tmccanna | newdevs:db:fm [2025/07/29 11:26] (current) – [reltype] smayo | ||
---|---|---|---|
Line 18: | Line 18: | ||
* [[evergreen-user: | * [[evergreen-user: | ||
+ | While it was written for the old desktop client, [[xul: | ||
- | ===== Things to Add to This Page: ===== | + | {{METATOC >:xul: |
- | * Information about the main fieldmapper classes | + | |
- | * Example of how to navigate the fieldmapper | + | |
- | * Relationship of the fieldmapper to reports | + | |
- | * Relationship of the fieldmapper to the PostgreSQL database schemas | + | |
Line 94: | Line 91: | ||
=== reltype === | === reltype === | ||
- | These distinctions are to indicate key directionality. They are not to indicate nullability. | ||
- | | + | There are 3 reltypes: |
- | * has_many | + | |
- | * might_have | + | |
+ | * has_many | ||
+ | |||
+ | * might_have | ||
+ | |||
+ | In other words, " | ||
+ | |||
+ | |||
+ | Here's how to decide which reltype attribute to use: | ||
+ | |||
+ | * If the field is not virtual, but backed by a real column: ALWAYS use " | ||
+ | |||
+ | * If the field is virtual, but there' | ||
+ | |||
+ | * If the field is virtual, and there can be any number of rows on the other end of the join: ALWAYS use " | ||
=== key === | === key === | ||
Line 137: | Line 147: | ||
== owning_user == | == owning_user == | ||
+ | |||
+ | ===== Things to Add to This Page: ===== | ||
+ | * Information about the main fieldmapper classes | ||
+ | * Example of how to navigate the fieldmapper | ||
+ | * Relationship of the fieldmapper to reports | ||
+ | * Relationship of the fieldmapper to the PostgreSQL database schemas |
newdevs/db/fm.1743184309.txt.gz · Last modified: 2025/03/28 13:51 by tmccanna