Difference between revisions of "SAM V2:customization"

From CIDI Wiki
Jump to navigation Jump to search
(Blanked the page)
 
(25 intermediate revisions by one other user not shown)
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.


==Tables Names and Directory Structure==
<table border="1">
<tr>
<th>&nbsp;</th>
<th>Table Name</th>
<th>Subdirectory Name</th>
</tr>
<tr>
<td>Student</td>
<td>students</td>
<td>student</td>
</tr>
<tr>
<td>Disabilities</td>
<td>disabilities</td>
<td>disability</td>
</tr>
<tr>
<td>Accommodations</td>
<td>accommodations</td>
<td>accommodation</td>
</tr>
<tr>
<td>Consents</td>
<td>consent_types</td>
<td>consent</td>
</tr>
<tr>
<td>Referrals</td>
<td>referrals</td>
<td>referral</td>
</tr>
<tr>
<td>Case Notes</td>
<td>case_notes</td>
<td>case</td>
</tr>
<tr>
<td>Tasks</td>
<td>tasks</td>
<td>task</td>
</tr>
<tr>
<td>Documentation</td>
<td>documentation</td>
<td>doc</td>
</tr>
<tr>
<td>Tests</td>
<td>tests</td>
<td>test</td>
</tr>
<tr>
<td>Class Schedules</td>
<td>class_schedules</td>
<td>schedule</td>
</tr>
<tr>
<td>Orders</td>
<td>orders</td>
<td>order</td>
</tr>
</table>
==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:
<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.

Latest revision as of 10:50, 19 May 2015