[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup tables_current.inc.php,1.37
From: |
sigurdne |
Subject: |
[Phpgroupware-cvs] property/setup tables_current.inc.php,1.37 |
Date: |
Sun, 13 Nov 2005 18:21:00 +0100 |
Update of property/setup
Modified Files:
Branch: MAIN
tables_current.inc.php lines: +1979 -1979
Log Message:
no message
====================================================
Index: property/setup/tables_current.inc.php
diff -u property/setup/tables_current.inc.php:1.36
property/setup/tables_current.inc.php:1.37
--- property/setup/tables_current.inc.php:1.36 Tue Nov 1 07:37:44 2005
+++ property/setup/tables_current.inc.php Sun Nov 13 17:21:54 2005
@@ -1,1979 +1,1979 @@
-<?php
- /**
- * phpGroupWare - property: a Facilities Management System.
- *
- * @author Sigurd Nes <address@hidden>
- * @copyright Copyright (C) 2003-2005 Free Software Foundation, Inc.
http://www.fsf.org/
- * @license http://www.gnu.org/licenses/gpl.html GNU General Public
License
- * @internal Development of this application was funded by
http://www.bergen.kommune.no/bbb_/ekstern/
- * @package property
- * @subpackage setup
- * @version $Id$
- */
-
- $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' => '150','nullable' => True),
- 'split' => array('type' => 'int','precision' =>
'2','nullable' => True),
- 'remark' => array('type' =>
'varchar','precision' => '50','nullable' => True),
- 'owner' => array('type' =>
'varchar','precision' => '5','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_streetaddress' => array(
- 'fd' => array(
- 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
- 'descr' => array('type' =>
'varchar','precision' => '150','nullable' => False)
- ),
- 'pk' => array('id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
- 'fm_tenant' => array(
- 'fd' => array(
- 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
- 'member_of' => array('type' =>
'varchar','precision' => '255','nullable' => True),
- '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'
=> '4','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' => 'int','precision' =>
'4','nullable' => False),
- 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'org_name' => array('type' =>
'varchar','precision' => '100','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),
- 'member_of' => array('type' =>
'varchar','precision' => '255','nullable' => True),
- 'category' => array('type' => 'int','precision'
=> '2','nullable' => True),
- 'mva' => array('type' => 'int','precision' =>
'4','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('type' => 'text','nullable' =>
True),
- 'ix' => array('type' => 'text','nullable' =>
True),
- 'uc' => array('type' => 'text','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),
- 'mva' => array('type' => 'int','precision' =>
'4','nullable' => True),
- 'remark' => array('type' => 'text','nullable'
=> True),
- 'kostra_id' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'change_type' => array('type' =>
'int','precision' => '4','nullable' => True),
- ),
- 'pk' => array('loc1'),
- 'fk' => array(),
- 'ix' => array('location_code'),
- 'uc' => array()
- ),
- 'fm_location1_history' => 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),
- 'mva' => array('type' => 'int','precision' =>
'4','nullable' => True),
- 'remark' => array('type' => 'text','nullable'
=> True),
- 'kostra_id' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'change_type' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'exp_date' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp')
- ),
- 'pk' => array(),
- 'fk' => array(),
- 'ix' => array(),
- '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),
- 'change_type' => array('type' =>
'int','precision' => '4','nullable' => True),
- ),
- 'pk' => array('loc1','loc2'),
- 'fk' => array('loc1' => 'fm_location1.loc1'),
- 'ix' => array('location_code'),
- 'uc' => array()
- ),
- 'fm_location2_history' => 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),
- 'change_type' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'exp_date' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp')
- ),
- 'pk' => array(),
- 'fk' => array(),
- 'ix' => array(),
- '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),
- 'change_type' => array('type' =>
'int','precision' => '4','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_history' => 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),
- 'change_type' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'exp_date' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp')
- ),
- 'pk' => array(),
- 'fk' => array(),
- 'ix' => array(),
- '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),
- 'change_type' => array('type' =>
'int','precision' => '4','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_history' => 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),
- 'change_type' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'exp_date' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp')
- ),
- 'pk' => array(),
- 'fk' => array(),
- 'ix' => array(),
- '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),
- 'custom' => array('type' => 'int','precision'
=> '4','nullable' => True),
- '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_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' => '100','nullable' => False),
- 'mva' => array('type' => 'int','precision' =>
'4','nullable' => True),
- 'responsible' => array('type' =>
'int','precision' => '4','nullable' => True),
- ),
- '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' =>
'varchar','precision' => '20','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),
- 'claim_issued' => 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_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_group_id' => array('type' =>
'int','precision' => '4','nullable' => True)
- ),
- 'pk' => array('id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
- 'fm_agreement_group' => 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' => array(
- 'fd' => array(
- 'group_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
- 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
- 'vendor_id' => array('type' =>
'int','precision' => '4','nullable' => False),
- 'name' => array('type' => 'varchar','precision'
=> '100','nullable' => False),
- 'descr' => array('type' => 'text','nullable' =>
True),
- 'status' => array('type' =>
'varchar','precision' => '10','nullable' => True),
- 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'start_date' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'end_date' => array('type' => 'int','precision'
=> '4','nullable' => True),
- 'termination_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)
- ),
- 'pk' => array('group_id','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_agreement_attribute' => array(
- 'fd' => array(
- 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
- 'attrib_detail' => array('type' => 'int',
'precision' => 2,'nullable' => False,'default' => '0'),
- 'list' => array('type' => 'int', 'precision' =>
2,'nullable' => True),
- 'location_form' => array('type' => 'int',
'precision' => 2,'nullable' => True),
- 'lookup_form' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'column_name' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
- 'input_text' => array('type' => 'varchar',
'precision' => 50,'nullable' => False),
- 'statustext' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
- 'size' => array('type' => 'int', 'precision' =>
4,'nullable' => True),
- 'datatype' => array('type' => 'varchar',
'precision' => 10,'nullable' => False),
- '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' => 18,'nullable' => True),
- 'nullable' => array('type' => 'varchar',
'precision' => 5,'nullable' => False,'default' => 'True'),
- 'search' => array('type' => 'int', 'precision'
=> 2,'nullable' => True)
- ),
- 'pk' => array('id','attrib_detail'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
-
- 'fm_agreement_choice' => array(
- 'fd' => array(
- 'attrib_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
- 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
- 'value' => array('type' => 'varchar',
'precision' => 255,'nullable' => True),
- 'attrib_detail' => array('type' => 'int',
'precision' => 2,'nullable' => False,'default' => '0')
- ),
- 'pk' => array('attrib_id','id','attrib_detail'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
-
- 'fm_activity_price_index' => array(
- 'fd' => array(
- 'activity_id' => array('type' =>
'int','precision' => '4','nullable' => False),
- 'agreement_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'),
- 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'index_date' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True)
- ),
- 'pk' =>
array('activity_id','agreement_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),
- 'category' => array('type' => 'int','precision'
=> '4','nullable' => True)
- ),
- 'pk' => array('id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
- 'fm_wo_hours_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_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' => 'text','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' => '150','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),
- 'authorities_demands' => array('type' =>
'int','precision' => '2','default' => '0','nullable' => True),
- 'score' => array('type' => 'int','precision' =>
'4','default' => '0','nullable' => True)
- ),
- 'pk' => array('id'),
- 'fk' => array(),
- 'ix' => array('location_code'),
- 'uc' => array()
- ),
- 'fm_request_condition' => array(
- 'fd' => array(
- 'request_id' => array('type' =>
'int','precision' => '4','nullable' => False),
- 'condition_type' => array('type' =>
'int','precision' => '4','nullable' => False),
- 'degree' => array('type' => 'int','precision'
=> '4','default' => '0','nullable' => True),
- 'probability' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
- 'consequence' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
- 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
- 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
- ),
- 'pk' => array('request_id','condition_type'),
- 'fk' => array(),
- 'ix' => array(),
- '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_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' => '150','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' =>
'int','precision' => '4','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),
- 'forfallsdato' => array('type' =>
'timestamp','nullable' => False),
- '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),
- 'saksigndato' => array('type' =>
'timestamp','nullable' => True),
- 'budsjettsigndato' => array('type' =>
'timestamp','nullable' => True),
- 'utbetalingsigndato' => array('type' =>
'timestamp','nullable' => True),
- 'overftid' => array('type' =>
'timestamp','nullable' => True)
- ),
- '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),
- 'project_id' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'kostra_id' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'pmwrkord_code' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'belop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
False),
- 'fakturadato' => array('type' =>
'timestamp','nullable' => False),
- 'periode' => array('type' => 'int','precision'
=> '2','nullable' => True),
- 'forfallsdato' => array('type' =>
'timestamp','nullable' => False),
- 'fakturanr' => array('type' =>
'varchar','precision' => '15','nullable' => False),
- 'spbudact_code' => array('type' =>
'varchar','precision' => '30','nullable' => True),
- 'regtid' => array('type' =>
'timestamp','nullable' => False),
- '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),
- 'merknad' => array('type' => 'text','nullable'
=> True),
- 'splitt' => array('type' => 'int','precision'
=> '2','nullable' => True),
- 'kreditnota' => array('type' =>
'int','precision' => '2','nullable' => True),
- 'pre_transfer' => array('type' =>
'int','precision' => '2','nullable' => True),
- 'item_type' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'item_id' => array('type' =>
'varchar','precision' => '20','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),
- 'project_id' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'kostra_id' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'pmwrkord_code' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'belop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
False),
- 'fakturadato' => array('type' =>
'timestamp','nullable' => False),
- 'periode' => array('type' => 'int','precision'
=> '2','nullable' => True),
- 'forfallsdato' => array('type' =>
'timestamp','nullable' => False),
- 'fakturanr' => array('type' =>
'varchar','precision' => '15','nullable' => False),
- 'spbudact_code' => array('type' =>
'varchar','precision' => '30','nullable' => True),
- 'regtid' => array('type' =>
'timestamp','nullable' => False),
- '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),
- '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),
- 'item_type' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'item_id' => array('type' =>
'varchar','precision' => '20','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_condition_type' => array(
- 'fd' => array(
- 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
- 'descr' => array('type' =>
'varchar','precision' => '50','nullable' => False),
- 'priority_key' => array('type' =>
'int','precision' => '4','default' => '0','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' => '150','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)
- ),
- 'pk' => array('id'),
- 'fk' => array(),
- 'ix' => array('location_code'),
- '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' => '150','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),
- 'index_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' => '150','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'
=> '20','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_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' => 'int','precision' =>
'4','nullable' => False),
- 'abid' => array('type' => 'int','precision' =>
'4','nullable' => False),
- 'org_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
- 'contact_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
- 'category' => array('type' => 'int','precision'
=> '4','nullable' => False),
- 'member_of' => array('type' =>
'varchar','precision' => '255','nullable' => True),
- '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),
- 'search' => array('type' => 'int','precision'
=> '2','nullable' => True),
- '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),
- 'start_project' => 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_origin' => array(
- 'fd' => array(
- 'origin' => array('type' =>
'varchar','precision' => '12','nullable' => False),
- 'origin_id' => array('type' =>
'int','precision' => '4','nullable' => False),
- 'destination' => array('type' =>
'varchar','precision' => '12','nullable' => False),
- 'destination_id' => array('type' =>
'int','precision' => '4','nullable' => False),
- 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
- 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
- ),
- 'pk' =>
array('origin','origin_id','destination','destination_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'
=> '20','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' => '150','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),
- 'category' => array('type' => 'int','precision'
=> '4','nullable' => False),
- 'ext_system_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
- 'ext_meter_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
- 'remark' => array('type' =>
'varchar','precision' => '255','nullable' => True)
- ),
- 'pk' => array('id'),
- 'fk' => array(),
- 'ix' => array('location_code'),
- 'uc' => array('num')
- ),
-
- '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' => '150','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_3' => 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' => '150','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' => '150','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' => '150','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()
- ),
-
- 'fm_orders' => array(
- 'fd' => array(
- 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
- 'type' => array('type' => 'varchar',
'precision' => 50,'nullable' => False)
- ),
- 'pk' => array('id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
-
- 'fm_s_agreement' => array(
- 'fd' => array(
- 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
- 'vendor_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'name' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
- 'descr' => array('type' => 'text','nullable' =>
True),
- 'status' => array('type' => 'varchar',
'precision' => 10,'nullable' => True),
- 'category' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'member_of' => array('type' =>
'text','nullable' => True),
- 'entry_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'start_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'end_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'termination_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => True),
- 'actual_cost' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True),
- 'account_id' => array('type' => 'varchar',
'precision' => 20,'nullable' => True)
- ),
- 'pk' => array('id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
-
- 'fm_s_agreement_attribute' => array(
- 'fd' => array(
- 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
- 'attrib_detail' => array('type' => 'int',
'precision' => 2,'nullable' => False,'default' => '0'),
- 'list' => array('type' => 'int', 'precision' =>
2,'nullable' => True),
- 'location_form' => array('type' => 'int',
'precision' => 2,'nullable' => True),
- 'lookup_form' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'column_name' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
- 'input_text' => array('type' => 'varchar',
'precision' => 50,'nullable' => False),
- 'statustext' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
- 'size' => array('type' => 'int', 'precision' =>
4,'nullable' => True),
- 'datatype' => array('type' => 'varchar',
'precision' => 10,'nullable' => False),
- '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' => 18,'nullable' => True),
- 'nullable' => array('type' => 'varchar',
'precision' => 5,'nullable' => False,'default' => 'True'),
- 'search' => array('type' => 'int', 'precision'
=> 2,'nullable' => True)
- ),
- 'pk' => array('id','attrib_detail'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
-
- 'fm_s_agreement_category' => array(
- 'fd' => array(
- 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
- 'descr' => array('type' => 'varchar',
'precision' => 50,'nullable' => True)
- ),
- 'pk' => array('id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
-
- 'fm_s_agreement_choice' => array(
- 'fd' => array(
- 'attrib_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
- 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
- 'value' => array('type' => 'varchar',
'precision' => 255,'nullable' => True),
- 'attrib_detail' => array('type' => 'int',
'precision' => 2,'nullable' => False,'default' => '0')
- ),
- 'pk' => array('attrib_id','id','attrib_detail'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
-
- 'fm_s_agreement_detail' => array(
- 'fd' => array(
- 'agreement_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
- 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
- 'location_code' => array('type' => 'varchar',
'precision' => 30,'nullable' => True),
- 'address' => array('type' => 'varchar',
'precision' => 150,'nullable' => True),
- 'p_num' => array('type' => 'varchar',
'precision' => 15,'nullable' => True),
- 'p_entity_id' => array('type' => 'int',
'precision' => 4,'nullable' => True,'default' => '0'),
- 'p_cat_id' => array('type' => 'int',
'precision' => 4,'nullable' => True,'default' => '0'),
- 'descr' => array('type' => 'text','nullable' =>
True),
- 'unit' => array('type' => 'varchar',
'precision' => 10,'nullable' => True),
- 'quantity' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True),
- 'frequency' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => True),
- 'entry_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'test' => array('type' => 'text','nullable' =>
True),
- 'cost' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True)
- ),
- 'pk' => array('agreement_id','id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
-
- 'fm_s_agreement_pricing' => array(
- 'fd' => array(
- 'agreement_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
- 'item_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
- 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
- 'current_index' => array('type' => 'int',
'precision' => 2,'nullable' => True),
- 'this_index' => array('type' => 'decimal',
'precision' => 20, 'scale' => 4,'nullable' => True),
- 'cost' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True),
- 'index_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
- 'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => True),
- 'entry_date' => array('type' => 'int',
'precision' => 4,'nullable' => True)
- ),
- 'pk' => array('agreement_id','item_id','id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
- 'fm_async_method' => array(
- 'fd' => array(
- 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
- 'name' => array('type' => 'varchar','precision'
=> '255','nullable' => False),
- 'data' => array('type' => 'text','nullable' =>
True),
- 'descr' => array('type' => 'text','nullable' =>
True)
- ),
- 'pk' => array('id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
- 'fm_cron_log' => array(
- 'fd' => array(
- 'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
- 'cron' => array('type' => 'int','precision' =>
'2','nullable' => True),
- 'cron_date' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
- 'process' => array('type' =>
'varchar','precision' => '255','nullable' => False),
- 'message' => array('type' => 'text','nullable'
=> True)
- ),
- 'pk' => array('id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
- 'fm_tenant_claim' => array(
- 'fd' => array(
- 'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
- 'project_id' => array('type' =>
'int','precision' => '4','nullable' => False),
- 'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => False),
- 'amount' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
True),
- 'b_account_id' => array('type' =>
'int','precision' => '4','nullable' => True),
- 'category' => array('type' => 'int','precision'
=> '4','nullable' => False),
- 'status' => array('type' =>
'varchar','precision' => '8','nullable' => True),
- 'remark' => array('type' => 'text','nullable'
=> True),
- 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
- 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
- ),
- 'pk' => array('id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- ),
- 'fm_tenant_claim_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_custom_function' => array(
- 'fd' => array(
- 'acl_location' => array('type' =>
'varchar','precision' => '50','nullable' => False),
- 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
- 'descr' => array('type' => 'text','nullable' =>
True),
- 'file_name ' => array('type' =>
'varchar','precision' => '50','nullable' => False),
- 'active' => array('type' => 'int','precision'
=> '2','nullable' => True),
- 'custom_sort' => array('type' =>
'int','precision' => '4','nullable' => True)
- ),
- 'pk' => array('acl_location','id'),
- 'fk' => array(),
- 'ix' => array(),
- 'uc' => array()
- )
- );
+<?php
+ /**
+ * phpGroupWare - property: a Facilities Management System.
+ *
+ * @author Sigurd Nes <address@hidden>
+ * @copyright Copyright (C) 2003-2005 Free Software Foundation, Inc.
http://www.fsf.org/
+ * @license http://www.gnu.org/licenses/gpl.html GNU General Public
License
+ * @internal Development of this application was funded by
http://www.bergen.kommune.no/bbb_/ekstern/
+ * @package property
+ * @subpackage setup
+ * @version $Id$
+ */
+
+ $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' => '150','nullable' => True),
+ 'split' => array('type' => 'int','precision' =>
'2','nullable' => True),
+ 'remark' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'owner' => array('type' =>
'varchar','precision' => '5','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_streetaddress' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'descr' => array('type' =>
'varchar','precision' => '150','nullable' => False)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_tenant' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'member_of' => array('type' =>
'varchar','precision' => '255','nullable' => True),
+ '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'
=> '4','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' => 'int','precision' =>
'4','nullable' => False),
+ 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'org_name' => array('type' =>
'varchar','precision' => '100','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),
+ 'member_of' => array('type' =>
'varchar','precision' => '255','nullable' => True),
+ 'category' => array('type' => 'int','precision'
=> '2','nullable' => True),
+ 'mva' => array('type' => 'int','precision' =>
'4','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('type' => 'text','nullable' =>
True),
+ 'ix' => array('type' => 'text','nullable' =>
True),
+ 'uc' => array('type' => 'text','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),
+ 'mva' => array('type' => 'int','precision' =>
'4','nullable' => True),
+ 'remark' => array('type' => 'text','nullable'
=> True),
+ 'kostra_id' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'change_type' => array('type' =>
'int','precision' => '4','nullable' => True),
+ ),
+ 'pk' => array('loc1'),
+ 'fk' => array(),
+ 'ix' => array('location_code'),
+ 'uc' => array()
+ ),
+ 'fm_location1_history' => 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),
+ 'mva' => array('type' => 'int','precision' =>
'4','nullable' => True),
+ 'remark' => array('type' => 'text','nullable'
=> True),
+ 'kostra_id' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'change_type' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'exp_date' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp')
+ ),
+ 'pk' => array(),
+ 'fk' => array(),
+ 'ix' => array(),
+ '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),
+ 'change_type' => array('type' =>
'int','precision' => '4','nullable' => True),
+ ),
+ 'pk' => array('loc1','loc2'),
+ 'fk' => array('loc1' => 'fm_location1.loc1'),
+ 'ix' => array('location_code'),
+ 'uc' => array()
+ ),
+ 'fm_location2_history' => 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),
+ 'change_type' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'exp_date' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp')
+ ),
+ 'pk' => array(),
+ 'fk' => array(),
+ 'ix' => array(),
+ '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),
+ 'change_type' => array('type' =>
'int','precision' => '4','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_history' => 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),
+ 'change_type' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'exp_date' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp')
+ ),
+ 'pk' => array(),
+ 'fk' => array(),
+ 'ix' => array(),
+ '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),
+ 'change_type' => array('type' =>
'int','precision' => '4','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_history' => 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),
+ 'change_type' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'exp_date' => array('type' =>
'timestamp','nullable' => True,'default' => 'current_timestamp')
+ ),
+ 'pk' => array(),
+ 'fk' => array(),
+ 'ix' => array(),
+ '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),
+ 'custom' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ '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_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' => '100','nullable' => False),
+ 'mva' => array('type' => 'int','precision' =>
'4','nullable' => True),
+ 'responsible' => array('type' =>
'int','precision' => '4','nullable' => True),
+ ),
+ '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' =>
'varchar','precision' => '20','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),
+ 'claim_issued' => 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_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_group_id' => array('type' =>
'int','precision' => '4','nullable' => True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_agreement_group' => 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' => array(
+ 'fd' => array(
+ 'group_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
+ 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'vendor_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'name' => array('type' => 'varchar','precision'
=> '100','nullable' => False),
+ 'descr' => array('type' => 'text','nullable' =>
True),
+ 'status' => array('type' =>
'varchar','precision' => '10','nullable' => True),
+ 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'start_date' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'end_date' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'termination_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)
+ ),
+ 'pk' => array('group_id','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_agreement_attribute' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'attrib_detail' => array('type' => 'int',
'precision' => 2,'nullable' => False,'default' => '0'),
+ 'list' => array('type' => 'int', 'precision' =>
2,'nullable' => True),
+ 'location_form' => array('type' => 'int',
'precision' => 2,'nullable' => True),
+ 'lookup_form' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'column_name' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
+ 'input_text' => array('type' => 'varchar',
'precision' => 50,'nullable' => False),
+ 'statustext' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
+ 'size' => array('type' => 'int', 'precision' =>
4,'nullable' => True),
+ 'datatype' => array('type' => 'varchar',
'precision' => 10,'nullable' => False),
+ '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' => 18,'nullable' => True),
+ 'nullable' => array('type' => 'varchar',
'precision' => 5,'nullable' => False,'default' => 'True'),
+ 'search' => array('type' => 'int', 'precision'
=> 2,'nullable' => True)
+ ),
+ 'pk' => array('id','attrib_detail'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_agreement_choice' => array(
+ 'fd' => array(
+ 'attrib_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'value' => array('type' => 'varchar',
'precision' => 255,'nullable' => True),
+ 'attrib_detail' => array('type' => 'int',
'precision' => 2,'nullable' => False,'default' => '0')
+ ),
+ 'pk' => array('attrib_id','id','attrib_detail'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_activity_price_index' => array(
+ 'fd' => array(
+ 'activity_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'agreement_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'),
+ 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'index_date' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True)
+ ),
+ 'pk' =>
array('activity_id','agreement_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),
+ 'category' => array('type' => 'int','precision'
=> '4','nullable' => True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_wo_hours_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_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' => 'text','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' => '150','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),
+ 'authorities_demands' => array('type' =>
'int','precision' => '2','default' => '0','nullable' => True),
+ 'score' => array('type' => 'int','precision' =>
'4','default' => '0','nullable' => True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array('location_code'),
+ 'uc' => array()
+ ),
+ 'fm_request_condition' => array(
+ 'fd' => array(
+ 'request_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'condition_type' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'degree' => array('type' => 'int','precision'
=> '4','default' => '0','nullable' => True),
+ 'probability' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'consequence' => array('type' =>
'int','precision' => '4','default' => '0','nullable' => True),
+ 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
+ ),
+ 'pk' => array('request_id','condition_type'),
+ 'fk' => array(),
+ 'ix' => array(),
+ '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_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' => '150','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' =>
'int','precision' => '4','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),
+ 'forfallsdato' => array('type' =>
'timestamp','nullable' => False),
+ '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),
+ 'saksigndato' => array('type' =>
'timestamp','nullable' => True),
+ 'budsjettsigndato' => array('type' =>
'timestamp','nullable' => True),
+ 'utbetalingsigndato' => array('type' =>
'timestamp','nullable' => True),
+ 'overftid' => array('type' =>
'timestamp','nullable' => True)
+ ),
+ '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),
+ 'project_id' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'kostra_id' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'pmwrkord_code' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'belop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
False),
+ 'fakturadato' => array('type' =>
'timestamp','nullable' => False),
+ 'periode' => array('type' => 'int','precision'
=> '2','nullable' => True),
+ 'forfallsdato' => array('type' =>
'timestamp','nullable' => False),
+ 'fakturanr' => array('type' =>
'varchar','precision' => '15','nullable' => False),
+ 'spbudact_code' => array('type' =>
'varchar','precision' => '30','nullable' => True),
+ 'regtid' => array('type' =>
'timestamp','nullable' => False),
+ '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),
+ 'merknad' => array('type' => 'text','nullable'
=> True),
+ 'splitt' => array('type' => 'int','precision'
=> '2','nullable' => True),
+ 'kreditnota' => array('type' =>
'int','precision' => '2','nullable' => True),
+ 'pre_transfer' => array('type' =>
'int','precision' => '2','nullable' => True),
+ 'item_type' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'item_id' => array('type' =>
'varchar','precision' => '20','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),
+ 'project_id' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'kostra_id' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'pmwrkord_code' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'belop' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
False),
+ 'fakturadato' => array('type' =>
'timestamp','nullable' => False),
+ 'periode' => array('type' => 'int','precision'
=> '2','nullable' => True),
+ 'forfallsdato' => array('type' =>
'timestamp','nullable' => False),
+ 'fakturanr' => array('type' =>
'varchar','precision' => '15','nullable' => False),
+ 'spbudact_code' => array('type' =>
'varchar','precision' => '30','nullable' => True),
+ 'regtid' => array('type' =>
'timestamp','nullable' => False),
+ '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),
+ '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),
+ 'item_type' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'item_id' => array('type' =>
'varchar','precision' => '20','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_condition_type' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'descr' => array('type' =>
'varchar','precision' => '50','nullable' => False),
+ 'priority_key' => array('type' =>
'int','precision' => '4','default' => '0','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' => '150','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)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array('location_code'),
+ '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' => '150','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),
+ 'index_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' => '150','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'
=> '20','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_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' => 'int','precision' =>
'4','nullable' => False),
+ 'abid' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'org_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'contact_name' => array('type' =>
'varchar','precision' => '50','nullable' => True),
+ 'category' => array('type' => 'int','precision'
=> '4','nullable' => False),
+ 'member_of' => array('type' =>
'varchar','precision' => '255','nullable' => True),
+ '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),
+ 'search' => array('type' => 'int','precision'
=> '2','nullable' => True),
+ '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),
+ 'start_project' => 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_origin' => array(
+ 'fd' => array(
+ 'origin' => array('type' =>
'varchar','precision' => '12','nullable' => False),
+ 'origin_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'destination' => array('type' =>
'varchar','precision' => '12','nullable' => False),
+ 'destination_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => True),
+ 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
+ ),
+ 'pk' =>
array('origin','origin_id','destination','destination_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'
=> '20','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' => '150','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),
+ 'category' => array('type' => 'int','precision'
=> '4','nullable' => False),
+ 'ext_system_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
+ 'ext_meter_id' => array('type' =>
'varchar','precision' => '20','nullable' => False),
+ 'remark' => array('type' =>
'varchar','precision' => '255','nullable' => True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array('location_code'),
+ 'uc' => array('num')
+ ),
+
+ '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' => '150','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_3' => 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' => '150','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' => '150','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' => '150','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()
+ ),
+
+ 'fm_orders' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'type' => array('type' => 'varchar',
'precision' => 50,'nullable' => False)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_s_agreement' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'vendor_id' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'name' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
+ 'descr' => array('type' => 'text','nullable' =>
True),
+ 'status' => array('type' => 'varchar',
'precision' => 10,'nullable' => True),
+ 'category' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'member_of' => array('type' =>
'text','nullable' => True),
+ 'entry_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'start_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'end_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'termination_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => True),
+ 'actual_cost' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True),
+ 'account_id' => array('type' => 'varchar',
'precision' => 20,'nullable' => True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_s_agreement_attribute' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'attrib_detail' => array('type' => 'int',
'precision' => 2,'nullable' => False,'default' => '0'),
+ 'list' => array('type' => 'int', 'precision' =>
2,'nullable' => True),
+ 'location_form' => array('type' => 'int',
'precision' => 2,'nullable' => True),
+ 'lookup_form' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'column_name' => array('type' => 'varchar',
'precision' => 20,'nullable' => False),
+ 'input_text' => array('type' => 'varchar',
'precision' => 50,'nullable' => False),
+ 'statustext' => array('type' => 'varchar',
'precision' => 100,'nullable' => False),
+ 'size' => array('type' => 'int', 'precision' =>
4,'nullable' => True),
+ 'datatype' => array('type' => 'varchar',
'precision' => 10,'nullable' => False),
+ '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' => 18,'nullable' => True),
+ 'nullable' => array('type' => 'varchar',
'precision' => 5,'nullable' => False,'default' => 'True'),
+ 'search' => array('type' => 'int', 'precision'
=> 2,'nullable' => True)
+ ),
+ 'pk' => array('id','attrib_detail'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_s_agreement_category' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'descr' => array('type' => 'varchar',
'precision' => 50,'nullable' => True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_s_agreement_choice' => array(
+ 'fd' => array(
+ 'attrib_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'value' => array('type' => 'varchar',
'precision' => 255,'nullable' => True),
+ 'attrib_detail' => array('type' => 'int',
'precision' => 2,'nullable' => False,'default' => '0')
+ ),
+ 'pk' => array('attrib_id','id','attrib_detail'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_s_agreement_detail' => array(
+ 'fd' => array(
+ 'agreement_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'location_code' => array('type' => 'varchar',
'precision' => 30,'nullable' => True),
+ 'address' => array('type' => 'varchar',
'precision' => 150,'nullable' => True),
+ 'p_num' => array('type' => 'varchar',
'precision' => 15,'nullable' => True),
+ 'p_entity_id' => array('type' => 'int',
'precision' => 4,'nullable' => True,'default' => '0'),
+ 'p_cat_id' => array('type' => 'int',
'precision' => 4,'nullable' => True,'default' => '0'),
+ 'descr' => array('type' => 'text','nullable' =>
True),
+ 'unit' => array('type' => 'varchar',
'precision' => 10,'nullable' => True),
+ 'quantity' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True),
+ 'frequency' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => True),
+ 'entry_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'test' => array('type' => 'text','nullable' =>
True),
+ 'cost' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True)
+ ),
+ 'pk' => array('agreement_id','id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+
+ 'fm_s_agreement_pricing' => array(
+ 'fd' => array(
+ 'agreement_id' => array('type' => 'int',
'precision' => 4,'nullable' => False,'default' => '0'),
+ 'item_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => False,'default' => '0'),
+ 'id' => array('type' => 'int', 'precision' =>
4,'nullable' => False,'default' => '0'),
+ 'current_index' => array('type' => 'int',
'precision' => 2,'nullable' => True),
+ 'this_index' => array('type' => 'decimal',
'precision' => 20, 'scale' => 4,'nullable' => True),
+ 'cost' => array('type' => 'decimal',
'precision' => 20, 'scale' => 2,'nullable' => True),
+ 'index_date' => array('type' => 'int',
'precision' => 4,'nullable' => True),
+ 'user_id' => array('type' => 'int', 'precision'
=> 4,'nullable' => True),
+ 'entry_date' => array('type' => 'int',
'precision' => 4,'nullable' => True)
+ ),
+ 'pk' => array('agreement_id','item_id','id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_async_method' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'name' => array('type' => 'varchar','precision'
=> '255','nullable' => False),
+ 'data' => array('type' => 'text','nullable' =>
True),
+ 'descr' => array('type' => 'text','nullable' =>
True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_cron_log' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
+ 'cron' => array('type' => 'int','precision' =>
'2','nullable' => True),
+ 'cron_date' => array('type' =>
'timestamp','nullable' => False,'default' => 'current_timestamp'),
+ 'process' => array('type' =>
'varchar','precision' => '255','nullable' => False),
+ 'message' => array('type' => 'text','nullable'
=> True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_tenant_claim' => array(
+ 'fd' => array(
+ 'id' => array('type' => 'auto','precision' =>
'4','nullable' => False),
+ 'project_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'tenant_id' => array('type' =>
'int','precision' => '4','nullable' => False),
+ 'amount' => array('type' =>
'decimal','precision' => '20','scale' => '2','default' => '0','nullable' =>
True),
+ 'b_account_id' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'category' => array('type' => 'int','precision'
=> '4','nullable' => False),
+ 'status' => array('type' =>
'varchar','precision' => '8','nullable' => True),
+ 'remark' => array('type' => 'text','nullable'
=> True),
+ 'user_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
+ 'entry_date' => array('type' =>
'int','precision' => '4','nullable' => True)
+ ),
+ 'pk' => array('id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ ),
+ 'fm_tenant_claim_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_custom_function' => array(
+ 'fd' => array(
+ 'acl_location' => array('type' =>
'varchar','precision' => '50','nullable' => False),
+ 'id' => array('type' => 'int','precision' =>
'4','nullable' => False),
+ 'descr' => array('type' => 'text','nullable' =>
True),
+ 'file_name ' => array('type' =>
'varchar','precision' => '50','nullable' => False),
+ 'active' => array('type' => 'int','precision'
=> '2','nullable' => True),
+ 'custom_sort' => array('type' =>
'int','precision' => '4','nullable' => True)
+ ),
+ 'pk' => array('acl_location','id'),
+ 'fk' => array(),
+ 'ix' => array(),
+ 'uc' => array()
+ )
+ );
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/setup tables_current.inc.php,1.37,
sigurdne <=