| Line 5... |
Line 5... |
| 5 |
'table name' => 'maintenance_schedule',
|
5 |
'table name' => 'maintenance_schedule',
|
| 6 |
'key field' => 'maintenance_schedule_id',
|
6 |
'key field' => 'maintenance_schedule_id',
|
| 7 |
'display columns' => array('Device','Task', 'Schedule'),
|
7 |
'display columns' => array('Device','Task', 'Schedule'),
|
| 8 |
'display query' => 'select device.name Device, maintenance_task.description Task, schedule Schedule from maintenance_schedule join device using (device_id) join maintenance_task using (maintenance_task_id) order by device.name, maintenance_task.description',
|
8 |
'display query' => 'select device.name Device, maintenance_task.description Task, schedule Schedule from maintenance_schedule join device using (device_id) join maintenance_task using (maintenance_task_id) order by device.name, maintenance_task.description',
|
| 9 |
'field info' => array(
|
9 |
'field info' => array(
|
| 10 |
'device_id' => array('type' => 'lookup', 'table' => 'device', 'keyfield' => 'device_id', 'display_field' => 'name'),
|
- |
|
| 11 |
'removed_date' => array('type' => 'datetime', 'required' => false ),
|
- |
|
| 12 |
'maintenance_schedule_id' => array('keyfield' => true , 'required' => true , 'readonly' => true , 'type' => 'int' , 'width' => 10),
|
10 |
'maintenance_schedule_id' => array('keyfield' => true , 'required' => true , 'readonly' => true , 'type' => 'int' , 'width' => 10),
|
| 13 |
'added_date' => array('type' => 'datetime', 'required' => true),
|
11 |
'device_id' => array('type' => 'lookup', 'table' => 'device', 'keyfield' => 'device_id', 'display_field' => 'name', 'display name' => 'Device'),
|
| 14 |
'login_id' => array('type' => 'lookup', 'table' => 'login', 'keyfield' => 'login_id', 'display_field' => 'email'),
|
12 |
'maintenance_task_id' => array('type' => 'lookup', 'table' => 'maintenance_task', 'keyfield' => 'maintenance_task_id', 'display_field' => 'description', 'display name' => 'Maintenance Task'),
|
| - |
|
13 |
'schedule' => array('keyfield' => true , 'required' => true , 'type' => 'int' , 'width' => 10, 'display name' => 'Schedule (days)'),
|
| 15 |
'maintenance_task_id' => array('type' => 'lookup', 'table' => 'maintenance_task', 'keyfield' => 'maintenance_task_id', 'display_field' => 'description'),
|
14 |
'login_id' => array('type' => 'lookup', 'table' => 'login', 'keyfield' => 'login_id', 'display_field' => 'email', 'display name' => 'Technician'),
|
| 16 |
/* The number of days between performance of this task */
|
15 |
/* The number of days between performance of this task */
|
| 17 |
'schedule' => array('keyfield' => true , 'required' => true , 'type' => 'int' , 'width' => 10)
|
16 |
'added_date' => array('type' => 'datetime', 'required' => true, 'display name' => 'Date Added'),
|
| - |
|
17 |
'removed_date' => array('type' => 'datetime', 'required' => false, 'display name' => 'Date Removed' )
|
| 18 |
)
|
18 |
)
|
| 19 |
);
|
19 |
);
|
| 20 |
$DATABASE_DEFINITION['maintenance_performed'] = array(
|
20 |
$DATABASE_DEFINITION['maintenance_performed'] = array(
|
| 21 |
'table name' => 'maintenance_performed',
|
21 |
'table name' => 'maintenance_performed',
|
| 22 |
'display name' => 'Maintenance Performed',
|
22 |
'display name' => 'Maintenance Performed',
|