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);
}
