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