topics_

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)