help Table (302)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
This table contains the help pages.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| name | The name for this help page. | String(64) | ● |
| title | The title for this help page. | String(255) | ● |
| parent_id | The id of the parent help page. NULL or -1 if this is a toplevel helppage. | FK help | ● |
| language | A string indicating the language for this helppage ('no' or 'en'). | String(5) | ● |
| sort_order | The sort-order for this helppage when listed among its siblings. | Int | ● |
| module_id | The id of the module, if this page is the description for a module.. | Int | |
| application_area_id | The id of the application_area, if this page is the description for a application_area.. | Int | |
| screen_id | The id of the screen, if this page is the description for a screen.. | Int | |
| body | The actual body for the helppage. HTML format. | Clob | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| parent_id | FK | Index |
| module_id | Int | Index |
| application_area_id | Int | Index |
| screen_id | Int | Index |
Relationships
| Table | Description |
|---|---|
| help | This table contains the help pages. |
Replication Flags
- None
Security Flags
- No access control via user's Role.