<?php

//
// Open Web Analytics - An Open Source Web Analytics Framework
//
// Copyright 2006 Peter Adams. All rights reserved.
//
// Licensed under GPL v2.0 http://www.gnu.org/copyleft/gpl.html
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
//
// $Id$
//

/**
 * Commerce Transaction Line Item Fact Entity
 * 
 * @author      Peter Adams <peter@openwebanalytics.com>
 * @copyright   Copyright &copy; 2006 Peter Adams <peter@openwebanalytics.com>
 * @license     http://www.gnu.org/copyleft/gpl.html GPL v2.0
 * @category    owa
 * @package     owa
 * @version		$Revision$	      
 * @since		owa 1.4.0
 */

class owa_commerce_line_item_fact extends owa_entity {
	
	function __construct() {
		
		$this->setTableName('commerce_line_item_fact');
		
		$id = new owa_dbColumn('id', OWA_DTD_BIGINT);
		$id->setPrimaryKey();
		$this->setProperty($id);
		
		$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);
		
		$ua_id = new owa_dbColumn('ua_id', OWA_DTD_BIGINT);
		$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);
		
		$os_id = new owa_dbColumn('os_id', OWA_DTD_BIGINT);
		$os_id->setForeignKey('base.os');
		$this->setProperty($os_id);
		
		$location_id = new owa_dbColumn('location_id', OWA_DTD_BIGINT);
		$location_id->setForeignKey('base.location_dim');
		$this->setProperty($location_id);
		
		$medium = new owa_dbColumn('medium',OWA_DTD_VARCHAR255);
		$this->setProperty($medium);
		
		$source_id = new owa_dbColumn('source_id', OWA_DTD_BIGINT);
		$source_id->setForeignKey('base.source_dim');
		$this->setProperty($source_id);
		
		$ad_id = new owa_dbColumn('ad_id', OWA_DTD_BIGINT);
		$ad_id->setForeignKey('base.ad_dim');
		$this->setProperty($ad_id);
		
		$campaign_id = new owa_dbColumn('campaign_id', OWA_DTD_BIGINT);
		$campaign_id->setForeignKey('base.campaign_dim');
		$this->setProperty($campaign_id);
		
		$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);
		
		$timestamp = new owa_dbColumn('timestamp', OWA_DTD_INT);
		$this->setProperty($timestamp);
		
		$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);
		
	}
}

?>