Triggers table b/a iud r purpose -------------------------- --- --- - ------------------------------------------------- AccessGroup b iu r maintain id column AdminTeam b iu r maintain id column validate email address AdminTeam_Member - - - --- AdminTeam_Orgs - - - --- AdminTeam_Owner a ud - enforce adminteam must have at least one owner Consultant - - - --- DHCPapplication a u r maintain DHCPoption_Application.label column (FK) DHCPoption b iu r maintain id column DHCPoption_Application - - - --- DHCPservice b iu r maintain id column DHCPservice_Options - - - --- Delegation b iu r validate nameserver name Domain b u r disallow id change b iu r maintain id column disallow domain change fill domain using fullname() disallow delegation if alias exists a d - enforce delete via the name table Domain_Owner a ud - enforce domain must have at least one owner GlobalDefault b iu r maintain id column Interface b iu r maintain id column lc HW_address b u r disallow changing the node value [to ensure name.related_node integrity] Interface_DHCPoptions - - - --- InterfaceType a u r maintain Interface.type column IPaddress b iu r maintain id column maintain derived IP column IPaddress is not subnet or broadcast IPaddress is in an existing IP address space b u r disallow changing non-null interface or IPCnode values [to ensure name.related_node integrity] IPaddressSpace b iu r maintain id column maintain derived IP columns check min/max prefix lengths a iu - make sure address spaces don't overlap b d r save deleted address space info a d - check for address space still in use remove reserved addresses in deleted address spaces IPaddressSpace_DHCPoptions - - - --- IPaddressSpace_Owner - - - --- - LNA a ud - enforce user must be LNA for at least one dept DROPPED LimitedNames - - - --- Location b iu r maintain id column Log b iu r maintain id column LogIPaddress b iu r maintain derived IP column LogName - - - --- Make a u r maintain Model.make column (FK) Model b iu r maintain id column ModelType a u r maintain Model.modeltype column (FK) MXrecord a d - delete MX names not in MXrecord MXrecord b iu r enforce MX RDATA rule Name b iu r maintain id column b iu r maintain fullname and fullname_lc b i r disallow setting related_node b u r disallow domain change b u r disallow anything but case changes to names of label 'Domain'. a u s if name.name changed and label='Domain', update domain.domain and children's name.fullname. a iu s set related_node based on columns ipaddress, aliasee, interface, node NameType b d r nice error message for deleting type in use Network b iu r maintain id column Network_DHCPoptions - - - --- Network_Owner a ud - network must have at least one owner Node b iu r maintain id column Node_Admin b iu r maintain id column a ud - enforce node must have at least one admin Node_NodeType - - - --- Node_OS a ud - enforce node must have at least one os Node_Owner a ud - enforce node must have at least one owner Node_Service - - - --- Node_User - - - --- NodeTag - - - --- NodeType a u r maintain Node_NodeType.type column (FK) OS a u r maintain Node_OS.os column (FK) Organization b iu r maintain id column Owner b iu r maintain id column Person b iu r maintain id column maintain users.netid (deferred to update s/w) ResName b iu r maintain id column ResName_Owner - - - --- Service a u r maintain Node_Service.service column (FK) State a u r maintain Node.state column (FK) TXTrecord b u r disallow id change TXTrecord a d - enforce delete via the name tables TXTrecord_Admin a ud - enforce text record must have at least one admin TXTrecord_Owner a ud - enforce text record must have at least one owner TXTvalue b iu r maintain id column TXTvalue_Admin - - - --- Users b u r disallow id change b iu r disallow netid change fill netid from person.netid normalize starting address Users_AccessGroup - - - --- Users_NodeTemplate - - - --- Users_Owner a ud - enforce active users must have at least one ownership security group VLANarea a u r maintain Network.vlan_area column (FK)