LINGOTRAN AUTH
Infrastructure Access Gate
NODE ID: INF-392-LT-SCHEMA
INFRASTRUCTURE
VISUALIZATION
ANALYTICS SCHEMA
System-level deep introspection of the Lingotran
Core .
Interactive visualization of relational entities, transactional schemas, and structural
constraints.
© 2024 LINGOTRAN INFRASTRUCTURE |
SECURE NODE 01
[
{
"schema": "public",
"name": "Users",
"type": "table",
"columns": [
{ "name": "User_ID", "type": "serial", "key": "PK" },
{ "name": "User_FullName", "type": "varchar(255)" },
{ "name": "User_PrimaryEmail", "type": "varchar(255)", "key": "UK" },
{ "name": "User_Role_ID", "type": "int4", "key": "FK" },
{ "name": "User_Organization_ID", "type": "int4", "key": "FK" },
{ "name": "User_Registration_DateTime", "type": "timestamp" }
]
},
{
"schema": "fct",
"name": "LearnerActivityStats",
"type": "table",
"columns": [
{ "name": "id", "type": "serial", "key": "PK" },
{ "name": "UserID", "type": "int4", "key": "FK" },
{ "name": "CourseID", "type": "int4", "key": "FK" },
{ "name": "TrackerDate", "type": "date" },
{ "name": "AccuracyPerc", "type": "numeric(10,2)" },
{ "name": "TotalTimeSpent", "type": "interval" }
]
},
{
"schema": "dim",
"name": "Cohort",
"type": "table",
"columns": [
{ "name": "id", "type": "serial", "key": "PK" },
{ "name": "ClassName", "type": "varchar(255)" },
{ "name": "SectionName", "type": "varchar(255)" },
{ "name": "AcademicYear", "type": "varchar(20)" }
]
},
{
"schema": "dim",
"name": "Course",
"type": "table",
"description": "Core course definitions and metadata.",
"columns": [
{ "name": "Course_ID", "type": "serial", "key": "PK" },
{ "name": "Course_Name", "type": "varchar(255)" },
{ "name": "Course_Code", "type": "varchar(50)" }
]
}
]