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_
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) |