function __construct() { $this->setTableName('domstream'); // set common fact table columns $parent_columns = parent::__construct(); foreach ($parent_columns as $pcolumn) { $this->setProperty($pcolumn); } // move to abstract //$this->properties['id'] = new owa_dbColumn; //$this->properties['id']->setDataType(OWA_DTD_BIGINT); //$this->properties['id']->setPrimaryKey(); // move to abstract //$visitor_id = new owa_dbColumn('visitor_id', OWA_DTD_BIGINT); //$visitor_id->setForeignKey('base.visitor'); //$this->setProperty($visitor_id); // move to abstract //$session_id = new owa_dbColumn('session_id', OWA_DTD_BIGINT); //$session_id->setForeignKey('base.session'); //$this->setProperty($session_id); $document_id = new owa_dbColumn('document_id', OWA_DTD_BIGINT); $document_id->setForeignKey('base.document'); $this->setProperty($document_id); // move to abstract //$site_id = new owa_dbColumn('site_id', OWA_DTD_VARCHAR255); //$site_id->setForeignKey('base.site', 'site_id'); //$this->setProperty($site_id); $domstream_guid = new owa_dbColumn('domstream_guid', OWA_DTD_BIGINT); $this->setProperty($domstream_guid); $this->properties['events'] = new owa_dbColumn(); $this->properties['events']->setDataType(OWA_DTD_BLOB); $this->properties['duration'] = new owa_dbColumn(); $this->properties['duration']->setDataType(OWA_DTD_INT); // move to abstract //$this->properties['timestamp'] = new owa_dbColumn; //$this->properties['timestamp']->setDataType(OWA_DTD_INT); // move to abstract //$this->properties['yyyymmdd'] = new owa_dbColumn; //$this->properties['yyyymmdd']->setDataType(OWA_DTD_INT); // needed? $this->properties['page_url'] = new owa_dbColumn(); $this->properties['page_url']->setDataType(OWA_DTD_VARCHAR255); }
function __construct() { $this->setTableName('action_fact'); // set common fact table columns $parent_columns = parent::__construct(); foreach ($parent_columns as $pcolumn) { $this->setProperty($pcolumn); } $document_id = new owa_dbColumn('document_id', OWA_DTD_BIGINT); $document_id->setForeignKey('base.document'); $this->setProperty($document_id); $action_name = new owa_dbColumn('action_name', OWA_DTD_VARCHAR255); $this->setProperty($action_name); $action_label = new owa_dbColumn('action_label', OWA_DTD_VARCHAR255); $this->setProperty($action_label); $action_group = new owa_dbColumn('action_group', OWA_DTD_VARCHAR255); $this->setProperty($action_group); $numeric_value = new owa_dbColumn('numeric_value', OWA_DTD_INT); $this->setProperty($numeric_value); }
function __construct() { $this->setTableName('click'); // set common fact table columns $parent_columns = parent::__construct(); foreach ($parent_columns as $pcolumn) { $this->setProperty($pcolumn); } // move to abstract //$this->properties['id'] = new owa_dbColumn; //$this->properties['id']->setDataType(OWA_DTD_BIGINT); //$this->properties['id']->setPrimaryKey(); // drop $this->properties['last_impression_id'] = new owa_dbColumn(); $this->properties['last_impression_id']->setDataType(OWA_DTD_BIGINT); // move to abstract //$visitor_id = new owa_dbColumn('visitor_id', OWA_DTD_BIGINT); //$visitor_id->setForeignKey('base.visitor'); //$this->setProperty($visitor_id); // move to abstract //$session_id = new owa_dbColumn('session_id', OWA_DTD_BIGINT); //$session_id->setForeignKey('base.session'); //$this->setProperty($session_id); $document_id = new owa_dbColumn('document_id', OWA_DTD_BIGINT); $document_id->setForeignKey('base.document'); $this->setProperty($document_id); $this->properties['target_id'] = new owa_dbColumn(); $this->properties['target_id']->setDataType(OWA_DTD_BIGINT); $this->properties['target_url'] = new owa_dbColumn(); $this->properties['target_url']->setDataType(OWA_DTD_VARCHAR255); // move to abstract //$this->properties['timestamp'] = new owa_dbColumn; //$this->properties['timestamp']->setDataType(OWA_DTD_INT); /* $this->properties['year'] = new owa_dbColumn; $this->properties['year']->setDataType(OWA_DTD_INT); $this->properties['month'] = new owa_dbColumn; $this->properties['month']->setDataType(OWA_DTD_INT); $this->properties['day'] = new owa_dbColumn; $this->properties['day']->setDataType(OWA_DTD_INT); $this->properties['dayofyear'] = new owa_dbColumn; $this->properties['dayofyear']->setDataType(OWA_DTD_INT); $this->properties['weekofyear'] = new owa_dbColumn; $this->properties['weekofyear']->setDataType(OWA_DTD_INT); */ // drop these soon $this->properties['hour'] = new owa_dbColumn(); $this->properties['hour']->setDataType(OWA_DTD_TINYINT2); $this->properties['minute'] = new owa_dbColumn(); $this->properties['minute']->setDataType(OWA_DTD_TINYINT2); $this->properties['second'] = new owa_dbColumn(); $this->properties['second']->setDataType(OWA_DTD_INT); $this->properties['msec'] = new owa_dbColumn(); $this->properties['msec']->setDataType(OWA_DTD_VARCHAR255); $this->properties['click_x'] = new owa_dbColumn(); $this->properties['click_x']->setDataType(OWA_DTD_INT); $this->properties['click_y'] = new owa_dbColumn(); $this->properties['click_y']->setDataType(OWA_DTD_INT); $this->properties['page_width'] = new owa_dbColumn(); $this->properties['page_width']->setDataType(OWA_DTD_INT); $this->properties['page_height'] = new owa_dbColumn(); $this->properties['page_height']->setDataType(OWA_DTD_INT); $this->properties['position'] = new owa_dbColumn(); $this->properties['position']->setDataType(OWA_DTD_INT); $this->properties['approx_position'] = new owa_dbColumn(); $this->properties['approx_position']->setDataType(OWA_DTD_BIGINT); $this->properties['dom_element_x'] = new owa_dbColumn(); $this->properties['dom_element_x']->setDataType(OWA_DTD_INT); $this->properties['dom_element_y'] = new owa_dbColumn(); $this->properties['dom_element_y']->setDataType(OWA_DTD_INT); $this->properties['dom_element_name'] = new owa_dbColumn(); $this->properties['dom_element_name']->setDataType(OWA_DTD_VARCHAR255); $this->properties['dom_element_id'] = new owa_dbColumn(); $this->properties['dom_element_id']->setDataType(OWA_DTD_VARCHAR255); $this->properties['dom_element_value'] = new owa_dbColumn(); $this->properties['dom_element_value']->setDataType(OWA_DTD_VARCHAR255); $this->properties['dom_element_tag'] = new owa_dbColumn(); $this->properties['dom_element_tag']->setDataType(OWA_DTD_VARCHAR255); $this->properties['dom_element_text'] = new owa_dbColumn(); $this->properties['dom_element_text']->setDataType(OWA_DTD_VARCHAR255); $this->properties['dom_element_class'] = new owa_dbColumn(); $this->properties['dom_element_class']->setDataType(OWA_DTD_VARCHAR255); $this->properties['dom_element_parent_id'] = new owa_dbColumn(); $this->properties['dom_element_parent_id']->setDataType(OWA_DTD_VARCHAR255); // drop $this->properties['tag_id'] = new owa_dbColumn(); $this->properties['tag_id']->setDataType(OWA_DTD_BIGINT); //drop $this->properties['placement_id'] = new owa_dbColumn(); $this->properties['placement_id']->setDataType(OWA_DTD_BIGINT); // move to abstract //$this->properties['campaign_id'] = new owa_dbColumn; //$this->properties['campaign_id']->setDataType(OWA_DTD_BIGINT); //drop $this->properties['ad_group_id'] = new owa_dbColumn(); $this->properties['ad_group_id']->setDataType(OWA_DTD_BIGINT); // move to abstract //$this->properties['ad_id'] = new owa_dbColumn; //$this->properties['ad_id']->setDataType(OWA_DTD_BIGINT); // move to absctract //$site_id = new owa_dbColumn('site_id', OWA_DTD_VARCHAR255); //$site_id->setForeignKey('base.site', 'site_id'); //$this->setProperty($site_id); // move to absctract //$ua_id = new owa_dbColumn('ua_id', OWA_DTD_BIGINT); //$ua_id->setForeignKey('base.ua'); //$this->setProperty($ua_id); // move to abstract //$this->properties['ip_address'] = new owa_dbColumn; //$this->properties['ip_address']->setDataType(OWA_DTD_VARCHAR255); // drop $this->properties['host'] = new owa_dbColumn(); $this->properties['host']->setDataType(OWA_DTD_VARCHAR255); // move to abstract //wrong data type //$host_id = new owa_dbColumn('host_id', OWA_DTD_VARCHAR255); //$host_id->setForeignKey('base.host'); //$this->setProperty($host_id); // move to abstract //$yyyymmdd = new owa_dbColumn; //$yyyymmdd->setName('yyyymmdd'); //$yyyymmdd->setDataType(OWA_DTD_INT); //$yyyymmdd->setIndex(); //$this->setProperty($yyyymmdd); }
/** * Constructs an instance of the entity. **/ function __construct() { $this->setTableName('eco_core'); // Retrieve the common columns $parent_columns = parent::__construct(); // Configure the column de-normalized columns foreach ($parent_columns as $pcolumn) { $this->setProperty($pcolumn); } // Configure email $email = new owa_dbColumn('user_email', OWA_DTD_VARCHAR255); $this->setProperty($email); // Configure the tracked columns. $applicationName = new owa_dbColumn('app_name', OWA_DTD_VARCHAR255); $this->setProperty($applicationName); $appVersion = new owa_dbColumn('app_version', OWA_DTD_VARCHAR255); $this->setProperty($appVersion); $contentId = new owa_dbColumn('content_identifier', OWA_DTD_VARCHAR255); $this->setProperty($contentId); $navigationState = new owa_dbColumn('navstate', OWA_DTD_VARCHAR255); $this->setProperty($navigationState); $objectName = new owa_dbColumn('object_name', OWA_DTD_VARCHAR255); $this->setProperty($objectName); $stateName = new owa_dbColumn('state_name', OWA_DTD_VARCHAR255); $this->setProperty($stateName); $offline = new owa_dbColumn('offline', OWA_DTD_BOOLEAN); $this->setProperty($offline); $fullscreen = new owa_dbColumn('fullscreen', OWA_DTD_BOOLEAN); $this->setProperty($fullscreen); $installState = new owa_dbColumn('installstate', OWA_DTD_TINYINT); $this->setProperty($installState); $timecode = new owa_dbColumn('timecode', OWA_DTD_INT); $this->setProperty($timecode); $zoomFactor = new owa_dbColumn('zoomfactor', OWA_DTD_VARCHAR10); $this->setProperty($zoomFactor); $clientHeight = new owa_dbColumn('client_height', OWA_DTD_INT); $this->setProperty($clientHeight); $clientWidth = new owa_dbColumn('client_width', OWA_DTD_INT); $this->setProperty($clientWidth); $runtimeVersion = new owa_dbColumn('runtime_version', OWA_DTD_VARCHAR255); $this->setProperty($runtimeVersion); $campaignId = new owa_dbColumn('jadcampaign_id', OWA_DTD_BIGINT); $this->setProperty($campaignId); $zoneId = new owa_dbColumn('jadzone_id', OWA_DTD_BIGINT); $this->setProperty($zoneId); $adId = new owa_dbColumn('jad_id', OWA_DTD_BIGINT); $this->setProperty($adId); $contentSection = new owa_dbColumn('content_section', OWA_DTD_VARCHAR255); $this->setProperty($contentSection); $platform = new owa_dbColumn('platform', OWA_DTD_VARCHAR255); $this->setProperty($platform); $originalTimestamp = new owa_dbColumn('original_timestamp', OWA_DTD_INT); $this->setProperty($originalTimestamp); $originalTs = new owa_dbColumn('original_datetime', OWA_DTD_VARCHAR255); $this->setProperty($originalTs); $region = new owa_dbColumn('region', OWA_DTD_VARCHAR10); $this->setProperty($region); $postalCode = new owa_dbColumn('postal_code', OWA_DTD_VARCHAR10); $this->setProperty($postalCode); $projectCost = new owa_dbColumn('cost', OWA_DTD_VARCHAR255); $this->setProperty($projectCost); $costType = new owa_dbColumn('cost_type', OWA_DTD_VARCHAR255); $this->setProperty($costType); $costSubtype = new owa_dbColumn('cost_subtype', OWA_DTD_VARCHAR255); $this->setProperty($costSubtype); $persistanceAction = new owa_dbColumn('storage', OWA_DTD_VARCHAR10); $this->setProperty($persistanceAction); owa_coreAPI::debug('Initialized entity: eco_core'); }
function __construct() { $this->setTableName('commerce_transaction_fact'); // set common fact table columns $parent_columns = parent::__construct(); foreach ($parent_columns as $pcolumn) { $this->setProperty($pcolumn); } // move to abstract //$id = new owa_dbColumn('id', OWA_DTD_BIGINT); //$id->setPrimaryKey(); //$this->setProperty($id); // move to abstract //$visitor_id = new owa_dbColumn('visitor_id', OWA_DTD_BIGINT); //$visitor_id->setForeignKey('base.visitor'); //$this->setProperty($visitor_id); // move to abstract //$session_id = new owa_dbColumn('session_id', OWA_DTD_BIGINT); //$session_id->setForeignKey('base.session'); //$this->setProperty($session_id); $document_id = new owa_dbColumn('document_id', OWA_DTD_BIGINT); $document_id->setForeignKey('base.document'); $this->setProperty($document_id); // move to abstract //$site_id = new owa_dbColumn('site_id', OWA_DTD_VARCHAR255); //$site_id->setForeignKey('base.site', 'site_id'); //$this->setProperty($site_id); // move to abstract //$ua_id = new owa_dbColumn('ua_id', OWA_DTD_BIGINT); //$ua_id->setForeignKey('base.ua'); //$this->setProperty($ua_id); // move to abstract //$host_id = new owa_dbColumn('host_id', OWA_DTD_BIGINT); //$host_id->setForeignKey('base.host'); //$this->setProperty($host_id); // move to abstract //$os_id = new owa_dbColumn('os_id', OWA_DTD_BIGINT); //$os_id->setForeignKey('base.os'); //$this->setProperty($os_id); // move to abstract //$location_id = new owa_dbColumn('location_id', OWA_DTD_BIGINT); //$location_id->setForeignKey('base.location_dim'); //$this->setProperty($location_id); // move to abstract //$medium = new owa_dbColumn('medium',OWA_DTD_VARCHAR255); //$this->setProperty($medium); // move to abstract //$source_id = new owa_dbColumn('source_id', OWA_DTD_BIGINT); //$source_id->setForeignKey('base.source_dim'); //$this->setProperty($source_id); // move to abstract //$ad_id = new owa_dbColumn('ad_id', OWA_DTD_BIGINT); //$ad_id->setForeignKey('base.ad_dim'); //$this->setProperty($ad_id); // move to abstract //$campaign_id = new owa_dbColumn('campaign_id', OWA_DTD_BIGINT); //$campaign_id->setForeignKey('base.campaign_dim'); //$this->setProperty($campaign_id); // move to abstract //$referring_search_term_id = new owa_dbColumn('referring_search_term_id', OWA_DTD_BIGINT); //$referring_search_term_id->setForeignKey('base.search_term_dim'); //$this->setProperty($referring_search_term_id); // move to abstract //$referer_id = new owa_dbColumn('referer_id', OWA_DTD_BIGINT); //$referer_id->setForeignKey('base.referer'); //$this->setProperty($referer_id); // move to abstract //$timestamp = new owa_dbColumn('timestamp', OWA_DTD_INT); //$this->setProperty($timestamp); // move to abstract //$yyyymmdd = new owa_dbColumn('yyyymmdd', OWA_DTD_INT); //$this->setProperty($yyyymmdd); $order_id = new owa_dbColumn('order_id', OWA_DTD_VARCHAR255); $order_id->setIndex(); $this->setProperty($order_id); $order_source = new owa_dbColumn('order_source', OWA_DTD_VARCHAR255); $this->setProperty($order_source); $gateway = new owa_dbColumn('gateway', OWA_DTD_VARCHAR255); $this->setProperty($gateway); $total = new owa_dbColumn('total_revenue', OWA_DTD_BIGINT); $this->setProperty($total); $tax = new owa_dbColumn('tax_revenue', OWA_DTD_BIGINT); $this->setProperty($tax); $shipping = new owa_dbColumn('shipping_revenue', OWA_DTD_BIGINT); $this->setProperty($shipping); // move to abstract //$days_since_first_session = new owa_dbColumn('days_since_first_session', OWA_DTD_INT); //$this->setProperty($days_since_first_session); // move to abstract //$nps = new owa_dbColumn('num_prior_sessions', OWA_DTD_INT); //$this->setProperty($nps); }
function __construct() { // table name $this->setTableName('session'); $this->setSummaryLevel(1); // set common fact table columns $parent_columns = parent::__construct(); // remove the session id from parent col list // as it's a duplicate to the id column for this entity. if (isset($parent_columns['session_id'])) { unset($parent_columns['session_id']); } foreach ($parent_columns as $pcolumn) { $this->setProperty($pcolumn); } // properties // move to abstract //$this->properties['id'] = new owa_dbColumn; //$this->properties['id']->setDataType(OWA_DTD_BIGINT); //$this->properties['id']->setPrimaryKey(); // move to abstract //$visitor_id = new owa_dbColumn('visitor_id', OWA_DTD_BIGINT); //$visitor_id->setForeignKey('base.visitor'); //$this->setProperty($visitor_id); // move to abstract //$ts = new owa_dbColumn; //$ts->setName('timestamp'); //$ts->setDataType(OWA_DTD_BIGINT); //$ts->setIndex(); //$this->setProperty($ts); // move to abstract //$yyyymmdd = new owa_dbColumn; //$yyyymmdd->setName('yyyymmdd'); //$yyyymmdd->setDataType(OWA_DTD_INT); //$yyyymmdd->setIndex(); //$this->setProperty($yyyymmdd); // move to abstract //$this->properties['user_name'] = new owa_dbColumn; //$this->properties['user_name']->setDataType(OWA_DTD_VARCHAR255); // drop $this->properties['user_email'] = new owa_dbColumn(); $this->properties['user_email']->setDataType(OWA_DTD_VARCHAR255); // move to abstract /* $this->properties['year'] = new owa_dbColumn; $this->properties['year']->setDataType(OWA_DTD_INT); $this->properties['month'] = new owa_dbColumn; $this->properties['month']->setDataType(OWA_DTD_INT); $this->properties['day'] = new owa_dbColumn; $this->properties['day']->setDataType(OWA_DTD_TINYINT2); $this->properties['dayofweek'] = new owa_dbColumn; $this->properties['dayofweek']->setDataType(OWA_DTD_VARCHAR10); $this->properties['dayofyear'] = new owa_dbColumn; $this->properties['dayofyear']->setDataType(OWA_DTD_INT); $this->properties['weekofyear'] = new owa_dbColumn; $this->properties['weekofyear']->setDataType(OWA_DTD_INT); */ // drop these soon $this->properties['hour'] = new owa_dbColumn(); $this->properties['hour']->setDataType(OWA_DTD_TINYINT2); $this->properties['minute'] = new owa_dbColumn(); $this->properties['minute']->setDataType(OWA_DTD_TINYINT2); // move to abstract $this->properties['last_req'] = new owa_dbColumn(); $this->properties['last_req']->setDataType(OWA_DTD_BIGINT); $this->properties['num_pageviews'] = new owa_dbColumn(); $this->properties['num_pageviews']->setDataType(OWA_DTD_INT); // drop $this->properties['num_comments'] = new owa_dbColumn(); $this->properties['num_comments']->setDataType(OWA_DTD_INT); // move to abstract $this->properties['is_repeat_visitor'] = new owa_dbColumn(); $this->properties['is_repeat_visitor']->setDataType(OWA_DTD_TINYINT); // how to denormalize into other fact tables? $is_bounce = new owa_dbColumn(); $is_bounce->setName('is_bounce'); $is_bounce->setDataType(OWA_DTD_TINYINT); $this->setProperty($is_bounce); // move to abstract $this->properties['is_new_visitor'] = new owa_dbColumn(); $this->properties['is_new_visitor']->setDataType(OWA_DTD_TINYINT); // needed? $this->properties['prior_session_lastreq'] = new owa_dbColumn(); $this->properties['prior_session_lastreq']->setDataType(OWA_DTD_BIGINT); // needed? $prior_session_id = new owa_dbColumn('prior_session_id', OWA_DTD_BIGINT); $this->setProperty($prior_session_id); // drop $this->properties['time_sinse_priorsession'] = new owa_dbColumn(); $this->properties['time_sinse_priorsession']->setDataType(OWA_DTD_INT); // drop $this->properties['prior_session_year'] = new owa_dbColumn(); $this->properties['prior_session_year']->setDataType(OWA_DTD_TINYINT4); // drop $this->properties['prior_session_month'] = new owa_dbColumn(); $this->properties['prior_session_month']->setDataType(OWA_DTD_VARCHAR255); // drop $this->properties['prior_session_day'] = new owa_dbColumn(); $this->properties['prior_session_day']->setDataType(OWA_DTD_TINYINT2); // drop $this->properties['prior_session_dayofweek'] = new owa_dbColumn(); $this->properties['prior_session_dayofweek']->setDataType(OWA_DTD_INT); // drop $this->properties['prior_session_hour'] = new owa_dbColumn(); $this->properties['prior_session_hour']->setDataType(OWA_DTD_TINYINT2); // drop $this->properties['prior_session_minute'] = new owa_dbColumn(); $this->properties['prior_session_minute']->setDataType(OWA_DTD_TINYINT2); // move to abstract //$this->properties['days_since_prior_session'] = new owa_dbColumn; //$this->properties['days_since_prior_session']->setDataType(OWA_DTD_INT); // move to abstract //$this->properties['days_since_first_session'] = new owa_dbColumn; //$this->properties['days_since_first_session']->setDataType(OWA_DTD_INT); // drop $this->properties['os'] = new owa_dbColumn(); $this->properties['os']->setDataType(OWA_DTD_VARCHAR255); // wrong data type // move to abstract // $os_id = new owa_dbColumn('os_id', OWA_DTD_VARCHAR255); // $os_id->setForeignKey('base.os'); // $this->setProperty($os_id); // wrong data type // move to abstract //$ua_id = new owa_dbColumn('ua_id', OWA_DTD_VARCHAR255); //$ua_id->setForeignKey('base.ua'); //$this->setProperty($ua_id); $first_page_id = new owa_dbColumn('first_page_id', OWA_DTD_BIGINT); $first_page_id->setForeignKey('base.document'); $this->setProperty($first_page_id); $last_page_id = new owa_dbColumn('last_page_id', OWA_DTD_BIGINT); $last_page_id->setForeignKey('base.document'); $this->setProperty($last_page_id); // move to abstract //$referer_id = new owa_dbColumn('referer_id', OWA_DTD_BIGINT); //$referer_id->setForeignKey('base.referer'); //$this->setProperty($referer_id); // move to abstract //$referring_search_term_id = new owa_dbColumn('referring_search_term_id', OWA_DTD_BIGINT); //$referring_search_term_id->setForeignKey('base.search_term_dim'); //$this->setProperty($referring_search_term_id); // move to abstract //$ip_address = new owa_dbColumn('ip_address', OWA_DTD_VARCHAR255); //$this->setProperty($ip_address); // drop $this->properties['host'] = new owa_dbColumn(); $this->properties['host']->setDataType(OWA_DTD_VARCHAR255); // move to abstract // wrong data type //$host_id = new owa_dbColumn('host_id', OWA_DTD_VARCHAR255); //$host_id->setForeignKey('base.host'); //$this->setProperty($host_id); //drop $this->properties['city'] = new owa_dbColumn(); $this->properties['city']->setDataType(OWA_DTD_VARCHAR255); //drop $this->properties['country'] = new owa_dbColumn(); $this->properties['country']->setDataType(OWA_DTD_VARCHAR255); // drop $this->properties['site'] = new owa_dbColumn(); $this->properties['site']->setDataType(OWA_DTD_VARCHAR255); // move to abstract //$site_id = new owa_dbColumn('site_id', OWA_DTD_VARCHAR255); //$site_id->setForeignKey('base.site', 'site_id'); //$this->setProperty($site_id); // move to abstract //$nps = new owa_dbColumn('num_prior_sessions', OWA_DTD_INT); //$this->setProperty($nps); //drop $this->properties['is_robot'] = new owa_dbColumn(); $this->properties['is_robot']->setDataType(OWA_DTD_TINYINT); //drop $this->properties['is_browser'] = new owa_dbColumn(); $this->properties['is_browser']->setDataType(OWA_DTD_TINYINT); //drop $this->properties['is_feedreader'] = new owa_dbColumn(); $this->properties['is_feedreader']->setDataType(OWA_DTD_TINYINT); // move to abstract //$medium = new owa_dbColumn('medium',OWA_DTD_VARCHAR255); //$this->setProperty($medium); // move to abstract //$source_id = new owa_dbColumn('source_id', OWA_DTD_BIGINT); //$source_id->setForeignKey('base.source_dim'); //$this->setProperty($source_id); // move to abstract //$ad_id = new owa_dbColumn('ad_id', OWA_DTD_BIGINT); //$ad_id->setForeignKey('base.ad_dim'); //$this->setProperty($ad_id); // move to abstract //$campaign_id = new owa_dbColumn('campaign_id', OWA_DTD_BIGINT); //$campaign_id->setForeignKey('base.campaign_dim'); //$this->setProperty($campaign_id); $this->properties['latest_attributions'] = new owa_dbColumn(); $this->properties['latest_attributions']->setDataType(OWA_DTD_BLOB); // create goal related columns $gcount = owa_coreAPI::getSetting('base', 'numGoals'); for ($num = 1; $num <= $gcount; $num++) { $col_name = 'goal_' . $num; $goal_col = new owa_dbColumn($col_name, OWA_DTD_TINYINT); $this->setProperty($goal_col); $col_name = 'goal_' . $num . '_start'; $goal_col = new owa_dbColumn($col_name, OWA_DTD_TINYINT); $this->setProperty($goal_col); $col_name = 'goal_' . $num . '_value'; $goal_col = new owa_dbColumn($col_name, OWA_DTD_BIGINT); $this->setProperty($goal_col); } $num_goals = new owa_dbColumn('num_goals', OWA_DTD_TINYINT); $this->setProperty($num_goals); $num_goal_starts = new owa_dbColumn('num_goal_starts', OWA_DTD_TINYINT); $this->setProperty($num_goal_starts); $goals_value = new owa_dbColumn('goals_value', OWA_DTD_BIGINT); $this->setProperty($goals_value); // move to abstract //location //$location_id = new owa_dbColumn('location_id', OWA_DTD_BIGINT); //$location_id->setForeignKey('base.location_dim'); //$this->setProperty($location_id); // move to abstract // language //$language = new owa_dbColumn('language', OWA_DTD_VARCHAR255); //$this->setProperty($language); // transaction count $commerce_trans_count = new owa_dbColumn('commerce_trans_count', OWA_DTD_INT); $this->setProperty($commerce_trans_count); // revenue including tax and shipping $commerce_trans_revenue = new owa_dbColumn('commerce_trans_revenue', OWA_DTD_BIGINT); $this->setProperty($commerce_trans_revenue); // revenue excluding tax and shipping $commerce_items_revenue = new owa_dbColumn('commerce_items_revenue', OWA_DTD_BIGINT); $this->setProperty($commerce_items_revenue); // distinct number of items $commerce_items_count = new owa_dbColumn('commerce_items_count', OWA_DTD_INT); $this->setProperty($commerce_items_count); // total quantity of all items $commerce_items_quantity = new owa_dbColumn('commerce_items_quantity', OWA_DTD_INT); $this->setProperty($commerce_items_quantity); // shipping revenue $commerce_shipping_revenue = new owa_dbColumn('commerce_shipping_revenue', OWA_DTD_BIGINT); $this->setProperty($commerce_shipping_revenue); // tax revenue $commerce_tax_revenue = new owa_dbColumn('commerce_tax_revenue', OWA_DTD_BIGINT); $this->setProperty($commerce_tax_revenue); }
function __construct() { $this->setTableName('request'); $this->setSummaryLevel(0); // set common fact table columns $parent_columns = parent::__construct(); foreach ($parent_columns as $pcolumn) { $this->setProperty($pcolumn); } // properties // move to abstract //$this->properties['id'] = new owa_dbColumn; //$this->properties['id']->setDataType(OWA_DTD_BIGINT); //$this->properties['id']->setPrimaryKey(); // move to abstract //$visitor_id = new owa_dbColumn('visitor_id', OWA_DTD_BIGINT); //$visitor_id->setForeignKey('base.visitor'); //$this->setProperty($visitor_id); // move to abstract //$session_id = new owa_dbColumn('session_id', OWA_DTD_BIGINT); //$session_id->setForeignKey('base.session'); //$this->setProperty($session_id); // needed? $inbound_visitor_id = new owa_dbColumn('inbound_visitor_id', OWA_DTD_BIGINT); $inbound_visitor_id->setForeignKey('base.visitor'); $this->setProperty($inbound_visitor_id); // needed? $inbound_session_id = new owa_dbColumn('inbound_session_id', OWA_DTD_BIGINT); //$inbound_session_id->setForeignKey('base.session'); $this->setProperty($inbound_session_id); // needed anymore? $this->properties['feed_subscription_id'] = new owa_dbColumn(); $this->properties['feed_subscription_id']->setDataType(OWA_DTD_BIGINT); // move to abstract //$this->properties['user_name'] = new owa_dbColumn; //$this->properties['user_name']->setDataType(OWA_DTD_VARCHAR255); //drop $this->properties['user_email'] = new owa_dbColumn(); $this->properties['user_email']->setDataType(OWA_DTD_VARCHAR255); // move to abstract //$ts = new owa_dbColumn; //$ts->setName('timestamp'); //$ts->setDataType(OWA_DTD_BIGINT); //$ts->setIndex(); //$this->setProperty($ts); // move to abstract //$yyyymmdd = new owa_dbColumn; //$yyyymmdd->setName('yyyymmdd'); //$yyyymmdd->setDataType(OWA_DTD_INT); //$yyyymmdd->setIndex(); //$this->setProperty($yyyymmdd); //$this->properties['last_req'] = new owa_dbColumn; //$this->properties['last_req']->setDataType(OWA_DTD_BIGINT); /* $this->properties['year'] = new owa_dbColumn; $this->properties['year']->setDataType(OWA_DTD_INT); $this->properties['month'] = new owa_dbColumn; $this->properties['month']->setDataType(OWA_DTD_INT); $this->properties['day'] = new owa_dbColumn; $this->properties['day']->setDataType(OWA_DTD_TINYINT2); $this->properties['dayofweek'] = new owa_dbColumn; $this->properties['dayofweek']->setDataType(OWA_DTD_VARCHAR10); $this->properties['dayofyear'] = new owa_dbColumn; $this->properties['dayofyear']->setDataType(OWA_DTD_INT); $this->properties['weekofyear'] = new owa_dbColumn; $this->properties['weekofyear']->setDataType(OWA_DTD_INT); */ // drop these at some point $this->properties['hour'] = new owa_dbColumn(); $this->properties['hour']->setDataType(OWA_DTD_TINYINT2); $this->properties['minute'] = new owa_dbColumn(); $this->properties['minute']->setDataType(OWA_DTD_TINYINT2); $this->properties['second'] = new owa_dbColumn(); $this->properties['second']->setDataType(OWA_DTD_TINYINT2); $this->properties['msec'] = new owa_dbColumn(); $this->properties['msec']->setDataType(OWA_DTD_INT); // wrong data type // move to abstract //$referer_id = new owa_dbColumn('referer_id', OWA_DTD_VARCHAR255); //$referer_id->setForeignKey('base.referer'); //$this->setProperty($referer_id); // wrong data type $document_id = new owa_dbColumn('document_id', OWA_DTD_VARCHAR255); $document_id->setForeignKey('base.document'); $this->setProperty($document_id); // move to abstract //$site_id = new owa_dbColumn('site_id', OWA_DTD_VARCHAR255); //$site_id->setForeignKey('base.site', 'site_id'); //$this->setProperty($site_id); // drop $this->properties['site'] = new owa_dbColumn(); $this->properties['site']->setDataType(OWA_DTD_VARCHAR255); // move to abstract //$this->properties['ip_address'] = new owa_dbColumn; //$this->properties['ip_address']->setDataType(OWA_DTD_VARCHAR255); // move to abstract // wrong data type -- migrate //$host_id = new owa_dbColumn('host_id', OWA_DTD_VARCHAR255); //$host_id->setForeignKey('base.host'); //$this->setProperty($host_id); // move to abstract // wrong data type //$os_id = new owa_dbColumn('os_id', OWA_DTD_VARCHAR255); //$os_id->setForeignKey('base.os'); //$this->setProperty($os_id); //drop $this->properties['os'] = new owa_dbColumn(); $this->properties['os']->setDataType(OWA_DTD_VARCHAR255); // move to abstract // wrong data type //$ua_id = new owa_dbColumn('ua_id', OWA_DTD_VARCHAR255); //$ua_id->setForeignKey('base.ua'); //$this->setProperty($ua_id); //prior page $prior_document_id = new owa_dbColumn('prior_document_id', OWA_DTD_BIGINT); $prior_document_id->setForeignKey('base.document'); $this->setProperty($prior_document_id); // move to abstract //$nps = new owa_dbColumn('num_prior_sessions', OWA_DTD_INT); //$this->setProperty($nps); // move to abstract //$this->properties['is_new_visitor'] = new owa_dbColumn; //$this->properties['is_new_visitor']->setDataType(OWA_DTD_TINYINT); // move to abstract //$this->properties['is_repeat_visitor'] = new owa_dbColumn; //$this->properties['is_repeat_visitor']->setDataType(OWA_DTD_TINYINT); // drop $this->properties['is_comment'] = new owa_dbColumn(); $this->properties['is_comment']->setDataType(OWA_DTD_TINYINT); $this->properties['is_entry_page'] = new owa_dbColumn(); $this->properties['is_entry_page']->setDataType(OWA_DTD_TINYINT); $this->properties['is_browser'] = new owa_dbColumn(); $this->properties['is_browser']->setDataType(OWA_DTD_TINYINT); $this->properties['is_robot'] = new owa_dbColumn(); $this->properties['is_robot']->setDataType(OWA_DTD_TINYINT); $this->properties['is_feedreader'] = new owa_dbColumn(); $this->properties['is_feedreader']->setDataType(OWA_DTD_TINYINT); //move to abstract //$location_id = new owa_dbColumn('location_id', OWA_DTD_BIGINT); //$location_id->setForeignKey('base.location_dim'); //$this->setProperty($location_id); //move to abstract //$language = new owa_dbColumn('language', OWA_DTD_VARCHAR255); //$this->setProperty($language); }
function __construct() { $this->setTableName('commerce_line_item_fact'); // set common fact table columns $parent_columns = parent::__construct(); foreach ($parent_columns as $pcolumn) { $this->setProperty($pcolumn); } // move to abstract //$id = new owa_dbColumn('id', OWA_DTD_BIGINT); //$id->setPrimaryKey(); //$this->setProperty($id); // move to abstract //$visitor_id = new owa_dbColumn('visitor_id', OWA_DTD_BIGINT); //$visitor_id->setForeignKey('base.visitor'); //$this->setProperty($visitor_id); // move to abstract //$session_id = new owa_dbColumn('session_id', OWA_DTD_BIGINT); //$session_id->setForeignKey('base.session'); //$this->setProperty($session_id); $document_id = new owa_dbColumn('document_id', OWA_DTD_BIGINT); $document_id->setForeignKey('base.document'); $this->setProperty($document_id); // move to abstract //$site_id = new owa_dbColumn('site_id', OWA_DTD_VARCHAR255); //$site_id->setForeignKey('base.site', 'site_id'); //$this->setProperty($site_id); // move to abstract //$ua_id = new owa_dbColumn('ua_id', OWA_DTD_BIGINT); //$ua_id->setForeignKey('base.ua'); //$this->setProperty($ua_id); // move to abstract //$host_id = new owa_dbColumn('host_id', OWA_DTD_BIGINT); //$host_id->setForeignKey('base.host'); //$this->setProperty($host_id); // move to abstract //$os_id = new owa_dbColumn('os_id', OWA_DTD_BIGINT); //$os_id->setForeignKey('base.os'); //$this->setProperty($os_id); // move to abstract //$location_id = new owa_dbColumn('location_id', OWA_DTD_BIGINT); //$location_id->setForeignKey('base.location_dim'); //$this->setProperty($location_id); // move to abstract //$medium = new owa_dbColumn('medium',OWA_DTD_VARCHAR255); //$this->setProperty($medium); // move to abstract //$source_id = new owa_dbColumn('source_id', OWA_DTD_BIGINT); //$source_id->setForeignKey('base.source_dim'); //$this->setProperty($source_id); // move to abstract //$ad_id = new owa_dbColumn('ad_id', OWA_DTD_BIGINT); //$ad_id->setForeignKey('base.ad_dim'); //$this->setProperty($ad_id); // move to abstract //$campaign_id = new owa_dbColumn('campaign_id', OWA_DTD_BIGINT); //$campaign_id->setForeignKey('base.campaign_dim'); //$this->setProperty($campaign_id); // move to abstract //$referring_search_term_id = new owa_dbColumn('referring_search_term_id', OWA_DTD_BIGINT); //$referring_search_term_id->setForeignKey('base.search_term_dim'); //$this->setProperty($referring_search_term_id); // move to abstract //$timestamp = new owa_dbColumn('timestamp', OWA_DTD_INT); //$this->setProperty($timestamp); // move to abstract //$yyyymmdd = new owa_dbColumn('yyyymmdd', OWA_DTD_INT); //$this->setProperty($yyyymmdd); $order_id = new owa_dbColumn('order_id', OWA_DTD_VARCHAR255); $order_id->setIndex(); $this->setProperty($order_id); $sku = new owa_dbColumn('sku', OWA_DTD_VARCHAR255); $this->setProperty($sku); $product_name = new owa_dbColumn('product_name', OWA_DTD_VARCHAR255); $this->setProperty($product_name); $category = new owa_dbColumn('category', OWA_DTD_VARCHAR255); $this->setProperty($category); $unit_price = new owa_dbColumn('unit_price', OWA_DTD_BIGINT); $this->setProperty($unit_price); $quantity = new owa_dbColumn('quantity', OWA_DTD_INT); $this->setProperty($quantity); $item_revenue = new owa_dbColumn('item_revenue', OWA_DTD_BIGINT); $this->setProperty($item_revenue); }