help Table (302)

• 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 ●

help table relationship diagram

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.