************************************************************************* 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