TracCloud: Rosetta
From Redrock Wiki
Description stuff
link to twig guide
link to api guide
etc etc
Type Definitions
| Type | Description |
|---|---|
| varchar(#) | Alphanumeric field with a specified maximum length. |
| int | Integer, maximum value of about 4 billion, or a 10-digit numeric value. |
| bigint | Big integer, maximum value of about 9 quintillion, or a 16-digit numeric value. |
| tinyint | Tiny integer, typically used to store a 1 or 0 as true or false. |
| date | Date, formatted as YYYY-MM-DD |
| time | A specific time using a 24-hour format (HH:MM:SS), e.g., 13:45:00 |
| datetime | Date and time, YYYY-MM-DD HH:MM:SS |
| double | Decimal # with up to 12 digits precision |
| json | JSON-formatted field that contains multiple fields and values (e.g., custom fields). |
Invert Visibility
Students
Toggle Visibility
| 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
Toggle Visibility
| Field | Type | Description | Twig Tag | API | SFTP Export Column | Example |
|---|---|---|---|---|---|---|
| example | example | example | {{example.example}} | example.example | example | example |
Appointments
Toggle Visibility
| Field | Type | Description | Twig Tag | API | SFTP Export Column | Example |
|---|---|---|---|---|---|---|
| example | example | example | {{example.example}} | example.example | example | example |