Difference between revisions of "SAM V2:customization"

From CIDI Wiki
Jump to navigation Jump to search
(Created page with "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. ==Naming Conventions and ...")
 
Line 1: Line 1:
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.
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.


==Naming Conventions and Structure==
==Tables Names and Directory Structure==


<table>
<table border="1">
<tr>
<tr>
<th>&nbsp;</th>
<th>&nbsp;</th>
Line 65: Line 65:
</tr>
</tr>
</table>
</table>
==How to Add a Field to a Table and Form==
# 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:
<code>alter table disabilities add column evaluator_name varchar(50) … </code>
Or you could use the MySQL workbench to alter the table using the GUI tools.

Revision as of 13:50, 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

  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.