Location: PHPKode > projects > Athena Research Assistant > athena-dev-0.1pre-alpha/doc/dev-notes/db-fields.txt
*************************************************************************
TABLE: ath_users 

ath_users_id
ath_users_username
ath_users_password
ath_users_datecreated
ath_users_realname
ath_users_groupID
ath_users_email
ath_users_studentNUM
ath_users_address
ath_users_phone
ath_users_loginsNUM
ath_users_active
ath_groups_addtoGROUP == 	allows the user to add resources to projects owned by other group members
ath_users_LOCKED ==	ensures existence of a single admin user that can be edited but never deleted, this value is not user accessible and always defaults to 0

*************************************************************************
TABLE: groups

ath_groups_id
ath_groups_name
ath_groups_datecreated

ath_groups_addUSERS
ath_groups_viewUSERS

ath_groups_addGROUPS
ath_groups_viewGROUPS

ath_groups_addPROJECT
ath_groups_addNOTES
ath_groups_addRESRC
ath_groups_addtoPUBLIC == allows group members to add resources to the Public Pool

ath_groups_ADMINISTRATE
ath_groups_LOCKED == this is not user accessible at any time, it ensures existence of 1	admin group at all times, always defaults to 0
*************************************************************************
TABLE: ath_topics

ath_topics_id
ath_topics_name
ath_topics_groupOWNER
ath_topics_datecreated
*************************************************************************
TABLE: ath_resrc

ath_resrc_id
ath_resrc_owner
ath_resrc_format
ath_resrc_title
ath_resrc_author
ath_resrc_url
ath_resrc_year
ath_resrc_lenght
ath_resrc_publisher
ath_resrc_notes
*************************************************************************
TABLE: ath_projects

ath_projects_id
ath_projects_datecreated
ath_projects_contributorID
ath_projects_contributorNAME
ath_projects_groupID
ath_projects_groupNAME
ath_projects_name
ath_projects_shortdesc
ath_projects_keywords
*************************************************************************
TABLE: ath_notes

ath_notes_id
ath_notes_datecreated
ath_notes_heading
ath_notes_text
ath_notes_ownerGROUP
ath_notes_resourceID
Return current item: Athena Research Assistant