Users Data Dictionary

The Users database table is global, meaning that users data is stored in a singular table for all years. Changes to global fields in one year will carry across all years.

• Column Header Definitions

Table Name	Field Name	Description	Default Value	Is Nullable	Data Type	Char Limit
users	admin_email_sms_enabled	Enable Emails/Texts for Admin Processes (Yes = 1, No = 0)	1		tinyint
users	admin_notifications_enabled	Enable Notifications for Admin Processes(Yes = 1, No = 0)	1		tinyint
users	all_programs	All program access enabled (Yes = 1, No = 0)	0		tinyint
users	all_programs_grades	All program grade access enabled (All or Null)		yes	json
users	created_at	Date and time the student record is created		yes	datetime
users	email	User's email		yes	varchar	255
users	email_enabled	Enable Email Notifications (Yes = 1, No = 0)	0		tinyint
users	first_name	User's first name		yes	varchar	255
users	group_id	Unique ID assigned to the User Group associated with the user		yes	int
users	id	Unique ID assigned by the system to each user			bigint
users	is_admin	Admin access enabled (Yes =1, No = 0)	0		tinyint
users	is_parent	Guardian access enabled (Yes =1, No = 0)	1		tinyint
users	language	User's preferred language	en	yes	enum	2
users	last_name	User's last name		yes	varchar	255
users	legacy_id	Unique ID from the legacy system that corresponds to the same field in Enroll		yes	int
users	organization_id	Unique ID assigned to each Enroll customer			int
users	password	User's password			varchar	255
users	phone	User's phone		yes	varchar	255
users	provider	Used for SSO		yes	varchar	255
users	provider_domain	Used for SSO		yes	varchar	255
users	provider_id	Used for SSO		yes	varchar	255
users	sms_enabled	Enable SMS Text Notifications (Yes = 1, No = 0)	0		tinyint
users	system_internal	SchoolMint internal admin access enabled (Yes = 1, No = 0)	0		tinyint
users	updated_at	Most recent date and time that the student record was updated		yes	datetime

Column Header Definitions

• Table Name: Name of database table displayed in Enroll when selecting fields
• Field Name: Name of field displayed in Enroll when selecting fields
• Description: What data is stored in the field
• Default Value: Value automatically assigned by the system as a starting value
• Is Nullable: Field is permitted to have a NULL value
• Data Type:
  • datetime: stores date and time as YYYY-MM-DD HH:MM:SS using 24 hour clock
  • decimal: stores numerical data and performs calculations with precise decimal values
  • double: a way to store decimal numbers with a higher degree of precision
  • enum: enumerated, a set of named values (ex: offered, waiting)
  • int: integer, whole numbers like 155, 0, -20, supports a large range
  • json: text based format that stores/transmits data to be displayed on a web page
  • text: variable length data that supports a large maximum length
  • time: stores time of day as HH:MM:SS using 24 hour clock 
  • timestamp: stores date and time as YYYY-MM-DD HH:MM:SS using 24 hour clock
  • tinyint: small range of integers
  • varchar: variable length character that supports alphanumeric values
• Char Limit: Character limit on the field that cannot be exceeded