Ilc User Schools
Table Description
The ILC_USER_SCHOOLS table provides the association between users and schools. This junction table enables users (students, teachers, administrators) to be assigned to one or more schools within a district or organization, supporting multi-school deployments and user transfers.
Key Business Uses: - Managing user-to-school assignments across districts - Supporting users who belong to multiple schools - Enabling school-level reporting and access control
Primary Relationships: - Links to users via USER_ID (ilc_users) - References schools via SCHOOL_ID (ilc_schools)
Table Overview
This table contains 5 columns.
Quick Navigation
Column Definitions
CREATED_AT
Business Definition
The CREATED_AT column stores created at information for user schools records. Its business purpose is to track the creation timestamp for audit trails and temporal analysis. Users and analysts would use this column to filter, join, and aggregate user schools data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
ID
Business Definition
The ID column primary key - unique user-school association identifier. Its business purpose is to serve as the primary key ensuring unique identification of each user schools record and enable referential integrity across related tables. Users and analysts would use this column to filter, join, and aggregate user schools data for reporting and analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
SCHOOL_ID
Business Definition
The SCHOOL_ID column foreign key to ilc_schools(id) - school. Its business purpose is to link this user schools record to related school data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate user schools data for reporting and analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
UPDATED_AT
Business Definition
The UPDATED_AT column stores updated at information for user schools records. Its business purpose is to track the last modification timestamp for audit trails and temporal analysis. Users and analysts would use this column to filter, join, and aggregate user schools data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
USER_ID
Business Definition
The USER_ID column foreign key to ilc_users(id) - user. Its business purpose is to link this user schools record to related user data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate user schools data for reporting and analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT