Subversion Repositories computer_asset_manager_v2

Rev

Rev 67 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | Download | RSS feed

<?php
   require_once( 'camp.class.php' );

   class Owner extends Camp {
      protected static $dbStructure = array(
         'table' => array( 
            'tableName' => 'owner',
            'primaryKey' => 'owner_id',
            'selectionDisplay' => 'name',
            'inactiveField' => 'removed',
            'fields' => array(
                  'id' => array (
                     'fieldname' => 'owner_id',
                     'displayName' => 'ID',
                     'type' => 'int unsigned',
                     'nullable' => false,
                     'canEdit' => false
                  ),
                  'name' => array (
                     'fieldname' => 'name',
                     'displayName' => 'Owner',
                     'type' => 'varchar',
                     'size' => 64,
                     'list' => true
                  ),
                  'uuid' => array (
                     'fieldname' => 'uuid',
                     'displayName' => 'UUID',
                     'type' => 'varchar',
                     'size' => 36,
                     'list' => false
                  ),
                  'created' => array (
                     'fieldname' => 'created',
                     'displayName' => 'Created',
                     'type' => 'date'
                  ),
                  'removed' => array(
                     'fieldname' => 'removed',
                     'displayName' => 'Removed',
                     'type' => 'date'
                  )
               ) // fields
            ), // table
            'view' => array(
               'viewName' => 'view_device_location_owner_type',
               'primaryKey' => 'owner_id',
               'selectionDisplay' => 'owner',
               'fields' => array(
                  'removed' => array( 
                     'fieldname' => 'owner_removed'
                  )
               )
            ), // view
            'children' => array(
                  'Location' => array(
                     'intermediateTable' => 'owner_location',
                     'remoteID' => 'location_id',
                     'myID' => 'owner_id'
                     ),
                  'Device' => array(
                     'intermediateTable' => 'owner_device',
                     'remoteID' => 'device_id',
                     'myID' => 'owner_id'
                     )
            ) // children
         ); // dbStructure

   }

?>