[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup/tables_current.inc.php, 1.2
From: |
nomail |
Subject: |
[Phpgroupware-cvs] property/setup/tables_current.inc.php, 1.2 |
Date: |
Wed, 2 Jun 2004 20:36:31 +0200 |
Update of /property/setup
Added Files:
Branch:
tables_current.inc.php
date: 2004/06/02 18:36:31; author: sigurdne; state: Exp; lines: +1721 -0
Log Message:
no message
=====================================================================
<?php
/**************************************************************************\
* phpGroupWare - property
*
* http://www.phpgroupware.org
*
*
*
* Facilities Management
*
* Written by Sigurd Nes [sigurdne at online.no]
*
*
------------------------------------------------------------------------ *
* Copyright 2000 - 2003 Free Software Foundation, Inc
*
* This program is part of the GNU project, see http://www.gnu.org/
*
*
------------------------------------------------------------------------ *
* This program is free software; you can redistribute it and/or modify
it *
* under the terms of the GNU General Public License as published by the
*
* Free Software Foundation; either version 2 of the License, or (at
your *
* option) any later version.
*
\**************************************************************************/
/**************************************************************************\
* This file should be generated for you by setup. It should not need to be *
* edited by hand. *
\**************************************************************************/
/* $Id: tables_current.inc.php,v 1.2 2004/06/02 18:36:31 sigurdne Exp $ */
/* table array for property */
$phpgw_baseline = array(
'fm_part_of_town' => array(
'fd' => array(
'part_of_town_id' => array('type' =>
'auto','precision' => '2','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => True),
'district_id' => array('type' =>
'int','precision' => '2','nullable' => True)
),
'pk' => array('part_of_town_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_gab_location' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '16','nullable' => False),
'gab_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'address' => array('type' =>
'varchar','precision' => '100','nullable' => True),
'split' => array('type' => 'int','precision' =>
'2','nullable' => True),
'remark' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'Spredning' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('gab_id','location_code'),
'fk' => array(),
'ix' => array('location_code'),
'uc' => array()
),
'fm_meter' => array(
'fd' => array(
'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'num' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'category' => array('type' => 'int','precision'
=> '4','nullable' => False),
'p_num' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'p_entity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_cat_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'location_code' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'remark' => array('type' =>
'varchar','precision' => '255','nullable' => True)
),
'pk' => array('id','location_code'),
'fk' => array(),
'ix' => array('location_code'),
'uc' => array('num')
),
'fm_meter_category' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_streetaddress' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_tenant' => array(
'fd' => array(
'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'first_name' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'last_name' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'category' => array('type' => 'int','precision'
=> '2','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_tenant_category' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_tenant_attribute' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'column_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'input_text' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'list' => array('type' => 'int','precision' =>
'2','nullable' => True),
'location_form' => array('type' =>
'int','precision' => '2','nullable' => True),
'lookup_form' => array('type' =>
'int','precision' => '2','nullable' => True),
'search' => array('type' => 'int','precision'
=> '2','nullable' => True),
'statustext' => array('type' =>
'varchar','precision' => '100','nullable' => False),
'size' => array('type' => 'int','precision' =>
'4','nullable' => True),
'datatype' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'attrib_sort' => array('type' =>
'int','precision' => '4','nullable' => True),
'precision_' => array('type' =>
'int','precision' => '4','nullable' => True),
'scale' => array('type' => 'int','precision' =>
'4','nullable' => True),
'default_value' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'nullable' => array('type' =>
'varchar','precision' => '5','nullable' => False,'default' => 'True')
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_tenant_choice' => array(
'fd' => array(
'attrib_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'value' => array('type' => 'text','nullable' =>
False)
),
'pk' => array('attrib_id','id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_vendor' => array(
'fd' => array(
'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'org_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'email' => array('type' =>
'varchar','precision' => '64','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'klasse' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'category' => array('type' => 'int','precision'
=> '2','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_vendor_category' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_vendor_attribute' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'column_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'input_text' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'list' => array('type' => 'int','precision' =>
'2','nullable' => True),
'location_form' => array('type' =>
'int','precision' => '2','nullable' => True),
'lookup_form' => array('type' =>
'int','precision' => '2','nullable' => True),
'search' => array('type' => 'int','precision'
=> '2','nullable' => True),
'statustext' => array('type' =>
'varchar','precision' => '100','nullable' => False),
'size' => array('type' => 'int','precision' =>
'4','nullable' => True),
'datatype' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'attrib_sort' => array('type' =>
'int','precision' => '4','nullable' => True),
'precision_' => array('type' =>
'int','precision' => '4','nullable' => True),
'scale' => array('type' => 'int','precision' =>
'4','nullable' => True),
'default_value' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'nullable' => array('type' =>
'varchar','precision' => '5','nullable' => False,'default' => 'True')
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_vendor_choice' => array(
'fd' => array(
'attrib_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'value' => array('type' => 'text','nullable' =>
False)
),
'pk' => array('attrib_id','id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_district' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'2','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '20','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_standard_unit' => array(
'fd' => array(
'id' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_location_type' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => True),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'prefix' => array('type' =>
'varchar','precision' => '8','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_location1' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '16','nullable' => False),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
'loc1_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'part_of_town_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'owner_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'status' => array('type' => 'int','precision'
=> '4','nullable' => True),
'remark' => array('type' => 'text','nullable'
=> True)
),
'pk' => array('loc1'),
'fk' => array(),
'ix' => array('location_code'),
'uc' => array()
),
'fm_location1_category' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_location2' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '50','nullable' => False),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
'loc2_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'status' => array('type' => 'int','precision'
=> '4','nullable' => True),
'remark' => array('type' => 'text','nullable'
=> True)
),
'pk' => array('loc1','loc2'),
'fk' => array('loc1' => 'fm_location1.loc1'),
'ix' => array('location_code'),
'uc' => array()
),
'fm_location2_category' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_location3' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '50','nullable' => False),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
'loc3_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'status' => array('type' => 'int','precision'
=> '4','nullable' => True),
'remark' => array('type' => 'text','nullable'
=> True)
),
'pk' => array('loc1','loc2','loc3'),
'fk' => array('loc1' => 'fm_location2.loc1','loc2' =>
'fm_location2.loc2'),
'ix' => array('location_code'),
'uc' => array()
),
'fm_location3_category' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_location4' => array(
'fd' => array(
'location_code' => array('type' =>
'varchar','precision' => '50','nullable' => False),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
'loc4_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
'street_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'street_number' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'status' => array('type' => 'int','precision'
=> '4','nullable' => True),
'remark' => array('type' => 'text','nullable'
=> True)
),
'pk' => array('loc1','loc2','loc3','loc4'),
'fk' => array('loc1' => 'fm_location3.loc1','loc2' =>
'fm_location3.loc2','loc3' => 'fm_location3.loc3'),
'ix' => array('location_code'),
'uc' => array()
),
'fm_location4_category' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_location_config' => array(
'fd' => array(
'column_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'location_type' => array('type' =>
'int','precision' => '4','nullable' => False),
'input_text' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'lookup_form' => array('type' =>
'int','precision' => '2','nullable' => True),
'f_key' => array('type' => 'int','precision' =>
'2','nullable' => True),
'ref_to_category' => array('type' =>
'int','precision' => '2','nullable' => True),
'query_value' => array('type' =>
'int','precision' => '2','nullable' => True),
'reference_table' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'reference_id' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'datatype' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'precision_' => array('type' =>
'int','precision' => '4','nullable' => True),
'scale' => array('type' => 'int','precision' =>
'4','nullable' => True),
'default_value' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'nullable' => array('type' =>
'varchar','precision' => '5','nullable' => False,'default' => 'True')
),
'pk' => array('column_name'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_location_attrib' => array(
'fd' => array(
'type_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'column_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'input_text' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'list' => array('type' => 'int','precision' =>
'2','nullable' => True),
'location_form' => array('type' =>
'int','precision' => '2','nullable' => True),
'lookup_form' => array('type' =>
'int','precision' => '2','nullable' => True),
'statustext' => array('type' =>
'varchar','precision' => '100','nullable' => False),
'size' => array('type' => 'int','precision' =>
'4','nullable' => True),
'datatype' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'attrib_sort' => array('type' =>
'int','precision' => '4','nullable' => True),
'precision_' => array('type' =>
'int','precision' => '4','nullable' => True),
'scale' => array('type' => 'int','precision' =>
'4','nullable' => True),
'default_value' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'nullable' => array('type' =>
'varchar','precision' => '5','nullable' => False,'default' => 'True')
),
'pk' => array('type_id','id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_location_choice' => array(
'fd' => array(
'type_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
'attrib_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'value' => array('type' => 'text','nullable' =>
False)
),
'pk' => array('type_id','attrib_id','id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_building_part' => array(
'fd' => array(
'id' => array('type' => 'varchar','precision'
=> '4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_drawing' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'title' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'drawing_name' => array('type' =>
'varchar','precision' => '50','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => True),
'version' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'drawing_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'status' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'p_num' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'p_entity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_cat_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'location_code' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'floor_id' => array('type' =>
'varchar','precision' => '8','nullable' => False),
'coordinator' => array('type' =>
'int','precision' => '4','nullable' => True),
'vendor_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'branch_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array('location_code'),
'uc' => array()
),
'fm_drawing_status' => array(
'fd' => array(
'id' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_b_account' => array(
'fd' => array(
'id' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'grouping' => array('type' =>
'varchar','precision' => '4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '25','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_dim_d' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '25','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_workorder' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'num' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'project_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => False),
'chapter_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => False),
'start_date' => array('type' =>
'int','precision' => '4','nullable' => False),
'end_date' => array('type' => 'int','precision'
=> '4','nullable' => False),
'coordinator' => array('type' =>
'int','precision' => '4','nullable' => False),
'vendor_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'status' => array('type' =>
'varchar','precision' => '20','nullable' => False,'default' => 'active'),
'descr' => array('type' => 'text','nullable' =>
True),
'title' => array('type' =>
'varchar','precision' => '255','nullable' => False),
'budget' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'calculation' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'deviation' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True),
'act_mtrl_cost' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'act_vendor_cost' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'addition' => array('type' => 'int','precision'
=> '4','nullable' => True),
'rig_addition' => array('type' =>
'int','precision' => '4','nullable' => True),
'account_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'key_fetch' => array('type' =>
'int','precision' => '4','nullable' => True),
'key_deliver' => array('type' =>
'int','precision' => '4','nullable' => True),
'integration' => array('type' =>
'int','precision' => '4','nullable' => True),
'charge_tenant' => array('type' =>
'int','precision' => '2','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_workorder_category' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_drawing_category' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_workorder_status' => array(
'fd' => array(
'id' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_activities' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'num' => array('type' => 'varchar','precision'
=> '25','nullable' => False),
'base_descr' => array('type' =>
'text','nullable' => True),
'unit' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'ns3420' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'remarkreq' => array('type' =>
'varchar','precision' => '5','nullable' => True,'default' => 'N'),
'minperae' => array('type' => 'int','precision'
=> '4','default' => '0','nullable' => True),
'billperae' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'dim_d' => array('type' => 'int','precision' =>
'4','nullable' => True),
'descr' => array('type' => 'text','nullable' =>
True),
'branch_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'agreement_id' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_agreement' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'num' => array('type' => 'varchar','precision'
=> '25','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => False),
'status' => array('type' =>
'varchar','precision' => '15','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_agreement_status' => array(
'fd' => array(
'id' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_activity_price_index' => array(
'fd' => array(
'activity_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'vendor_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'index_count' => array('type' =>
'int','precision' => '4','nullable' => False),
'current_index' => array('type' =>
'int','precision' => '2','nullable' => True),
'this_index' => array('type' =>
'decimal','precision' => '20','scale' => '4','nullable' => True,'default' =>
'0.00'),
'm_cost' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'w_cost' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'total_cost' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'date' => array('type' => 'int','precision' =>
'4','nullable' => True)
),
'pk' => array('activity_id','vendor_id','index_count'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_branch' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'num' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_wo_hours' => array(
'fd' => array(
'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'record' => array('type' => 'int','precision'
=> '4','nullable' => True),
'owner' => array('type' => 'int','precision' =>
'4','nullable' => False),
'workorder_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'activity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'activity_num' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'grouping_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'grouping_descr' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => False),
'hours_descr' => array('type' =>
'varchar','precision' => '255','nullable' => True),
'remark' => array('type' => 'text','nullable'
=> True),
'billperae' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'vendor_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'unit' => array('type' => 'varchar','precision'
=> '6','nullable' => True),
'ns3420_id' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'tolerance' => array('type' =>
'int','precision' => '4','nullable' => True),
'building_part' => array('type' =>
'varchar','precision' => '4','nullable' => True),
'quantity' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True),
'cost' => array('type' => 'decimal','precision'
=> '20','scale' => '2','nullable' => True),
'dim_d' => array('type' => 'int','precision' =>
'4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_wo_h_deviation' => array(
'fd' => array(
'workorder_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'hour_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'amount' => array('type' => 'int','precision'
=> '4','nullable' => False),
'descr' => array('type' => 'text','nullable' =>
True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('workorder_id','hour_id','id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_template' => array(
'fd' => array(
'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '50','nullable' => True),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => True),
'owner' => array('type' => 'int','precision' =>
'4','nullable' => True),
'chapter_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_template_hours' => array(
'fd' => array(
'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'template_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'record' => array('type' => 'int','precision'
=> '4','nullable' => True),
'owner' => array('type' => 'int','precision' =>
'4','nullable' => False),
'workorder_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'activity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'activity_num' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'grouping_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'grouping_descr' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'hours_descr' => array('type' =>
'varchar','precision' => '255','nullable' => True),
'remark' => array('type' => 'text','nullable'
=> True),
'billperae' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'vendor_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'unit' => array('type' => 'varchar','precision'
=> '6','nullable' => True),
'ns3420_id' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'tolerance' => array('type' =>
'int','precision' => '4','nullable' => True),
'building_part' => array('type' =>
'varchar','precision' => '4','nullable' => True),
'quantity' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True),
'cost' => array('type' => 'decimal','precision'
=> '20','scale' => '2','nullable' => True),
'dim_d' => array('type' => 'int','precision' =>
'4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_key_loc' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'num' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_chapter' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_request' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'title' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'project_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_num' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'p_entity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_cat_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'location_code' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
'owner' => array('type' => 'int','precision' =>
'4','nullable' => True),
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True),
'floor' => array('type' =>
'varchar','precision' => '6','nullable' => True),
'address' => array('type' =>
'varchar','precision' => '100','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'budget' => array('type' => 'int','precision'
=> '4','nullable' => True),
'status' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'branch_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'coordinator' => array('type' =>
'int','precision' => '4','nullable' => True),
'd_safety' => array('type' => 'int','precision'
=> '4','nullable' => True),
'd_aesthetics' => array('type' =>
'int','precision' => '4','nullable' => True),
'd_indoor_climate' => array('type' =>
'int','precision' => '4','nullable' => True),
'd_consequential_damage' => array('type' =>
'int','precision' => '4','nullable' => True),
'd_user_gratification' => array('type' =>
'int','precision' => '4','nullable' => True),
'd_residential_environment' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_safety' => array('type' => 'int','precision'
=> '4','nullable' => True),
'p_aesthetics' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_indoor_climate' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_consequential_damage' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_user_gratification' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_residential_environment' => array('type' =>
'int','precision' => '4','nullable' => True),
'c_safety' => array('type' => 'int','precision'
=> '4','nullable' => True),
'c_aesthetics' => array('type' =>
'int','precision' => '4','nullable' => True),
'c_indoor_climate' => array('type' =>
'int','precision' => '4','nullable' => True),
'c_consequential_damage' => array('type' =>
'int','precision' => '4','nullable' => True),
'c_user_gratification' => array('type' =>
'int','precision' => '4','nullable' => True),
'c_residential_environment' => array('type' =>
'int','precision' => '4','nullable' => True),
'authorities_demands' => array('type' =>
'int','precision' => '2','nullable' => True),
'score' => array('type' => 'int','precision' =>
'4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array('location_code'),
'uc' => array()
),
'fm_request_status' => array(
'fd' => array(
'id' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_request_category' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_request_origin' => array(
'fd' => array(
'origin' => array('type' =>
'varchar','precision' => '10','nullable' => False),
'origin_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'request_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('origin','origin_id','request_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_ns3420' => array(
'fd' => array(
'id' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'tekst1' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'enhet' => array('type' =>
'varchar','precision' => '6','nullable' => True),
'tekst2' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'tekst3' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'tekst4' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'tekst5' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'tekst6' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'parent' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'type' => array('type' => 'varchar','precision'
=> '20','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_tts_tickets' => array(
'fd' => array(
'id' => array('type' => 'auto','nullable' =>
False),
'group_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'priority' => array('type' => 'int','precision'
=> '2','nullable' => False),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'assignedto' => array('type' =>
'int','precision' => '4','nullable' => True),
'subject' => array('type' =>
'varchar','precision' => '255','nullable' => True),
'cat_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'billable_hours' => array('type' =>
'decimal','precision' => '8','scale' => '2','nullable' => True),
'billable_rate' => array('type' =>
'decimal','precision' => '8','scale' => '2','nullable' => True),
'status' => array('type' => 'char','precision'
=> '1','nullable' => False),
'details' => array('type' => 'text','nullable'
=> False),
'location_code' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'p_num' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'p_entity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_cat_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'floor' => array('type' =>
'varchar','precision' => '6','nullable' => True),
'address' => array('type' =>
'varchar','precision' => '100','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'finnish_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'finnish_date2' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('id'),
'ix' => array(),
'ix' => array('location_code'),
'uc' => array()
),
'fm_tts_views' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'account_id' => array('type' =>
'varchar','precision' => '40','nullable' => True),
'time' => array('type' => 'int','precision' =>
'4','nullable' => False)
),
'pk' => array(),
'ix' => array(),
'fk' => array(),
'uc' => array()
),
'fm_tts_category' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_ecoart' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'description' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
'ix' => array(),
'fk' => array(),
'uc' => array()
),
'fm_ecoavvik' => array(
'fd' => array(
'bilagsnr' => array('type' => 'int','precision'
=> '4','nullable' => False),
'belop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
False),
'fakturadato' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
'forfallsdato' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
'artid' => array('type' => 'int','precision' =>
'2','nullable' => False),
'godkjentbelop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
True),
'spvend_code' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'oppsynsmannid' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'saksbehandlerid' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'budsjettansvarligid' => array('type' =>
'varchar','precision' => '12','nullable' => False),
'utbetalingid' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'oppsynsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
'saksigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
'budsjettsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
'utbetalingsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
'overftid' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp')
),
'pk' => array('bilagsnr'),
'ix' => array(),
'fk' => array(),
'uc' => array()
),
'fm_ecobilag' => array(
'fd' => array(
'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'bilagsnr' => array('type' => 'int','precision'
=> '4','nullable' => False),
'kidnr' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'typeid' => array('type' => 'int','precision'
=> '2','nullable' => False),
'kildeid' => array('type' => 'int','precision'
=> '2','nullable' => False),
'pmwrkord_code' => array('type' =>
'int','precision' => '2','nullable' => True),
'belop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
False),
'fakturadato' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
'periode' => array('type' => 'int','precision'
=> '2','nullable' => True),
'forfallsdato' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
'fakturanr' => array('type' =>
'varchar','precision' => '15','nullable' => False),
'spbudact_code' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'regtid' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
'artid' => array('type' => 'int','precision' =>
'2','nullable' => False),
'godkjentbelop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
True),
'spvend_code' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'dima' => array('type' => 'varchar','precision'
=> '20','nullable' => True),
'loc1' => array('type' => 'varchar','precision'
=> '10','nullable' => True),
'dimb' => array('type' => 'int','precision' =>
'2','nullable' => True),
'mvakode' => array('type' => 'int','precision'
=> '2','nullable' => True),
'dimd' => array('type' => 'varchar','precision'
=> '5','nullable' => True),
'oppsynsmannid' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'saksbehandlerid' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'budsjettansvarligid' => array('type' =>
'varchar','precision' => '12','nullable' => False),
'utbetalingid' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'oppsynsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
'saksigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
'budsjettsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
'utbetalingsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
'merknad' => array('type' => 'text','nullable'
=> True),
'splitt' => array('type' => 'int','precision'
=> '2','nullable' => True),
'kreditnota' => array('type' =>
'int','precision' => '2','nullable' => True)
),
'pk' => array('id'),
'ix' => array(),
'fk' => array(),
'uc' => array()
),
'fm_ecobilagoverf' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'bilagsnr' => array('type' => 'int','precision'
=> '4','nullable' => False),
'kidnr' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'typeid' => array('type' => 'int','precision'
=> '2','nullable' => False),
'kildeid' => array('type' => 'int','precision'
=> '2','nullable' => False),
'pmwrkord_code' => array('type' =>
'int','precision' => '2','nullable' => True),
'belop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
False),
'fakturadato' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
'periode' => array('type' => 'int','precision'
=> '2','nullable' => True),
'forfallsdato' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
'fakturanr' => array('type' =>
'varchar','precision' => '15','nullable' => False),
'spbudact_code' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'regtid' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
'artid' => array('type' => 'int','precision' =>
'2','nullable' => False),
'godkjentbelop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
True),
'spvend_code' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'dima' => array('type' => 'varchar','precision'
=> '20','nullable' => True),
'loc1' => array('type' => 'varchar','precision'
=> '10','nullable' => True),
'dimb' => array('type' => 'int','precision' =>
'2','nullable' => True),
'mvakode' => array('type' => 'int','precision'
=> '2','nullable' => True),
'dimd' => array('type' => 'varchar','precision'
=> '5','nullable' => True),
'oppsynsmannid' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'saksbehandlerid' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'budsjettansvarligid' => array('type' =>
'varchar','precision' => '12','nullable' => False),
'utbetalingid' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'oppsynsigndato' => array('type' =>
'timestamp','nullable' => True),
'saksigndato' => array('type' =>
'timestamp','nullable' => True),
'budsjettsigndato' => array('type' =>
'timestamp','nullable' => True),
'utbetalingsigndato' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
'overftid' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp'),
'ordrebelop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
False),
'merknad' => array('type' => 'text','nullable'
=> True),
'splitt' => array('type' => 'int','precision'
=> '2','nullable' => True),
'filnavn' => array('type' =>
'varchar','precision' => '255','nullable' => False),
'kreditnota' => array('type' =>
'int','precision' => '2','nullable' => True)
),
'pk' => array('id'),
'ix' => array(),
'fk' => array(),
'uc' => array()
),
'fm_ecobilagkilde' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'2','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'description' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
'ix' => array(),
'fk' => array(),
'uc' => array()
),
'fm_ecobilagtype' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'2','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'description' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
'ix' => array(),
'fk' => array(),
'uc' => array()
),
'fm_ecodimb' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'2','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'description' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
'ix' => array(),
'fk' => array(),
'uc' => array()
),
'fm_ecodimd' => array(
'fd' => array(
'id' => array('type' => 'varchar','precision'
=> '5','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'description' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
'ix' => array(),
'fk' => array(),
'uc' => array()
),
'fm_ecomva' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'2','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'description' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
'ix' => array(),
'fk' => array(),
'uc' => array()
),
'fm_ecologg' => array(
'fd' => array(
'batchid' => array('type' => 'int','precision'
=> '4','nullable' => False),
'ecobilagid' => array('type' =>
'int','precision' => '4','nullable' => True),
'status' => array('type' => 'int','precision'
=> '2','nullable' => True),
'melding' => array('type' =>
'varchar','precision' => '255','nullable' => True),
'tid' => array('type' => 'timestamp','nullable'
=> True,'default' => 'current_timestamp')
),
'pk' => array(),
'ix' => array(),
'fk' => array(),
'uc' => array()
),
'fm_ecouser' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'lid' => array('type' => 'varchar','precision'
=> '25','nullable' => False),
'initials' => array('type' =>
'varchar','precision' => '6','nullable' => True)
),
'pk' => array('id'),
'ix' => array(),
'fk' => array(),
'uc' => array()
),
'fm_acl2' => array(
'fd' => array(
'acl_host' => array('type' => 'int','precision'
=> '4','default' => '0','nullable' => False),
'acl_appid' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
'grantor' => array('type' => 'int','precision'
=> '4','nullable' => True),
'grantor_type' => array('type' =>
'char','precision' => '1','nullable' => True),
'acl_account' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => False),
'acl_location' => array('type' =>
'varchar','precision' => '255','nullable' => False),
'acl_rights' => array('type' =>
'int','precision' => '4','default' => '','nullable' => True),
'acl_type' => array('type' => 'int','precision'
=> '2','default' => '0','nullable' => False),
'acl_data ' => array('type' =>
'text','nullable' => True)
),
'pk' => array(),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_request_priority_key' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'safety' => array('type' => 'int','precision'
=> '4','nullable' => True),
'aesthetics' => array('type' =>
'int','precision' => '4','nullable' => True),
'indoor_climate' => array('type' =>
'int','precision' => '4','nullable' => True),
'consequential_damage' => array('type' =>
'int','precision' => '4','nullable' => True),
'user_gratification' => array('type' =>
'int','precision' => '4','nullable' => True),
'residential_environment' => array('type' =>
'int','precision' => '4','nullable' => True),
'authorities_demands' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_projectbranch' => array(
'fd' => array(
'project_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'branch_id' => array('type' =>
'int','precision' => '4','nullable' => False)
),
'pk' => array('project_id','branch_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_project' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '255','nullable' => False),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => False),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => False),
'start_date' => array('type' =>
'int','precision' => '4','nullable' => False),
'end_date' => array('type' => 'int','precision'
=> '4','nullable' => False),
'coordinator' => array('type' =>
'int','precision' => '4','nullable' => False),
'status' => array('type' =>
'varchar','precision' => '20','nullable' => False,'default' => 'active'),
'descr' => array('type' => 'text','nullable' =>
True),
'budget' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'reserve' => array('type' =>
'decimal','precision' => '20','scale' => '2','nullable' => True,'default' =>
'0.00'),
'p_num' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'p_entity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_cat_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'location_code' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'address' => array('type' =>
'varchar','precision' => '100','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'key_fetch' => array('type' =>
'int','precision' => '4','nullable' => True),
'key_deliver' => array('type' =>
'int','precision' => '4','nullable' => True),
'other_branch' => array('type' =>
'varchar','precision' => '255','nullable' => True),
'key_responsible' => array('type' =>
'int','precision' => '4','nullable' => True),
'charge_tenant' => array('type' =>
'int','precision' => '2','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array('location_code'),
'uc' => array()
),
'fm_project_origin' => array(
'fd' => array(
'origin' => array('type' =>
'varchar','precision' => '10','nullable' => False),
'origin_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'project_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('origin','origin_id','project_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_event_receipt' => array(
'fd' => array(
'cal_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
'year_month_date' => array('type' =>
'int','precision' => '4','nullable' => False),
'datetime_done' => array('type' =>
'int','precision' => '4','nullable' => True),
'datetime_reject' => array('type' =>
'int','precision' => '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True)
),
'pk' => array('cal_id','year_month_date'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_investment' => array(
'fd' => array(
'entity_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'invest_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'entity_type' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'p_num' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'p_entity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_cat_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'location_code' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => True),
'writeoff_year' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('entity_id','invest_id'),
'fk' => array(),
'ix' => array('location_code','entity_id'),
'uc' => array()
),
'fm_investment_value' => array(
'fd' => array(
'entity_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'invest_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'index_count' => array('type' =>
'int','precision' => '4','nullable' => False),
'current_index' => array('type' =>
'int','precision' => '2','nullable' => True),
'this_index' => array('type' =>
'decimal','precision' => '20','scale' => '4','default' => '0','nullable' =>
True),
'initial_value' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
True),
'value' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
True),
'date' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp')
),
'pk' => array('entity_id','invest_id','index_count'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_idgenerator' => array(
'fd' => array(
'name' => array('type' => 'varchar','precision'
=> '30','nullable' => False),
'value' => array('type' => 'int','precision' =>
'4','nullable' => False),
'increment' => array('type' =>
'int','precision' => '4','nullable' => True),
'maxvalue' => array('type' => 'int','precision'
=> '2','nullable' => True),
'descr' => array('type' =>
'varchar','precision' => '30','nullable' => True)
),
'pk' => array('name'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_document' => array(
'fd' => array(
'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'title' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'document_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'link' => array('type' => 'text','nullable' =>
True),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => True),
'version' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'document_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'status' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'p_num' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'p_entity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_cat_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'location_code' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'coordinator' => array('type' =>
'int','precision' => '4','nullable' => True),
'vendor_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'branch_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'category' => array('type' => 'int','precision'
=> '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'access' => array('type' =>
'varchar','precision' => '7','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array('location_code'),
'uc' => array()
),
'fm_document_category' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_document_status' => array(
'fd' => array(
'id' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_acl_location' => array(
'fd' => array(
'id' => array('type' => 'varchar','precision'
=> '12','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => False),
'allow_grant' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_request_history' => array(
'fd' => array(
'history_id' => array('type' =>
'auto','precision' => '4','nullable' => False),
'history_record_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'history_appname' => array('type' =>
'varchar','precision' => '64','nullable' => False),
'history_owner' => array('type' =>
'int','precision' => '4','nullable' => False),
'history_status' => array('type' =>
'char','precision' => '2','nullable' => False),
'history_new_value' => array('type' =>
'text','nullable' => False),
'history_timestamp' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp')
),
'pk' => array('history_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_workorder_history' => array(
'fd' => array(
'history_id' => array('type' =>
'auto','precision' => '4','nullable' => False),
'history_record_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'history_appname' => array('type' =>
'varchar','precision' => '64','nullable' => False),
'history_owner' => array('type' =>
'int','precision' => '4','nullable' => False),
'history_status' => array('type' =>
'char','precision' => '2','nullable' => False),
'history_new_value' => array('type' =>
'text','nullable' => False),
'history_timestamp' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp')
),
'pk' => array('history_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_project_history' => array(
'fd' => array(
'history_id' => array('type' =>
'auto','precision' => '4','nullable' => False),
'history_record_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'history_appname' => array('type' =>
'varchar','precision' => '64','nullable' => False),
'history_owner' => array('type' =>
'int','precision' => '4','nullable' => False),
'history_status' => array('type' =>
'char','precision' => '2','nullable' => False),
'history_new_value' => array('type' =>
'text','nullable' => False),
'history_timestamp' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp')
),
'pk' => array('history_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_tts_history' => array(
'fd' => array(
'history_id' => array('type' =>
'auto','precision' => '4','nullable' => False),
'history_record_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'history_appname' => array('type' =>
'varchar','precision' => '64','nullable' => False),
'history_owner' => array('type' =>
'int','precision' => '4','nullable' => False),
'history_status' => array('type' =>
'char','precision' => '2','nullable' => False),
'history_new_value' => array('type' =>
'text','nullable' => False),
'history_timestamp' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp')
),
'pk' => array('history_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_drawing_history' => array(
'fd' => array(
'history_id' => array('type' =>
'auto','precision' => '4','nullable' => False),
'history_record_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'history_appname' => array('type' =>
'varchar','precision' => '64','nullable' => False),
'history_owner' => array('type' =>
'int','precision' => '4','nullable' => False),
'history_status' => array('type' =>
'char','precision' => '2','nullable' => False),
'history_new_value' => array('type' =>
'text','nullable' => False),
'history_timestamp' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp')
),
'pk' => array('history_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_document_history' => array(
'fd' => array(
'history_id' => array('type' =>
'auto','precision' => '4','nullable' => False),
'history_record_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'history_appname' => array('type' =>
'varchar','precision' => '64','nullable' => False),
'history_owner' => array('type' =>
'int','precision' => '4','nullable' => False),
'history_status' => array('type' =>
'char','precision' => '2','nullable' => False),
'history_new_value' => array('type' =>
'text','nullable' => False),
'history_timestamp' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp')
),
'pk' => array('history_id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_owner' => array(
'fd' => array(
'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'abid' => array('type' => 'int','precision' =>
'4','nullable' => False),
'org_name' => array('type' =>
'varchar','precision' => '50','nullable' => False),
'category' => array('type' => 'int','precision'
=> '4','nullable' => False),
'remark' => array('type' =>
'varchar','precision' => '255','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_owner_category' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '255','nullable' => False)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_owner_attribute' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'column_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'input_text' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'list' => array('type' => 'int','precision' =>
'2','nullable' => True),
'location_form' => array('type' =>
'int','precision' => '2','nullable' => True),
'lookup_form' => array('type' =>
'int','precision' => '2','nullable' => True),
'search' => array('type' => 'int','precision'
=> '2','nullable' => True),
'statustext' => array('type' =>
'varchar','precision' => '100','nullable' => False),
'size' => array('type' => 'int','precision' =>
'4','nullable' => True),
'datatype' => array('type' =>
'varchar','precision' => '10','nullable' => True),
'attrib_sort' => array('type' =>
'int','precision' => '4','nullable' => True),
'precision_' => array('type' =>
'int','precision' => '4','nullable' => True),
'scale' => array('type' => 'int','precision' =>
'4','nullable' => True),
'default_value' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'nullable' => array('type' =>
'varchar','precision' => '5','nullable' => False,'default' => 'True')
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_owner_choice' => array(
'fd' => array(
'attrib_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'value' => array('type' => 'text','nullable' =>
False)
),
'pk' => array('attrib_id','id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_cache' => array(
'fd' => array(
'name' => array('type' => 'varchar','precision'
=> '50','nullable' => False),
'value' => array('type' => 'text','nullable' =>
True)
),
'pk' => array('name'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_entity' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'location_form' => array('type' =>
'int','precision' => '4','nullable' => True),
'documentation' => array('type' =>
'int','precision' => '4','nullable' => True),
'lookup_entity' => array('type' =>
'text','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_entity_attribute' => array(
'fd' => array(
'entity_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'cat_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'column_name' => array('type' =>
'varchar','precision' => '20','nullable' => False),
'input_text' => array('type' =>
'varchar','precision' => '50','nullable' => False),
'statustext' => array('type' =>
'varchar','precision' => '150','nullable' => False),
'datatype' => array('type' =>
'varchar','precision' => '10','nullable' => False),
'list' => array('type' => 'int','precision' =>
'4','nullable' => True),
'attrib_sort' => array('type' =>
'int','precision' => '4','nullable' => True),
'size' => array('type' => 'int','precision' =>
'4','nullable' => True),
'precision_' => array('type' =>
'int','precision' => '4','nullable' => True),
'scale' => array('type' => 'int','precision' =>
'4','nullable' => True),
'default_value' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'nullable' => array('type' =>
'varchar','precision' => '5','nullable' => True)
),
'pk' => array('entity_id','cat_id','id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_entity_category' => array(
'fd' => array(
'entity_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '20','nullable' => True),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'prefix' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'lookup_tenant' => array('type' =>
'int','precision' => '4','nullable' => True),
'tracking' => array('type' => 'int','precision'
=> '4','nullable' => True),
'location_level' => array('type' =>
'int','precision' => '4','nullable' => True),
'fileupload' => array('type' =>
'int','precision' => '4','nullable' => True),
'loc_link' => array('type' => 'int','precision'
=> '4','nullable' => True)
),
'pk' => array('entity_id','id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_entity_choice' => array(
'fd' => array(
'entity_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'cat_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
'attrib_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'value' => array('type' => 'text','nullable' =>
False)
),
'pk' => array('entity_id','cat_id','attrib_id','id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_entity_lookup' => array(
'fd' => array(
'entity_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'location' => array('type' =>
'varchar','precision' => '15','nullable' => False),
'type' => array('type' => 'varchar','precision'
=> '15','nullable' => False)
),
'pk' => array('entity_id','location','type'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_entity_origin' => array(
'fd' => array(
'origin' => array('type' =>
'varchar','precision' => '10','nullable' => False),
'origin_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'entity_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'cat_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' =>
array('origin','origin_id','entity_id','cat_id','id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_entity_1_1' => array(
'fd' => array(
'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'num' => array('type' => 'varchar','precision'
=> '16','nullable' => False),
'p_num' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'p_entity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_cat_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'location_code' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'status' => array('type' => 'int','precision'
=> '4','nullable' => True),
'attribute1' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'attribute2' => array('type' =>
'timestamp','nullable' => True),
'attribute3' => array('type' =>
'int','precision' => '4','nullable' => True),
'attribute4' => array('type' =>
'text','nullable' => True),
'attribute5' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array('location_code'),
'uc' => array()
),
'fm_entity_1_2' => array(
'fd' => array(
'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'num' => array('type' => 'varchar','precision'
=> '16','nullable' => False),
'p_num' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'p_entity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_cat_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'location_code' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'status' => array('type' => 'int','precision'
=> '4','nullable' => True),
'attribute1' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'attribute2' => array('type' =>
'timestamp','nullable' => True),
'attribute3' => array('type' =>
'int','precision' => '4','nullable' => True),
'attribute4' => array('type' =>
'text','nullable' => True),
'attribute5' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array('location_code'),
'uc' => array()
),
'fm_entity_2_1' => array(
'fd' => array(
'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'num' => array('type' => 'varchar','precision'
=> '16','nullable' => False),
'p_num' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'p_entity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_cat_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'location_code' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'status' => array('type' => 'int','precision'
=> '4','nullable' => True),
'attribute1' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'attribute2' => array('type' =>
'timestamp','nullable' => True),
'attribute3' => array('type' =>
'int','precision' => '4','nullable' => True),
'attribute4' => array('type' =>
'text','nullable' => True),
'attribute5' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array('location_code'),
'uc' => array()
),
'fm_entity_2_2' => array(
'fd' => array(
'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
'num' => array('type' => 'varchar','precision'
=> '16','nullable' => False),
'p_num' => array('type' =>
'varchar','precision' => '15','nullable' => True),
'p_entity_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'p_cat_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'location_code' => array('type' =>
'varchar','precision' => '20','nullable' => True),
'loc1' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc2' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc3' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'loc4' => array('type' => 'varchar','precision'
=> '4','nullable' => True),
'address' => array('type' =>
'varchar','precision' => '50','nullable' => True),
'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => True),
'contact_phone' => array('type' =>
'varchar','precision' => '30','nullable' => True),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
'status' => array('type' => 'int','precision'
=> '4','nullable' => True),
'attribute1' => array('type' =>
'varchar','precision' => '12','nullable' => True),
'attribute2' => array('type' =>
'timestamp','nullable' => True),
'attribute3' => array('type' =>
'int','precision' => '4','nullable' => True),
'attribute4' => array('type' =>
'text','nullable' => True),
'attribute5' => array('type' =>
'int','precision' => '4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array('location_code'),
'uc' => array()
),
'fm_custom' => array(
'fd' => array(
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '100','nullable' => False),
'sql' => array('type' => 'text','nullable' =>
False),
'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True)
),
'pk' => array('id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
),
'fm_custom_cols' => array(
'fd' => array(
'custom_id' => array('type' =>
'int','precision' => '4','nullable' => False),
'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
'name' => array('type' => 'varchar','precision'
=> '100','nullable' => False),
'descr' => array('type' =>
'varchar','precision' => '50','nullable' => False),
'sorting' => array('type' => 'int','precision'
=> '4','nullable' => False)
),
'pk' => array('custom_id','id'),
'fk' => array(),
'ix' => array(),
'uc' => array()
)
);
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/setup/tables_current.inc.php, 1.2,
nomail <=