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