[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.2
|
From: |
nomail |
|
Subject: |
[Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.2 |
|
Date: |
Fri, 21 May 2004 20:39:45 -0000 |
Update of /property/setup
Modified Files:
Branch:
tables.xml
date: 2004/04/28 06:21:20; author: sigurdne; state: Exp; lines: +1284 -19
Log Message:
no message
=====================================================================
Index: property/setup/tables.xml
diff -u property/setup/tables.xml:1.1.1.1 property/setup/tables.xml:1.1.1.2
--- property/setup/tables.xml:1.1.1.1 Fri Apr 23 08:06:33 2004
+++ property/setup/tables.xml Wed Apr 28 06:21:20 2004
@@ -1,23 +1,1288 @@
<?xml version="1.0"?>
<schema version="0.2">
- <table name="phpgw_property">
- <desc>Table for property</desc>
- <field name="property_id" type="I">
- <descr>A unique ID assigned to each record.</descr>
- <KEY/>
- <AUTOINCREMENT/>
- <NOTNULL/>
- </field>
- <field name="property_owner" type="I"><NOTNULL/></field>
- <field name="property_access" type="C"
size="7"><NOTNULL/></field>
- <field name="property_category" type="I"><NOTNULL/></field>
- <field name="property_content" type="X"><NOTNULL/></field>
- <field name="property_modified" type="T"><NOTNULL/></field>
- <field name="property_created" type="T"><NOTNULL/></field>
- <index name="property_id">
- <descr>Put a unique index on property_id</descr>
- <col>property_id</col>
- <UNIQUE/>
- </index>
+ <table name="fm_part_of_town">
+ <desc>Table desc</desc>
+ <field name="part_of_town_id" type="I"><descr>A unique ID
assigned to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="name" type="V" size="20"></field>
+ <field name="district_id" type="I"></field>
+ </table>
+
+
+ <table name="fm_gab_location">
+ <desc>Table desc</desc>
+ <field name="location_code" type="V"
size="16"><NOTNULL/><KEY/></field>
+ <field name="gab_id" type="V" size="20"><NOTNULL/><KEY/></field>
+ <field name="user_id" type="I"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="loc1" type="V" size="4"></field>
+ <field name="loc2" type="V" size="4"></field>
+ <field name="loc3" type="V" size="4"></field>
+ <field name="loc4" type="V" size="4"></field>
+ <field name="address" type="V" size="100"></field>
+ <field name="split" type="I"></field>
+ <field name="remark" type="V" size="50"></field>
+ <field name="Spredning" type="I"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+
+
+ <table name="fm_meter">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="num" type="V" size="20"><NOTNULL/></field>
+ <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="category" type="I"><NOTNULL/></field>
+ <field name="p_num" type="V" size="15"></field>
+ <field name="p_entity_id" type="I"></field>
+ <field name="p_cat_id" type="I"></field>
+ <field name="location_code" type="V"
size="20"><NOTNULL/><KEY/></field>
+ <field name="loc1" type="V" size="4"></field>
+ <field name="loc2" type="V" size="4"></field>
+ <field name="loc3" type="V" size="4"></field>
+ <field name="loc4" type="V" size="4"></field>
+ <field name="address" type="V" size="50"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="user_id" type="I"></field>
+ <field name="remark" type="V" size="255"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+ <table name="fm_meter_category">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_streetaddress">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="50"><NOTNULL/></field>
+ <index name="id"><col>id</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_tenant">
+ <desc>Table desc</desc>
+ <field name="tenant_id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="first_name" type="C" size="30"></field>
+ <field name="last_name" type="C" size="30"></field>
+ <field name="contact_phone" type="V" size="20"></field>
+ <field name="category" type="I"></field>
+ <field name="Flytte_ID" type="I"></field>
+ <field name="status_eco" type="C" size="2"></field>
+ <field name="status_drift" type="C" size="2"></field>
+ <field name="KontraktTilDato" type="C" size="50"></field>
+ <field name="Fornyelseskode" type="I"></field>
+ <field name="Undernivaa" type="I"></field>
+ <field name="Fornyelseskommentar" type="C" size="150"></field>
+ <field name="AntallNklUtlevert" type="I"></field>
+ <field name="AntallNklInnlevert" type="I"></field>
+ </table>
+
+
+ <table name="fm_tenant_category">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_tenant_status">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="type" type="C" size="1"><NOTNULL/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+
+ <table name="fm_district">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="20"></field>
+ </table>
+
+
+
+ <table name="fm_standard_unit">
+ <desc>Table desc</desc>
+ <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+
+ <table name="fm_location_type">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="name" type="V" size="20"></field>
+ <field name="descr" type="V" size="50"></field>
+ <field name="prefix" type="V" size="8"></field>
+ </table>
+
+ <table name="fm_location1">
+ <desc>Table desc</desc>
+ <field name="location_code" type="V"
size="16"><NOTNULL/></field>
+ <field name="loc1" type="V" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc1_name" type="V" size="50"></field>
+ <field name="part_of_town_id" type="I"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="category" type="I"></field>
+ <field name="user_id" type="I"></field>
+ <field name="owner_id" type="I"></field>
+ <field name="status" type="I"></field>
+ <field name="remark" type="X"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_location1_category">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_location2">
+ <desc>Table desc</desc>
+ <field name="location_code" type="V"
size="50"><NOTNULL/></field>
+ <field name="loc1" type="V" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc2" type="V" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc2_name" type="V" size="50"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="category" type="I"></field>
+ <field name="user_id" type="I"></field>
+ <field name="status" type="I"></field>
+ <field name="remark" type="X"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_location2_category">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ <index name="id"><col>id</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_location3">
+ <desc>Table desc</desc>
+ <field name="location_code" type="V"
size="50"><NOTNULL/></field>
+ <field name="loc1" type="V" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc2" type="V" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc3" type="V" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc3_name" type="V" size="50"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="category" type="I"></field>
+ <field name="user_id" type="I"></field>
+ <field name="status" type="I"></field>
+ <field name="remark" type="X"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_location3_category">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_location4">
+ <desc>Table desc</desc>
+ <field name="location_code" type="V"
size="50"><NOTNULL/></field>
+ <field name="loc1" type="V" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc2" type="V" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc3" type="V" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc4" type="V" size="4"><NOTNULL/><KEY/></field>
+ <field name="loc4_name" type="V" size="50"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="category" type="I"></field>
+ <field name="street_id" type="I"></field>
+ <field name="street_number" type="V" size="10"></field>
+ <field name="user_id" type="I"></field>
+ <field name="tenant_id" type="I"></field>
+ <field name="status" type="I"></field>
+ <field name="remark" type="X"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_location4_category">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_location_config">
+ <desc>Table desc</desc>
+ <field name="column_name" type="V"
size="20"><NOTNULL/><KEY/></field>
+ <field name="location_type" type="I"><NOTNULL/></field>
+ <field name="input_text" type="V" size="20"></field>
+ <field name="lookup_form" type="I"></field>
+ <field name="f_key" type="I"></field>
+ <field name="ref_to_category" type="I"></field>
+ <field name="query_value" type="I"></field>
+ <field name="reference_table" type="V" size="30"></field>
+ <field name="reference_id" type="V" size="15"></field>
+ <field name="datatype" type="V" size="10"></field>
+ <field name="precision_" type="I"></field>
+ <field name="scale" type="I"></field>
+ <field name="default_value" type="V" size="20"></field>
+ <field name="nullable" type="V" size="5" default="True"></field>
+ </table>
+
+
+ <table name="fm_location_attrib">
+ <desc>Table desc</desc>
+ <field name="type_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="column_name" type="V" size="20"><NOTNULL/></field>
+ <field name="input_text" type="V" size="20"><NOTNULL/></field>
+ <field name="list" type="I"></field>
+ <field name="location_form" type="I"></field>
+ <field name="lookup_form" type="I"></field>
+ <field name="statustext" type="V" size="100"><NOTNULL/></field>
+ <field name="size" type="I"></field>
+ <field name="datatype" type="V" size="10"></field>
+ <field name="attrib_sort" type="I"></field>
+ <field name="precision_" type="I"></field>
+ <field name="scale" type="I"></field>
+ <field name="default_value" type="V" size="20"></field>
+ <field name="nullable" type="V" size="5" default="True"></field>
+ </table>
+
+
+ <table name="fm_location_choice">
+ <desc>Table desc</desc>
+ <field name="type_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="attrib_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="value" type="X"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_building_part">
+ <desc>Table desc</desc>
+ <field name="id" type="V" size="4"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="50"></field>
+ </table>
+
+
+ <table name="fm_drawing">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="title" type="V" size="50"></field>
+ <field name="drawing_name" type="V" size="50"><NOTNULL/></field>
+ <field name="descr" type="V" size="255"></field>
+ <field name="version" type="V" size="10"></field>
+ <field name="drawing_date" type="I"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="status" type="V" size="10"></field>
+ <field name="p_num" type="V" size="15"></field>
+ <field name="p_entity_id" type="I"></field>
+ <field name="p_cat_id" type="I"></field>
+ <field name="location_code" type="V"
size="20"><NOTNULL/></field>
+ <field name="address" type="V" size="50"></field>
+ <field name="loc1" type="V" size="4"></field>
+ <field name="loc2" type="V" size="4"></field>
+ <field name="loc3" type="V" size="4"></field>
+ <field name="loc4" type="V" size="4"></field>
+ <field name="floor_id" type="V" size="8"><NOTNULL/></field>
+ <field name="coordinator" type="I"></field>
+ <field name="vendor_id" type="I"></field>
+ <field name="branch_id" type="I"></field>
+ <field name="category" type="I"></field>
+ <field name="user_id" type="I"></field>
+ <field name="access" type="V" size="7"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+ <table name="fm_drawing_status">
+ <desc>Table desc</desc>
+ <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_b_account">
+ <desc>Table desc</desc>
+ <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
+ <field name="grouping" type="V" size="4"><NOTNULL/></field>
+ <field name="descr" type="V" size="25"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_dim_d">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="25"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_workorder">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="num" type="V" size="20"><NOTNULL/></field>
+ <field name="project_id" type="I"><NOTNULL/></field>
+ <field name="user_id" type="I"><NOTNULL/></field>
+ <field name="access" type="V" size="7"></field>
+ <field name="category" type="I"><NOTNULL/></field>
+ <field name="chapter_id" type="I"></field>
+ <field name="entry_date" type="I"><NOTNULL/></field>
+ <field name="start_date" type="I"><NOTNULL/></field>
+ <field name="end_date" type="I"><NOTNULL/></field>
+ <field name="coordinator" type="I"><NOTNULL/></field>
+ <field name="vendor_id" type="I"></field>
+ <field name="status" type="V" size="20"
default="active"><NOTNULL/></field>
+ <field name="descr" type="X"></field>
+ <field name="title" type="V" size="255"><NOTNULL/></field>
+ <field name="budget" type="N" size="20.2"
default="0.00"></field>
+ <field name="calculation" type="N" size="20.2"
default="0.00"></field>
+ <field name="deviation" type="N" size="20.2"></field>
+ <field name="act_mtrl_cost" type="N" size="20.2"
default="0.00"></field>
+ <field name="act_vendor_cost" type="N" size="20.2"
default="0.00"></field>
+ <field name="addition" type="I"></field>
+ <field name="rig_addition" type="I"></field>
+ <field name="account_id" type="I"></field>
+ <field name="key_fetch" type="I"></field>
+ <field name="key_deliver" type="I"></field>
+ <field name="integration" type="I"></field>
+ <field name="charge_tenant" type="I"></field>
+ </table>
+
+
+ <table name="fm_workorder_category">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="50"></field>
+ </table>
+
+
+ <table name="fm_drawing_category">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="50"></field>
+ </table>
+
+
+ <table name="fm_workorder_status">
+ <desc>Table desc</desc>
+ <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_activities">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="num" type="V" size="25"><NOTNULL/></field>
+ <field name="base_descr" type="X"></field>
+ <field name="unit" type="V" size="4"></field>
+ <field name="ns3420" type="V" size="15"></field>
+ <field name="remarkreq" type="V" size="5" default="N"></field>
+ <field name="minperae" type="I" default="0"></field>
+ <field name="billperae" type="N" size="20.2"
default="0.00"></field>
+ <field name="dim_d" type="I"></field>
+ <field name="descr" type="X"></field>
+ <field name="branch_id" type="I"></field>
+ <field name="agreement_id" type="I"></field>
+ </table>
+
+
+ <table name="fm_agreement">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="num" type="V" size="25"><NOTNULL/></field>
+ <field name="descr" type="V" size="50"><NOTNULL/></field>
+ <field name="status" type="V" size="15"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_agreement_status">
+ <desc>Table desc</desc>
+ <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_activity_price_index">
+ <desc>Table desc</desc>
+ <field name="activity_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="vendor_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="index_count" type="I"><NOTNULL/><KEY/></field>
+ <field name="current_index" type="I"></field>
+ <field name="this_index" type="N" size="20.2"
default="0.00"></field>
+ <field name="m_cost" type="N" size="20.2"
default="0.00"></field>
+ <field name="w_cost" type="N" size="20.2"
default="0.00"></field>
+ <field name="total_cost" type="N" size="20.2"
default="0.00"></field>
+ <field name="date" type="I"></field>
+ </table>
+
+
+ <table name="fm_branch">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="num" type="V" size="20"><NOTNULL/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_wo_hours">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="record" type="I"></field>
+ <field name="owner" type="I"><NOTNULL/></field>
+ <field name="workorder_id" type="I"><NOTNULL/></field>
+ <field name="activity_id" type="I"></field>
+ <field name="activity_num" type="V" size="15"></field>
+ <field name="grouping_id" type="I"></field>
+ <field name="grouping_descr" type="V" size="50"></field>
+ <field name="entry_date" type="I"><NOTNULL/></field>
+ <field name="hours_descr" type="V" size="255"></field>
+ <field name="remark" type="X"></field>
+ <field name="billperae" type="N" size="20.2"
default="0.00"></field>
+ <field name="vendor_id" type="I"></field>
+ <field name="unit" type="V" size="6"></field>
+ <field name="ns3420_id" type="V" size="20"></field>
+ <field name="tolerance" type="I"></field>
+ <field name="building_part" type="V" size="4"></field>
+ <field name="quantity" type="N" size="20.2"></field>
+ <field name="cost" type="N" size="20.2"></field>
+ <field name="dim_d" type="I"></field>
+ </table>
+
+
+ <table name="fm_wo_h_deviation">
+ <desc>Table desc</desc>
+ <field name="workorder_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="hour_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="amount" type="I"><NOTNULL/></field>
+ <field name="descr" type="X"></field>
+ <field name="entry_date" type="I"></field>
+ </table>
+
+
+ <table name="fm_template">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="name" type="V" size="50"></field>
+ <field name="descr" type="V" size="255"></field>
+ <field name="owner" type="I"></field>
+ <field name="chapter_id" type="I"></field>
+ <field name="entry_date" type="I"></field>
+ </table>
+
+
+ <table name="fm_template_hours">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="template_id" type="I"><NOTNULL/></field>
+ <field name="record" type="I"></field>
+ <field name="owner" type="I"><NOTNULL/></field>
+ <field name="workorder_id" type="I"><NOTNULL/></field>
+ <field name="activity_id" type="I"></field>
+ <field name="activity_num" type="V" size="15"></field>
+ <field name="grouping_id" type="I"></field>
+ <field name="grouping_descr" type="V" size="50"></field>
+ <field name="hours_descr" type="V" size="255"></field>
+ <field name="remark" type="X"></field>
+ <field name="billperae" type="N" size="20.2"
default="0.00"></field>
+ <field name="vendor_id" type="I"></field>
+ <field name="unit" type="V" size="6"></field>
+ <field name="ns3420_id" type="V" size="20"></field>
+ <field name="tolerance" type="I"></field>
+ <field name="building_part" type="V" size="4"></field>
+ <field name="quantity" type="N" size="20.2"></field>
+ <field name="cost" type="N" size="20.2"></field>
+ <field name="dim_d" type="I"></field>
+ </table>
+
+
+ <table name="fm_key_loc">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="num" type="V" size="20"><NOTNULL/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_chapter">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/></field>
+ <field name="descr" type="V" size="50"><NOTNULL/></field>
+ <index name="id"><col>id</col><UNIQUE/></index>
+ </table>
+
+ <table name="fm_request">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="title" type="V" size="20"></field>
+ <field name="project_id" type="I"></field>
+ <field name="p_num" type="V" size="15"></field>
+ <field name="p_entity_id" type="I"></field>
+ <field name="p_cat_id" type="I"></field>
+ <field name="location_code" type="V" size="20"></field>
+ <field name="loc1" type="V" size="4"></field>
+ <field name="loc2" type="V" size="4"></field>
+ <field name="loc3" type="V" size="4"></field>
+ <field name="loc4" type="V" size="4"></field>
+ <field name="descr" type="V" size="50"></field>
+ <field name="category" type="I"></field>
+ <field name="owner" type="I"></field>
+ <field name="access" type="V" size="7"></field>
+ <field name="floor" type="V" size="6"></field>
+ <field name="address" type="V" size="100"></field>
+ <field name="tenant_id" type="I"></field>
+ <field name="contact_phone" type="V" size="20"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="budget" type="I"></field>
+ <field name="status" type="V" size="10"></field>
+ <field name="branch_id" type="I"></field>
+ <field name="coordinator" type="I"></field>
+ <field name="d_safety" type="I"></field>
+ <field name="d_aesthetics" type="I"></field>
+ <field name="d_indoor_climate" type="I"></field>
+ <field name="d_consequential_damage" type="I"></field>
+ <field name="d_user_gratification" type="I"></field>
+ <field name="d_residential_environment" type="I"></field>
+ <field name="p_safety" type="I"></field>
+ <field name="p_aesthetics" type="I"></field>
+ <field name="p_indoor_climate" type="I"></field>
+ <field name="p_consequential_damage" type="I"></field>
+ <field name="p_user_gratification" type="I"></field>
+ <field name="p_residential_environment" type="I"></field>
+ <field name="c_safety" type="I"></field>
+ <field name="c_aesthetics" type="I"></field>
+ <field name="c_indoor_climate" type="I"></field>
+ <field name="c_consequential_damage" type="I"></field>
+ <field name="c_user_gratification" type="I"></field>
+ <field name="c_residential_environment" type="I"></field>
+ <field name="authorities_demands" type="I"></field>
+ <field name="score" type="I"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_request_status">
+ <desc>Table desc</desc>
+ <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_request_category">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="50"></field>
+ </table>
+
+ <table name="fm_request_origin">
+ <desc>Table desc</desc>
+ <field name="origin" type="V" size="10"><NOTNULL/><KEY/></field>
+ <field name="origin_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="request_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="entry_date" type="I"></field>
+ </table>
+
+
+ <table name="fm_ns3420">
+ <desc>Table desc</desc>
+ <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
+ <field name="tekst1" type="V" size="50"></field>
+ <field name="enhet" type="V" size="6"></field>
+ <field name="tekst2" type="V" size="50"></field>
+ <field name="tekst3" type="V" size="50"></field>
+ <field name="tekst4" type="V" size="50"></field>
+ <field name="tekst5" type="V" size="50"></field>
+ <field name="tekst6" type="V" size="50"></field>
+ <field name="parent" type="V" size="20"></field>
+ <field name="type" type="V" size="20"></field>
+ </table>
+
+
+ <table name="fm_tts_tickets">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="group_id" type="I"></field>
+ <field name="priority" type="I"><NOTNULL/></field>
+ <field name="user_id" type="I"></field>
+ <field name="assignedto" type="I"></field>
+ <field name="subject" type="V" size="255"></field>
+ <field name="cat_id" type="I"></field>
+ <field name="billable_hours" type="N" size="8.2"></field>
+ <field name="billable_rate" type="N" size="8.2"></field>
+ <field name="status" type="C" size="1"><NOTNULL/></field>
+ <field name="details" type="X"><NOTNULL/></field>
+ <field name="location_code" type="V" size="50"></field>
+ <field name="p_num" type="V" size="15"></field>
+ <field name="p_entity_id" type="I"></field>
+ <field name="p_cat_id" type="I"></field>
+ <field name="loc1" type="V" size="4"></field>
+ <field name="loc2" type="V" size="4"></field>
+ <field name="loc3" type="V" size="4"></field>
+ <field name="loc4" type="V" size="4"></field>
+ <field name="floor" type="V" size="6"></field>
+ <field name="address" type="V" size="100"></field>
+ <field name="contact_phone" type="V" size="20"></field>
+ <field name="tenant_id" type="I"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="finnish_date" type="I"></field>
+ <field name="finnish_date2" type="I"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_tts_views">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/></field>
+ <field name="account_id" type="V" size="40"></field>
+ <field name="time" type="I"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_tts_category">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_ecoart">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="description" type="X"></field>
+ </table>
+
+
+
+ <table name="fm_ecoavvik">
+ <desc>Table desc</desc>
+ <field name="bilagsnr" type="I"><NOTNULL/><KEY/></field>
+ <field name="belop" type="N" size="20.2"
default="0"><NOTNULL/></field>
+ <field name="fakturadato" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ <field name="forfallsdato" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ <field name="artid" type="I"><NOTNULL/></field>
+ <field name="godkjentbelop" type="N" size="20.2"
default="0"></field>
+ <field name="spvend_code" type="V" size="12"></field>
+ <field name="oppsynsmannid" type="V" size="12"></field>
+ <field name="saksbehandlerid" type="V" size="12"></field>
+ <field name="budsjettansvarligid" type="V"
size="12"><NOTNULL/></field>
+ <field name="utbetalingid" type="V" size="12"></field>
+ <field name="oppsynsigndato" type="timestamp"></field>
+ <field name="saksigndato" type="timestamp"></field>
+ <field name="budsjettsigndato" type="timestamp"></field>
+ <field name="utbetalingsigndato" type="timestamp"></field>
+ <field name="overftid" type="timestamp"></field>
+ </table>
+
+
+
+ <table name="fm_ecobilag">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/><KEY/></field>
+ <field name="bilagsnr" type="I"><NOTNULL/></field>
+ <field name="kidnr" type="V" size="30"></field>
+ <field name="typeid" type="I"><NOTNULL/></field>
+ <field name="kildeid" type="I"><NOTNULL/></field>
+ <field name="pmwrkord_code" type="I"></field>
+ <field name="belop" type="N" size="20.2"
default="0"><NOTNULL/></field>
+ <field name="fakturadato" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ <field name="periode" type="I"></field>
+ <field name="forfallsdato" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ <field name="fakturanr" type="V" size="15"><NOTNULL/></field>
+ <field name="spbudact_code" type="V" size="30"></field>
+ <field name="regtid" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ <field name="artid" type="I"><NOTNULL/></field>
+ <field name="godkjentbelop" type="N" size="20.2"
default="0"></field>
+ <field name="spvend_code" type="V" size="12"></field>
+ <field name="dima" type="V" size="20"></field>
+ <field name="loc1" type="V" size="10"></field>
+ <field name="dimb" type="I"></field>
+ <field name="mvakode" type="I"></field>
+ <field name="dimd" type="V" size="5"></field>
+ <field name="oppsynsmannid" type="V" size="12"></field>
+ <field name="saksbehandlerid" type="V" size="12"></field>
+ <field name="budsjettansvarligid" type="V"
size="12"><NOTNULL/></field>
+ <field name="utbetalingid" type="V" size="12"></field>
+ <field name="oppsynsigndato" type="timestamp"></field>
+ <field name="saksigndato" type="timestamp"></field>
+ <field name="budsjettsigndato" type="timestamp"></field>
+ <field name="utbetalingsigndato" type="timestamp"></field>
+ <field name="merknad" type="X"></field>
+ <field name="splitt" type="I"></field>
+ <field name="kreditnota" type="I"></field>
+ </table>
+
+
+ <table name="fm_ecobilagoverf">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="bilagsnr" type="I"><NOTNULL/></field>
+ <field name="kidnr" type="V" size="30"></field>
+ <field name="typeid" type="I"><NOTNULL/></field>
+ <field name="kildeid" type="I"><NOTNULL/></field>
+ <field name="pmwrkord_code" type="I"></field>
+ <field name="belop" type="N" size="20.2"
default="0"><NOTNULL/></field>
+ <field name="fakturadato" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ <field name="periode" type="I"></field>
+ <field name="forfallsdato" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ <field name="fakturanr" type="V" size="15"><NOTNULL/></field>
+ <field name="spbudact_code" type="V" size="30"></field>
+ <field name="regtid" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ <field name="artid" type="I"><NOTNULL/></field>
+ <field name="godkjentbelop" type="N" size="20.2"
default="0"></field>
+ <field name="spvend_code" type="V" size="12"></field>
+ <field name="dima" type="V" size="20"></field>
+ <field name="loc1" type="V" size="10"></field>
+ <field name="dimb" type="I"></field>
+ <field name="mvakode" type="I"></field>
+ <field name="dimd" type="V" size="5"></field>
+ <field name="oppsynsmannid" type="V" size="12"></field>
+ <field name="saksbehandlerid" type="V" size="12"></field>
+ <field name="budsjettansvarligid" type="V"
size="12"><NOTNULL/></field>
+ <field name="utbetalingid" type="V" size="12"></field>
+ <field name="oppsynsigndato" type="timestamp"></field>
+ <field name="saksigndato" type="timestamp"></field>
+ <field name="budsjettsigndato" type="timestamp"></field>
+ <field name="utbetalingsigndato" type="timestamp"></field>
+ <field name="overftid" type="timestamp"></field>
+ <field name="ordrebelop" type="N" size="20.2"
default="0"><NOTNULL/></field>
+ <field name="merknad" type="X"></field>
+ <field name="splitt" type="I"></field>
+ <field name="filnavn" type="V" size="255"><NOTNULL/></field>
+ <field name="kreditnota" type="I"></field>
+ </table>
+
+
+
+ <table name="fm_ecobilagkilde">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="description" type="X"></field>
+ </table>
+
+
+
+ <table name="fm_ecobilagtype">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="description" type="X"></field>
+
+ </table>
+
+
+ <table name="fm_ecodimb">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="description" type="X"></field>
+ </table>
+
+
+
+ <table name="fm_ecodimd">
+ <desc>Table desc</desc>
+ <field name="id" type="V" size="5"><NOTNULL/><KEY/></field>
+ <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="description" type="X"></field>
+ </table>
+
+
+
+ <table name="fm_ecomva">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="description" type="X"></field>
+ </table>
+
+
+ <table name="fm_ecologg">
+ <desc>Table desc</desc>
+ <field name="batchid" type="I"><NOTNULL/></field>
+ <field name="ecobilagid" type="I"></field>
+ <field name="status" type="I"></field>
+ <field name="melding" type="V" size="255"></field>
+ <field name="tid" type="timestamp"></field>
+ </table>
+
+
+ <table name="fm_ecouser">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="lid" type="V" size="25"><NOTNULL/></field>
+ <field name="initials" type="V" size="6"></field>
+ </table>
+
+
+ <table name="fm_acl2">
+ <desc>Table desc</desc>
+ <field name="acl_host" type="I" default="0"><NOTNULL/></field>
+ <field name="acl_appid" type="I" default="0"><NOTNULL/></field>
+ <field name="grantor" type="I"></field>
+ <field name="grantor_type" type="C" size="1"></field>
+ <field name="acl_account" type="I"
default="0"><NOTNULL/></field>
+ <field name="acl_location" type="V"
size="255"><NOTNULL/></field>
+ <field name="acl_rights" type="I"></field>
+ <field name="acl_type" type="I" default="0"><NOTNULL/></field>
+ <field name="acl_data " type="X"></field>
+ </table>
+
+
+ <table name="fm_request_priority_key">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="safety" type="I"></field>
+ <field name="aesthetics" type="I"></field>
+ <field name="indoor_climate" type="I"></field>
+ <field name="consequential_damage" type="I"></field>
+ <field name="user_gratification" type="I"></field>
+ <field name="residential_environment" type="I"></field>
+ <field name="authorities_demands" type="I"></field>
+ </table>
+
+
+ <table name="fm_projectbranch">
+ <desc>Table desc</desc>
+ <field name="project_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="branch_id" type="I"><NOTNULL/><KEY/></field>
+ </table>
+
+
+ <table name="fm_project">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="name" type="V" size="255"><NOTNULL/></field>
+ <field name="user_id" type="I"><NOTNULL/></field>
+ <field name="access" type="V" size="7"></field>
+ <field name="category" type="I"><NOTNULL/></field>
+ <field name="entry_date" type="I"><NOTNULL/></field>
+ <field name="start_date" type="I"><NOTNULL/></field>
+ <field name="end_date" type="I"><NOTNULL/></field>
+ <field name="coordinator" type="I"><NOTNULL/></field>
+ <field name="status" type="V" size="20"
default="active"><NOTNULL/></field>
+ <field name="descr" type="X"></field>
+ <field name="budget" type="N" size="20.2"
default="0.00"></field>
+ <field name="reserve" type="N" size="20.2"
default="0.00"></field>
+ <field name="p_num" type="V" size="15"></field>
+ <field name="p_entity_id" type="I"></field>
+ <field name="p_cat_id" type="I"></field>
+ <field name="location_code" type="V" size="20"></field>
+ <field name="loc1" type="V" size="4"></field>
+ <field name="loc2" type="V" size="4"></field>
+ <field name="loc3" type="V" size="4"></field>
+ <field name="loc4" type="V" size="4"></field>
+ <field name="address" type="V" size="100"></field>
+ <field name="tenant_id" type="I"></field>
+ <field name="contact_phone" type="V" size="20"></field>
+ <field name="key_fetch" type="I"></field>
+ <field name="key_deliver" type="I"></field>
+ <field name="other_branch" type="V" size="255"></field>
+ <field name="key_responsible" type="I"></field>
+ <field name="charge_tenant" type="I"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_project_origin">
+ <desc>Table desc</desc>
+ <field name="origin" type="V" size="10"><NOTNULL/><KEY/></field>
+ <field name="origin_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="project_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="entry_date" type="I"></field>
+ </table>
+
+
+ <table name="fm_event_receipt">
+ <desc>Table desc</desc>
+ <field name="cal_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="year_month_date" type="I"><NOTNULL/><KEY/></field>
+ <field name="datetime_done" type="I"></field>
+ <field name="datetime_reject" type="I"></field>
+ <field name="user_id" type="I"></field>
+ </table>
+
+
+ <table name="fm_investment">
+ <desc>Table desc</desc>
+ <field name="entity_id" type="V"
size="20"><NOTNULL/><KEY/></field>
+ <field name="invest_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="entity_type" type="V" size="20"></field>
+ <field name="p_num" type="V" size="15"></field>
+ <field name="p_entity_id" type="I"></field>
+ <field name="p_cat_id" type="I"></field>
+ <field name="location_code" type="V" size="20"></field>
+ <field name="loc1" type="V" size="4"></field>
+ <field name="loc2" type="V" size="4"></field>
+ <field name="loc3" type="V" size="4"></field>
+ <field name="loc4" type="V" size="4"></field>
+ <field name="address" type="V" size="50"></field>
+ <field name="descr" type="V" size="255"></field>
+ <field name="writeoff_year" type="I"></field>
+ <index
name="location_code"><col>location_code</col><col>entity_id</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_investment_value">
+ <desc>Table desc</desc>
+ <field name="entity_id" type="V"
size="20"><NOTNULL/><KEY/></field>
+ <field name="invest_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="index_count" type="I"><NOTNULL/><KEY/></field>
+ <field name="current_index" type="I"></field>
+ <field name="this_index" type="N" size="20.4"
default="0"></field>
+ <field name="initial_value" type="N" size="20.2"
default="0"></field>
+ <field name="value" type="N" size="20.2" default="0"></field>
+ <field name="date" type="timestamp"></field>
+ </table>
+
+
+ <table name="fm_idgenerator">
+ <desc>Table desc</desc>
+ <field name="name" type="V" size="30"><NOTNULL/><KEY/></field>
+ <field name="value" type="I"><NOTNULL/></field>
+ <field name="increment" type="I"></field>
+ <field name="maxvalue" type="I"></field>
+ <field name="descr" type="V" size="30"></field>
+ </table>
+
+
+ <table name="fm_document">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="title" type="V" size="50"></field>
+ <field name="document_name" type="V" size="50"></field>
+ <field name="link" type="X"></field>
+ <field name="descr" type="V" size="255"></field>
+ <field name="version" type="V" size="10"></field>
+ <field name="document_date" type="I"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="status" type="V" size="10"></field>
+ <field name="p_num" type="V" size="15"></field>
+ <field name="p_entity_id" type="I"></field>
+ <field name="p_cat_id" type="I"></field>
+ <field name="location_code" type="V"
size="20"><NOTNULL/></field>
+ <field name="loc1" type="V" size="4"></field>
+ <field name="loc2" type="V" size="4"></field>
+ <field name="loc3" type="V" size="4"></field>
+ <field name="loc4" type="V" size="4"></field>
+ <field name="address" type="V" size="50"></field>
+ <field name="coordinator" type="I"></field>
+ <field name="vendor_id" type="I"></field>
+ <field name="branch_id" type="I"></field>
+ <field name="category" type="I"></field>
+ <field name="user_id" type="I"></field>
+ <field name="access" type="V" size="7"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_document_category">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="50"></field>
+ </table>
+
+
+ <table name="fm_document_status">
+ <desc>Table desc</desc>
+ <field name="id" type="V" size="20"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_acl_location">
+ <desc>Table desc</desc>
+ <field name="id" type="V" size="12"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="50"><NOTNULL/></field>
+ <field name="allow_grant" type="I"></field>
+ </table>
+
+
+ <table name="fm_request_history">
+ <desc>Table desc</desc>
+ <field name="history_id" type="I"><descr>A unique ID assigned
to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="history_record_id" type="I"><NOTNULL/></field>
+ <field name="history_appname" type="V"
size="64"><NOTNULL/></field>
+ <field name="history_owner" type="I"><NOTNULL/></field>
+ <field name="history_status" type="C"
size="2"><NOTNULL/></field>
+ <field name="history_new_value" type="X"><NOTNULL/></field>
+ <field name="history_timestamp" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_workorder_history">
+ <desc>Table desc</desc>
+ <field name="history_id" type="I"><descr>A unique ID assigned
to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="history_record_id" type="I"><NOTNULL/></field>
+ <field name="history_appname" type="V"
size="64"><NOTNULL/></field>
+ <field name="history_owner" type="I"><NOTNULL/></field>
+ <field name="history_status" type="C"
size="2"><NOTNULL/></field>
+ <field name="history_new_value" type="X"><NOTNULL/></field>
+ <field name="history_timestamp" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_project_history">
+ <desc>Table desc</desc>
+ <field name="history_id" type="I"><descr>A unique ID assigned
to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="history_record_id" type="I"><NOTNULL/></field>
+ <field name="history_appname" type="V"
size="64"><NOTNULL/></field>
+ <field name="history_owner" type="I"><NOTNULL/></field>
+ <field name="history_status" type="C"
size="2"><NOTNULL/></field>
+ <field name="history_new_value" type="X"><NOTNULL/></field>
+ <field name="history_timestamp" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_tts_history">
+ <desc>Table desc</desc>
+ <field name="history_id" type="I"><descr>A unique ID assigned
to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="history_record_id" type="I"><NOTNULL/></field>
+ <field name="history_appname" type="V"
size="64"><NOTNULL/></field>
+ <field name="history_owner" type="I"><NOTNULL/></field>
+ <field name="history_status" type="C"
size="2"><NOTNULL/></field>
+ <field name="history_new_value" type="X"><NOTNULL/></field>
+ <field name="history_timestamp" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_drawing_history">
+ <desc>Table desc</desc>
+ <field name="history_id" type="I"><descr>A unique ID assigned
to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="history_record_id" type="I"><NOTNULL/></field>
+ <field name="history_appname" type="V"
size="64"><NOTNULL/></field>
+ <field name="history_owner" type="I"><NOTNULL/></field>
+ <field name="history_status" type="C"
size="2"><NOTNULL/></field>
+ <field name="history_new_value" type="X"><NOTNULL/></field>
+ <field name="history_timestamp" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_document_history">
+ <desc>Table desc</desc>
+ <field name="history_id" type="I"><descr>A unique ID assigned
to record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="history_record_id" type="I"><NOTNULL/></field>
+ <field name="history_appname" type="V"
size="64"><NOTNULL/></field>
+ <field name="history_owner" type="I"><NOTNULL/></field>
+ <field name="history_status" type="C"
size="2"><NOTNULL/></field>
+ <field name="history_new_value" type="X"><NOTNULL/></field>
+ <field name="history_timestamp" type="T" default=
"DEFTIMESTAMP"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_owner">
+ <desc>Table desc</desc>
+ <field name="owner_id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="abid" type="I"><NOTNULL/></field>
+ <field name="org_name" type="V" size="50"><NOTNULL/></field>
+ <field name="category" type="I"><NOTNULL/></field>
+ <field name="remark" type="V" size="255"></field>
+ <field name="entry_date" type="I"></field>
+ </table>
+
+
+
+ <table name="fm_owner_category">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="descr" type="V" size="255"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_cache">
+ <desc>Table desc</desc>
+ <field name="name" type="V" size="50"><NOTNULL/><KEY/></field>
+ <field name="value" type="X"></field>
+ </table>
+
+
+ <table name="fm_entity">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="name" type="V" size="20"><NOTNULL/></field>
+ <field name="descr" type="V" size="50"></field>
+ <field name="location_form" type="I"></field>
+ <field name="documentation" type="I"></field>
+ <field name="lookup_entity" type="X"></field>
+ </table>
+
+
+ <table name="fm_entity_attribute">
+ <desc>Table desc</desc>
+ <field name="entity_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="cat_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="column_name" type="V" size="20"><NOTNULL/></field>
+ <field name="input_text" type="V" size="50"><NOTNULL/></field>
+ <field name="statustext" type="V" size="150"><NOTNULL/></field>
+ <field name="datatype" type="V" size="2"><NOTNULL/></field>
+ <field name="list" type="I"></field>
+ <field name="attrib_sort" type="I"></field>
+ <field name="size" type="I"></field>
+ <field name="precision_" type="I"></field>
+ <field name="scale" type="I"></field>
+ <field name="default_value" type="V" size="20"></field>
+ <field name="nullable" type="V" size="5"></field>
+ </table>
+
+
+ <table name="fm_entity_category">
+ <desc>Table desc</desc>
+ <field name="entity_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="name" type="V" size="20"></field>
+ <field name="descr" type="V" size="50"></field>
+ <field name="prefix" type="V" size="50"></field>
+ <field name="lookup_tenant" type="I"></field>
+ <field name="tracking" type="I"></field>
+ <field name="location_level" type="I"></field>
+ <field name="fileupload" type="I"></field>
+ <field name="loc_link" type="I"></field>
+ </table>
+
+
+ <table name="fm_entity_choice">
+ <desc>Table desc</desc>
+ <field name="entity_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="cat_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="attrib_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="value" type="X"><NOTNULL/></field>
+ </table>
+
+
+ <table name="fm_entity_lookup">
+ <desc>Table desc</desc>
+ <field name="entity_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="location" type="V"
size="15"><NOTNULL/><KEY/></field>
+ <field name="type" type="V" size="15"><NOTNULL/><KEY/></field>
+ </table>
+
+
+ <table name="fm_entity_origin">
+ <desc>Table desc</desc>
+ <field name="origin" type="V" size="10"><NOTNULL/><KEY/></field>
+ <field name="origin_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="entity_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="cat_id" type="I"><NOTNULL/><KEY/></field>
+ <field name="id" type="I"><NOTNULL/><KEY/></field>
+ <field name="entry_date" type="I"></field>
+ </table>
+
+
+ <table name="fm_entity_1_1">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="num" type="V" size="16"><NOTNULL/></field>
+ <field name="p_num" type="V" size="15"></field>
+ <field name="p_entity_id" type="I"></field>
+ <field name="p_cat_id" type="I"></field>
+ <field name="location_code" type="V" size="20"></field>
+ <field name="loc1" type="V" size="4"></field>
+ <field name="loc2" type="V" size="4"></field>
+ <field name="loc3" type="V" size="4"></field>
+ <field name="loc4" type="V" size="4"></field>
+ <field name="address" type="V" size="50"></field>
+ <field name="tenant_id" type="I"></field>
+ <field name="contact_phone" type="V" size="30"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="user_id" type="I"></field>
+ <field name="status" type="I"></field>
+ <field name="attribute1" type="V" size="12"></field>
+ <field name="attribute2" type="timestamp"></field>
+ <field name="attribute3" type="I"></field>
+ <field name="attribute4" type="X"></field>
+ <field name="attribute5" type="I"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_entity_1_2">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="num" type="V" size="16"><NOTNULL/></field>
+ <field name="p_num" type="V" size="15"></field>
+ <field name="p_entity_id" type="I"></field>
+ <field name="p_cat_id" type="I"></field>
+ <field name="location_code" type="V" size="20"></field>
+ <field name="loc1" type="V" size="4"></field>
+ <field name="loc2" type="V" size="4"></field>
+ <field name="loc3" type="V" size="4"></field>
+ <field name="loc4" type="V" size="4"></field>
+ <field name="address" type="V" size="50"></field>
+ <field name="tenant_id" type="I"></field>
+ <field name="contact_phone" type="V" size="30"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="user_id" type="I"></field>
+ <field name="status" type="I"></field>
+ <field name="attribute1" type="V" size="12"></field>
+ <field name="attribute2" type="timestamp"></field>
+ <field name="attribute3" type="I"></field>
+ <field name="attribute4" type="X"></field>
+ <field name="attribute5" type="I"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_entity_2_1">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="num" type="V" size="16"><NOTNULL/></field>
+ <field name="p_num" type="V" size="15"></field>
+ <field name="p_entity_id" type="I"></field>
+ <field name="p_cat_id" type="I"></field>
+ <field name="location_code" type="V" size="20"></field>
+ <field name="loc1" type="V" size="4"></field>
+ <field name="loc2" type="V" size="4"></field>
+ <field name="loc3" type="V" size="4"></field>
+ <field name="loc4" type="V" size="4"></field>
+ <field name="address" type="V" size="50"></field>
+ <field name="tenant_id" type="I"></field>
+ <field name="contact_phone" type="V" size="30"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="user_id" type="I"></field>
+ <field name="status" type="I"></field>
+ <field name="attribute1" type="V" size="12"></field>
+ <field name="attribute2" type="timestamp"></field>
+ <field name="attribute3" type="I"></field>
+ <field name="attribute4" type="X"></field>
+ <field name="attribute5" type="I"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
+ </table>
+
+
+ <table name="fm_entity_2_2">
+ <desc>Table desc</desc>
+ <field name="id" type="I"><descr>A unique ID assigned to
record</descr><KEY/><AUTOINCREMENT/><NOTNULL/></field>
+ <field name="num" type="V" size="16"><NOTNULL/></field>
+ <field name="p_num" type="V" size="15"></field>
+ <field name="p_entity_id" type="I"></field>
+ <field name="p_cat_id" type="I"></field>
+ <field name="location_code" type="V" size="20"></field>
+ <field name="loc1" type="V" size="4"></field>
+ <field name="loc2" type="V" size="4"></field>
+ <field name="loc3" type="V" size="4"></field>
+ <field name="loc4" type="V" size="4"></field>
+ <field name="address" type="V" size="50"></field>
+ <field name="tenant_id" type="I"></field>
+ <field name="contact_phone" type="V" size="30"></field>
+ <field name="entry_date" type="I"></field>
+ <field name="user_id" type="I"></field>
+ <field name="status" type="I"></field>
+ <field name="attribute1" type="V" size="12"></field>
+ <field name="attribute2" type="timestamp"></field>
+ <field name="attribute3" type="I"></field>
+ <field name="attribute4" type="X"></field>
+ <field name="attribute5" type="I"></field>
+ <index
name="location_code"><col>location_code</col><UNIQUE/></index>
</table>
</schema>
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] property/setup/tables.xml, 1.1.1.2,
nomail <=