SELECT my_tracking.id AS id, my_tracking.uid AS my_tracking_uid, my_tracking.event_id AS my_tracking_event_id
FROM {my_tracking} my_tracking
ORDER BY id ASC
LIMIT 25 OFFSET 0

$data['my_tracking']['table']['name'] = 'event_tracking' . '.my_tracking';

$data['my_tracking']['table']['group'] = t('Event Tracker');

$data['my_tracking']['table']['base'] = array(
  'field' => 'id',
  'title' => t('Event Tracker'),
  'help'  => t('Contains data about tracking events.'),
  'database' => 'event_tracking',
);

$data['my_tracking']['table']['join'] = array(
  'users_field_data' => array(
    'table' => 'default' . '.users_field_data',
    'left_field' => 'uid',
    'field'      => 'uid',
  ),
);

$data['my_tracking']['table']['provider'] = 'my_tracking';


$data['my_tracking']['id'] = array(
  'title' => t('Record ID'),
  'field' => array(
    'id' => 'numeric',
  ),
  'sort' => array(
    'id' => 'standard',
  ),
  'filter' => array(
    'title' => t('Record ID'),
    'id' => 'numeric',
  ),
  'argument' => array(
    'id' => 'numberic',
  ),
);

$data['my_tracking']['uid'] = array(
  'title' => t('UID'),
  'help'  => t("The user's UID."),
  'field' => array(
    'id' => 'numeric',
  ),
  'sort' => array(
    'id' => 'standard',
  ),
  'filter' => array(
    'title' => t('UID'),
    'id' => 'numeric',
  ),
  /*  'relationship' => array(
    'title'              => t('User who is tracked'),
    'help'               => t('The user associated with the record.'),
    'id'                 => 'standard',
    'base'               => 'users_field_data',
    'base field'         => 'uid',
    'field'              => 'uid',
    'label'              => t('The who is tracked'),
  ),*/
  'argument' => array(
    'id' => 'numeric',
  ),
);

$data['my_tracking']['event_id'] = array(
  'title' => t('Event ID'),
  'field' => array(
    'id' => 'numeric',
  ),
  'sort' => array(
    'id' => 'standard',
  ),
  'filter' => array(
    'title' => t('Event ID'),
    'id' => 'numeric',
  ),
  'argument' => array(
    'id' => 'numberic',
  ),
);