Footprints Data Model

Table
Name portal
Comment A portal in the FootPrints 12 User Interface.

Column
Name Datatype Comment Is PK Is FK
portal_id bigint The automatically generated primary key of the portal table. Yes No
portal_guid varchar(255) The value of a Portal, stored as a string. No No
portal_name varchar(255) Name of the portal. No No
portal_descr varchar(1024) Portal Description. No No
portal_theme varchar(255) Theme name to be used in Portal rendering. No No
portal_logo_guid varchar(255) Logo to be displayed No No
portal_active_console_id bigint A Foreign Key to the Console table. No Yes
is_sys bit Indicates if Is System or user custom portal. No No
allow_anonymous_access bit Indicates if Allow Anonymous Access. No No