Database References by Feature

• Administrative
• Environment
• Collaborative

Database List

Administrative

Traffic-Based Link Suggestion	(purpose)	(database)
page_reference, site_reference	page/site for which traffic trend is recorded	Suggestion
traffic_common_site	common sites traveled by other user who have also been to this particular page/site	Suggestion

Content-Based Link Suggestion	(purpose)	(database)
page_reference, site_reference	page/site for which content is analyzed	Suggestion
content-compared_site	sites with content relevant to this site	Suggestion

Content Update Reminder	(purpose)	(database)
page_reference	page for which content may have gotten stale	Site Status
update_last	last date of update	Site Status
update_frequency	time length for update reminders	Site Status
update_contact	user to be notified when page needs update	Site Status

User Email Alert	(purpose)	(database)
visitor_id	identification of visitor	Visitor
visitor_password	password of visitor	Visitor
visitor_email	email address of visitor	Visitor
visitor_interest	topics in the visitor's interest	Visitor
visitor_email_frequency	time length for the update reminders	Visitor

Access Control/ Permission	(purpose)	(database)
user_id	identification of user	GWD User
user_password	user's password for authentication	GWD User
user_group	work group affiliations	GWD User
user_status	types of permissions (read&edit vs. read&annotate vs. forbidden)	GWD User

Version Control	(purpose)	(database)
page_reference	page being referenced	Version Control
version_number	number of the version	Version Control
version_copy	copy of past versions of the page	Version Control
version_creator	user who had created a particular version	Version Control
version_date	date of version	Version Control
version_time	time of version	Version Control

Backup	(purpose)	(database)
page_reference	page being backed-up	Backup
backup_copy	last backed-up copy of the page	Backup
backup_date	date of back-up	Backup
backup_time	time of back-up	Backup

Quality Control	(purpose)	(database)
page_reference	page being checked for quality	GWD Website
page_template	style guide / template associated with the referenced page	GWD Website
quality_authority	user/editor with the authority to authenicate (defaults to any user) page before publication	GWD Website
quality_authentication	whether or not site has received valid authentication for publication	GWD Website

Labor Tracking	(purpose)	(database)
page_reference, site_reference	page/site analyzed for labor and time usage	Site Status
labor_group	group associated with the page/site	Site Status
labor_time	overall amount of time spent on maintaining the page/site	Site Status
labor_user	who has been using the time	Site Status
labor_user_time	amount of time spent on maintaining the page/site by the particular user	Site Status

[top]

Environment Features

Remote Access	(purpose)	(database)
user_id	identification of user	GWD User
user_password	password authentification of the user	GWD User

[top]

Collaborative Features

Real Time Collaboration	(purpose)	(database)
page_reference; site_reference	page/site of the real time collaboration	Real Time
realtime_user	user involved in the collaboration	Real Time
realtime_message	message to another user	Real Time
realtime_date	date of exchange	Real Time
realtime_time	time of exchange	Real Time

Annotation	(purpose)	(database)
page_reference	page being annotated	Annotation
annotation_user	user leaving note	Annotation
annotation_message	note to be left	Annotation
annotation_location	location of note	Annotation
annotation_date	date of note	Annotation
annotation_time	time of note	Annotation

Replication/Reconciliation	(purpose)	(database)
page_reference	page being referenced	Reconcilliation
page_replicated	page replicated for editting	Reconcilliation
page_replicated_user	user of the page replicated for editting	Reconcilliation
page_reconciliation	page merged after editting	Reconcilliation
page_reconciliation_flag	flags on commonly revised areas unable to be merged	Reconcilliation
page_reconciliation_date	date of reconciliation	Reconcilliation
page_reconciliation_time	time of reconciliation	Reconcilliation

Style Guide / Template Management	(purpose)	(database)
site_styleguide	styleguide for the website	GWD Website
template_reference	reference to the template	Template
template_content	template for particular sites	Template
page_template	pages/site with the particular template in use	GWD Website
page_template_flag	flags for areas not following template	GWD Website

[top]