You are here: ListManager Programmer's Guide > ListManager Tables > Configuration > topics_

Summary of the "topics_" fields in ListManager

 

The topics_ table organizes lists together under a particular site. Multiple lists can be associated with the same topic, and every topic has exactly one site.

 

Primary key: Title_

 

 

Field Name

Description

Version Added

Admin_

Administrator responsible for this list (link to people) (varchar(50), NULL)

 

Comment_

Comment about this topic (link to document) (varchar(200), NULL)

 

Desc_

Short description of this topic (link to document) (varchar(200), NULL)

 

DescLong_

Long description of this topic (link to document) (varchar(200), NULL)

 

Hidden_

Controls whether this topic is hidden in the web (char(1), NOT NULL)

 

Keywords_

Keywords that describe this topic (varchar(200), NULL)

 

SiteName_

What site does this belong to (varchar(30), NOT NULL)

 

SponsOrg_

Organization that is sponsoring this topic (link to document, type is organization) (varchar(200), NULL)

 

Title_

Unique title of this topic (varchar(50), NOT NULL)

 

URLLogo_

URL to GIF/JPEG topic logo (varchar(200), NULL)

 

URLOrgLogo_

URL to a gif/jpeg logo for this organization (varchar(100), NULL)

 

URLTopic_

URL to topic's homepage (varchar(100), NULL)