function __construct() { $this->setTableName('feed_request'); // properties $this->properties['id'] = new owa_dbColumn(); $this->properties['id']->setDataType(OWA_DTD_BIGINT); $this->properties['id']->setPrimaryKey(); $visitor_id = new owa_dbColumn('visitor_id', OWA_DTD_BIGINT); $visitor_id->setForeignKey('base.visitor'); $this->setProperty($visitor_id); $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); $site_id = new owa_dbColumn('site_id', OWA_DTD_VARCHAR255); $site_id->setForeignKey('base.site', 'site_id'); $this->setProperty($site_id); // wrong data type $ua_id = new owa_dbColumn('ua_id', OWA_DTD_VARCHAR255); $ua_id->setForeignKey('base.ua'); $this->setProperty($ua_id); $host_id = new owa_dbColumn('host_id', OWA_DTD_BIGINT); $host_id->setForeignKey('base.host'); $this->setProperty($host_id); // 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['site'] = new owa_dbColumn(); $this->properties['site']->setDataType(OWA_DTD_VARCHAR255); //drop $this->properties['host'] = new owa_dbColumn(); $this->properties['host']->setDataType(OWA_DTD_VARCHAR255); $this->properties['feed_reader_guid'] = new owa_dbColumn(); $this->properties['feed_reader_guid']->setDataType(OWA_DTD_VARCHAR255); $this->properties['subscription_id'] = new owa_dbColumn(); $this->properties['subscription_id']->setDataType(OWA_DTD_BIGINT); $this->properties['timestamp'] = new owa_dbColumn(); $this->properties['timestamp']->setDataType(OWA_DTD_BIGINT); $yyyymmdd = new owa_dbColumn(); $yyyymmdd->setName('yyyymmdd'); $yyyymmdd->setDataType(OWA_DTD_INT); $yyyymmdd->setIndex(); $this->setProperty($yyyymmdd); $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); $this->properties['year'] = new owa_dbColumn(); $this->properties['year']->setDataType(OWA_DTD_INT); $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); $this->properties['last_req'] = new owa_dbColumn(); $this->properties['last_req']->setDataType(OWA_DTD_BIGINT); $this->properties['feed_format'] = new owa_dbColumn(); $this->properties['feed_format']->setDataType(OWA_DTD_VARCHAR255); //drop $this->properties['ip_address'] = new owa_dbColumn(); $this->properties['ip_address']->setDataType(OWA_DTD_VARCHAR255); //drop $this->properties['os'] = new owa_dbColumn(); $this->properties['os']->setDataType(OWA_DTD_VARCHAR255); $yyyymmdd = new owa_dbColumn(); $yyyymmdd->setName('yyyymmdd'); $yyyymmdd->setDataType(OWA_DTD_INT); $yyyymmdd->setIndex(); $this->setProperty($yyyymmdd); }
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() { $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); }