CSE User Management

Viewing page version #1
(Restore this version) 

Modified: 22 February 2021, 05:22   User:  Admin User  → 

  • Database: cs on pghost
    • Core tables:
      • users:
        • base
        • info
        • dirty_login
      • groups:
        • groups
        • members
        • dirty_group
      • acl: 
        • cluster_series, cluster_cluster, cluster_host 
        • pgroup_cluster, pgroup_host
        • group_cluster, group_host
        • login_cluster, login_host
        • nologin_cluster, nologinhost
        • dirty_cluster, dirty_host
    • Other tables:
      • users:
        • course*: Updated automatically from information from Minhal Talmidim
        • chug*: Updated automatically from information from Minhal Talmidim
        • addchug*: Additions to chug*, updated manually
        • note: Used for students not registered through Minhal Talmidim, guest teachers not in Shnaton, non-academic guests , etc.
        • expiration: Expiration dates of various services
        • allocate: Various privileges due to accounts that can be opened and that were owned by accounts that have been closed
        • allusers_dirty: Awaiting update
        • allusers_dirty_log: Log of allusers_dirty
        • guests: Users without ID
        • how2reg:
    • Views: 
      • users:
        • allusers_clean: Per user, cross-table view, including users.guests
        • allusers: Union of allusers_dirty and allusers_clean
        • hotp: Mobile number updated automatically from  Maarachot Meida. Can be changed manually
        • chugs*: Views of chug*
        • courses*: Views of course*
        • icore: Group leaders and expirations of Icore and Astro users