Difference between revisions of "SAM V1:Tables"

From CIDI Wiki
Jump to navigation Jump to search
 
Line 24: Line 24:
The [[SAM V1:Students|student]] table is the parent or master table in SAM V1.  Records in all other tables relate to one particular student record and are called child records.  The parent-child relationship in SAM V1 is one parent to many children.  So, one student record can have many related disability records, accommodation records, or case note records.
The [[SAM V1:Students|student]] table is the parent or master table in SAM V1.  Records in all other tables relate to one particular student record and are called child records.  The parent-child relationship in SAM V1 is one parent to many children.  So, one student record can have many related disability records, accommodation records, or case note records.


Refer to the [https://www.quickbase.com/help/default.html#about_relationships.html QuickBase help on table relationships] for more detailed information.
Refer to the [http://www.quickbase.com/help/default.html#about_relationships.html QuickBase help on table relationships] for more detailed information.


For each table in SAM V1, records can be added, edited, deleted, or viewed, depending on the user’s role.   
For each table in SAM V1, records can be added, edited, deleted, or viewed, depending on the user’s role.   


To view table descriptions, relationships, process flows, and detailed field information, click on a table name listed above.
To view table descriptions, relationships, process flows, and detailed field information, click on a table name listed above.

Latest revision as of 17:04, 7 November 2008

SAM Table Relationship Diagram

SAM V1 is comprised of the following tables:

The student table is the parent or master table in SAM V1. Records in all other tables relate to one particular student record and are called child records. The parent-child relationship in SAM V1 is one parent to many children. So, one student record can have many related disability records, accommodation records, or case note records.

Refer to the QuickBase help on table relationships for more detailed information.

For each table in SAM V1, records can be added, edited, deleted, or viewed, depending on the user’s role.

To view table descriptions, relationships, process flows, and detailed field information, click on a table name listed above.