TracCloud: Rosetta: Difference between revisions
From Redrock Wiki
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
<div class="tcWidgetPage" style="width:100%"> | <div class="tcWidgetPage" style="width:100%"> | ||
<div style="text-align: center; margin-top: 0em;"><big><b>Students</b></big></div><div class="mw-collapsible"> | |||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig Tag</b> !! <b>API</b> !! <b>SFTP Export Column</b> !! <b>Example</b> | ! <b>Field</b> !! <b>Type</b> !! <b>Description</b> !! <b>Twig Tag</b> !! <b>API</b> !! <b>SFTP Export Column</b> !! <b>Example</b> | ||
Line 11: | Line 11: | ||
| Last Name || varchar(80) || The student's last name || <nowiki>{{Student.Last_Name}}</nowiki> || Students.Last_Name || LastName || Smith | | Last Name || varchar(80) || The student's last name || <nowiki>{{Student.Last_Name}}</nowiki> || Students.Last_Name || LastName || Smith | ||
|} | |} | ||
</div> | |||
<br> | |||
</div> | </div> | ||
<div class="tcWidgetPage" style="width:100%"> | <div class="tcWidgetPage" style="width:100%"> | ||
<div style="text-align: center; margin-top: 0em;"><big><b>Visits</b></big></div><div class="mw-collapsible"> | |||
{| class="wikitable" | {| class="wikitable" | ||
|+ Visits | |+ Visits | ||
Line 20: | Line 23: | ||
| example || example || example || <nowiki>{{example.example}}</nowiki> || example.example || example || example | | example || example || example || <nowiki>{{example.example}}</nowiki> || example.example || example || example | ||
|} | |} | ||
</div> | |||
<br> | |||
</div> | </div> |
Revision as of 17:15, 21 January 2025
Students
Field | Type | Description | Twig Tag | API | SFTP Export Column | Example |
---|---|---|---|---|---|---|
ID | bigint | The student's ID number. Should be unique. | {{Student.ID}} | Students.ID | ID | 1234567 |
First Name | varchar(80) | The student's preferred first name. | {{Student.First_Name}} | Students.First_Name | FirstName | Sam |
Last Name | varchar(80) | The student's last name | {{Student.Last_Name}} | Students.Last_Name | LastName | Smith |
Visits
Field | Type | Description | Twig Tag | API | SFTP Export Column | Example |
---|---|---|---|---|---|---|
example | example | example | {{example.example}} | example.example | example | example |