Sponsorship Database

Main tables

sponsor
sponsor_id 
nameName
descriptionDescription
departmentDepartment
addressPhysical mail
useridIndividual sponsor
flagFirst4 free IP
flagDiscretionaryDean's grace
flagNoPaperDon't print
flagNoWebDon't publish
flagNoChargeDon't charge
flagAutomaticBill automatically
 
1-to-n 
billcode
billcode_id 
nameFS-number, or other
descriptionPurpose
<< sponsor_id 
 
1-to-n 
class
class_id 
nameClassname
descriptionPurpose
purposeAdmin,Research,etc.
flagNoSubsidyNo Dean's subsidy
<< billcode_id 
 
1-to-n 
member
member_id 
nameuserid(s)
startsDate
endsDate
<< class_id 
 
1-to-n 
mailalias
mailalias_id 
namealias@host
descriptionPurpose
startsDate
endsDate
targetsAddress(es)
<< class_id 
1-to-n 
printing
printing_id 
nameQuota file
descriptionPurpose
startsDate
endsDate
print_quotaPages
accountIf not Class
<< class_id 
1-to-n 
computing
computing_id 
nameHostname
descriptionPurpose
startsDate
endsDate
disk_quotaMbytes
groupsUnix groups
<< class_id 

Auxiliary tables

References