Difference between revisions of "SAM V2:customization"
Jump to navigation
Jump to search
Line 68: | Line 68: | ||
==How to Add a Field to a Table and Form== | ==How to Add a Field to a Table and Form== | ||
===Step 1=== | |||
# Add the field to the underlying table in MySQL. For example, to add a field called Evaluator Name to the disabilities table, you would execute a SQL statement similar to: | # Add the field to the underlying table in MySQL. For example, to add a field called Evaluator Name to the disabilities table, you would execute a SQL statement similar to: | ||
< | <pre>alter table disabilities add column evaluator_name varchar(50) … </pre> | ||
Or you could use the MySQL workbench to alter the table using the GUI tools. | Or you could use the MySQL workbench to alter the table using the GUI tools. |
Revision as of 13:51, 17 May 2011
Since SAM V2 is open-source software, it is easily customized with a working knowledge of HTML, PHP, MySQL, and the SAM source code/database structure.
Tables Names and Directory Structure
Table Name | Subdirectory Name | |
---|---|---|
Student | students | student |
Disabilities | disabilities | disability |
Accommodations | accommodations | accommodation |
Consents | consent_types | consent |
Referrals | referrals | referral |
Case Notes | case_notes | case |
Tasks | tasks | task |
Documentation | documentation | doc |
Tests | tests | test |
Class Schedules | class_schedules | schedule |
Orders | orders | order |
How to Add a Field to a Table and Form
Step 1
- Add the field to the underlying table in MySQL. For example, to add a field called Evaluator Name to the disabilities table, you would execute a SQL statement similar to:
alter table disabilities add column evaluator_name varchar(50) …
Or you could use the MySQL workbench to alter the table using the GUI tools.