Subversion Repositories computer_asset_manager_v2

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
53 rodolico 1
<?php
2
   require_once( 'camp.class.php' );
3
 
4
   class Device extends Camp {
5
      protected static $dbStructure = array(
6
         'table' => array(
7
            'tableName' => 'device',
8
            'primaryKey' => 'device_id',
9
            'selectionDisplay' => 'name',
10
            'fields' => array(
56 rodolico 11
                  'id' => array (
12
                     'fieldname' => 'device_id',
53 rodolico 13
                     'displayName' => 'ID',
14
                     'type' => 'int unsigned',
15
                     'nullable' => false
16
                  ),
17
                  'name' => array (
56 rodolico 18
                     'fieldname' => 'name',
19
                     'displayName' => 'Name',
53 rodolico 20
                     'type' => 'varchar',
21
                     'size' => 64,
22
                     'list' => true
23
                  ),
24
                  'uuid' => array (
56 rodolico 25
                     'fieldname' => 'uuid',
53 rodolico 26
                     'displayName' => 'UUID',
27
                     'type' => 'varchar',
28
                     'size' => 36,
29
                     'list' => false
30
                  ),
31
                  'serial' => array (
56 rodolico 32
                     'fieldname' => 'serial',
33
                     'displayName' => 'Serial',
53 rodolico 34
                     'type' => 'varchar',
35
                     'size' => 36,
36
                     'list' => false
37
                  ),
38
                  'created' => array (
56 rodolico 39
                     'fieldname' => 'created',
53 rodolico 40
                     'displayName' => 'Created',
41
                     'type' => 'date'
42
                  ),
43
                  'removed' => array(
56 rodolico 44
                     'fieldname' => 'removed',
53 rodolico 45
                     'displayName' => 'Removed',
46
                     'type' => 'date'
47
                  )
48
               ) // fields
56 rodolico 49
            ), // table
50
            'view' => array(
51
               'viewName' => 'view_device_location_owner_type',
52
               'primaryKey' => 'device_id',
53
               'selectionDisplay' => 'device',
54
               'fields' => array(
55
                  'removed' => array( 
56
                     'fieldname' => 'device_removed'
57
                  )
58
               )
59
            )
53 rodolico 60
         ); // dbStructure
61
         public static $myName = 'device';
62
   }
63
 
64
?>