Subjects A-Z Types A-Z E-Journals How Do I...? Search
ABOUT THIS SITE
Database Structure

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.

 

Table Name Column Name Data Type Nulls OK
language_d language numeric (3) NO
code varchar (2) NO
description varchar (255) NO
status char (1) YES
notes note numeric (4) NO
resource numeric (4) NO
description varchar (255) NO
profile_attribute profile_attribute_id numeric (4) NO
emp_id_number int (4) NO
attribute varchar (255) NO
value varchar (255) NO
status int (4) NO
profile_linkcheck linkcheck numeric (4) NO
emp_id_number int (4) NO
query text (16) NO
email_address varchar (129) NO
email_subject varchar (64) NO
profile_subject emp_id_number int (4) NO
subject numeric (4) NO
profile_type emp_id_number int (4) NO
type numeric (4) NO
resource_descriptor description numeric (4) NO
resource numeric (4) NO
attribute varchar (255) NO
value varchar (255) NO
entered_by int (4) NO
entered_date smalldatetime (4) NO
status int (4) NO
se_creators resource numeric (4) NO
creator numeric (4) NO
se_creators_d creator numeric (4) NO
description varchar (125) NO
se_help relation numeric (4) NO
resource numeric (4) NO
relationship varchar (80) NO
location varchar (200) NO
se_local_authors author numeric (4) NO
name varchar (80) NO
location varchar (200) YES
emp_id_number int (4) YES
se_resource_hits resource numeric (4) NO
hits int (4) NO
hits_date smalldatetime (4) NO
se_resources resource numeric (4) NO
title varchar (255) NO
location varchar (255) YES
creator numeric (3) YES
local_author numeric (3) YES
description text (16) YES
record_entered_date smalldatetime (4) NO
record_description_update smalldatetime (4) NO
icon_library_only bit (1) NO
icon_UCSD_only bit (1) NO
icon_DBA bit (1) NO
icon_starters bit (1) NO
icon_bithack1 bit (1) NO
icon_bithack2 bit (1) NO
icon_bithack3 bit (1) NO
icon_bithack4 bit (1) NO
short_description varchar (255) YES
bib_number varchar (10) YES
emp_id_number int (4) YES
trial_end_date smalldatetime (4) YES
review_date smalldatetime (4) YES
spider_depth int (4) YES
location_status int (4) YES
location_status_date smalldatetime (4) YES
hits int (4) YES
hits_date smalldatetime (4) YES
language numeric (3) YES
se_subjects resource numeric (4) NO
subject numeric (4) NO
weight numeric (4) YES
entered_by int (4) YES
entered_date smalldatetime (4) YES
featured numeric (4) YES
se_subjects_d subject numeric (4) NO
description varchar (80) NO
status char (1) YES
se_types resource numeric (4) NO
type numeric (4) NO
sort numeric (4) YES
entered_by int (4) YES
entered_date smalldatetime (4) YES
se_types_d type numeric (4) NO
description varchar (80) NO
searchwords resource numeric (4) NO
word varchar (80) NO
subject_owner subject numeric (4) NO
email_address varchar (129) NO
subjects_h h_id varchar (255) NO
subject numeric (4) YES
subjects_hd h_id varchar (255) NO
description varchar (80) NO
Back to Top
Official UCSD web site
© Copyright 2000-2001, UCSD, All Rights Reserved. This site may not be reproduced.
UCSD Libraries, 9500 Gilman Drive #0175, La Jolla, CA 92093, 858-534-3336
Email UCSD Libraries Webmaster