Database fileldnames
Version 0.9 17.03.2021
Fixed fieldnames
Common fieldnames
| Current | Suggestion | Type | Description |
|---|---|---|---|
| nr | id | int | Unique row identifier |
| tunnus | account | int | What account owns the row (In multiaccount tables). |
| luotu | created_at | timestamp | Create time |
| muokattu | modified_at | timestamp | Last modification time |
| luoja_nr | created_by | int | User who has created |
| muokkaaja_nr | modified_by | int | User who has last modified |
| poistettu | deleted | bool | Row has been deleted (moved to trash) |
| valid_from | timestamp | From this time on | |
| valid_until | timestamp | To this time |
Fieldnames for certain use.
| Current | Suggestion | Type | Description |
|---|---|---|---|
| tyyppi | type | text | |
| nimi | name | text | Technical name |
| otsikko | title | text | Visible title |
| kuvaus | description | text | Description text |
| dokumentointi | documentation | text | Notes for documentation |
| oikeustaso | privilege | int | Default Privilege for the row |
| jarjestys | order | int | Custom order for rows in table |
| asetukset | preferences | text | Additional preferences (XML, Json..) |
| asetus | preferences | text | |
| versio | version | decimal | Version number |