|
Listed below are the tables that make up our database with the datatype
information for each column. The core of our metadata is the se_resources
table, which represents an individual Resource. Associated with this Resource
are any number of rows from se_subjects (Subjects), se_types (Types),
searchwords (Keywords), se_help (Help Links), and resource_descriptor
(Attribute/Value pairs). se_subjects and se_types each have corresponding
tables (se_subjects_d and se_types_d, respecitively) that associate
human-intelligible names with the Subject and Type values.
The subjects_h and subjects_hd tables describe a hierarchy of Subjects,
which are mainly used in building the browseable hierarchies of Ejournals and
Subjects. The subject_owner table controls which author's email address is
listed in the feedback link at the bottom of Subject pages, so the feedback
can go directly to the author responsible for maintaining the page's Resources.
There are also three tables that control our author tools: profile_subject,
profile_type, and profile_linkcheck.
The diagram of
tables shows the relationships between the tables.
|