This shows you the differences between two versions of the page.
Both sides previous revision
Previous revision
|
|
devel:documentation:conventions:dev:database-conventions [2019/06/10 10:27] tomiskar |
devel:documentation:conventions:dev:database-conventions [2019/06/11 10:59] (current) tomiskar [Conventions of database design] |
* ''id'' - identifier | * ''id'' - identifier |
* ''created'', ''creator'', ''modifier'', ''modified'', ''creator\_id'', ''modifier\_id'', ''original\_creator'', ''original\_creator\_id'', ''original\_modifier'', ''original\_modifier\_id'' - audit informations | * ''created'', ''creator'', ''modifier'', ''modified'', ''creator\_id'', ''modifier\_id'', ''original\_creator'', ''original\_creator\_id'', ''original\_modifier'', ''original\_modifier\_id'' - audit informations |
* ''transaction\_id'' - "User" transaction identifier - entity was saved in this context (batch). | * ''transaction\_id'' - "User" [[..:..:audit:dev:audit#user_transaction|transaction identifier]] - entities was saved in this context (batch). It's not related to database transaction. |
* ''realm\_id'' - owner organization | * ''realm\_id'' - owner organization |
* ''name'' - name, display name | * ''name'' - name, display name |