Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
suppliers Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

opportunities Table duedate int8 19 null

Unix timestamp in seconds

tasks Table tasknum text 2147483647 ''::text
feedservers Table description text 2147483647 ''::text

The general description field

coupons Table type int2 5 0
storages Table ID serial 10 nextval('"storages_ID_seq"'::regclass)
invitations Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

numcounters Table identifier text 2147483647 null
records Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

stocktransactions Table flag int2 5 0

0: Booked, 1: Reserved, 2: Cancelled

notes Table binfile int4 10 null

Underlying binary file for the note content

events Table color varchar 6 ''::character varying
groups2users Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

resources Table binfile int4 10 null
files Table filename text 2147483647 ''::text
weblets Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

ledgers Table description text 2147483647 ''::text

The general description field

feedservers Table owneruser int4 10 null

The owner user

dunning2transactions Table ID bigserial 19 nextval('"dunning2transactions_ID_seq"'::regclass)
transactions Table billingregion text 2147483647 ''::text
pricelists2accounts Table account int4 10 null

Reference to the associated account

categories Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

tokens Table expdate int8 19 null

Expiration date

extdata View value text 2147483647 null
davids Table etag text 2147483647 ''::text
mailservers Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

tasks Table ticket int4 10 null

Reference to the associated ticket

messagereads Table ID bigserial 19 nextval('"messagereads_ID_seq"'::regclass)
actionsteps Table description text 2147483647 ''::text

The general description field

extdatavalues Table index int8 19 null

The ID of the referenced entity

files Table size int4 10 0
davids Table contact int4 10 null

Reference to the associated contact

records Table date int8 19 (date_part('epoch'::text, now()))::bigint

Unix timestamp in seconds

permissions Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

tickets Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

tickets Table project int4 10 null
items Table description text 2147483647 ''::text

The general description field

tokens Table application int4 10 null
stocktransactions Table chargenum text 2147483647 ''::text

Charge number for the referenced items (only for items with charge numbers)

mailinglists Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

events Table dateto int8 19 null

Unix timestamp in seconds

pricelists Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

feedservers Table ID serial 10 nextval('"feedservers_ID_seq"'::regclass)
opportunities Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

dunning Table ID serial 10 nextval('"dunning_ID_seq"'::regclass)
accounts Table type int2 5 0

0: Prospect, 1: Customer, 2: Supplier, 3: Customer and Supplier, 4: Competitor

appointments Table description text 2147483647 ''::text

The general description field

payments Table transaction int4 10 null

Reference to the transaction

transactions Table duedate int8 19 null

Unix timestamp in seconds

associations Table relation text 2147483647 ''::text

Relationship name

appointments Table datefrom int8 19 null

Unix timestamp in seconds

services Table identifier text 2147483647 null
appointments Table name text 2147483647 null
appointments Table daterecurrence int8 19 null

The maximum date

notes Table owneruser int4 10 null

The owner user

contracts Table description text 2147483647 ''::text

The general description field

ledgers Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

comments Table ID bigserial 19 nextval('"comments_ID_seq"'::regclass)
tickets Table account int4 10 null

Reference to the associated account

mailinglists Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

mailservers Table passwordout text 2147483647 ''::text
weblets Table binfile int4 10 null
fields Table view text 2147483647 null
campaigns Table status int2 5 0
files Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

comments Table creator int4 10 null

The object creator

projects Table status int2 5 0

0: Draft, 1: Not started, 2: Awaiting approval, 3: Approved, 4: Dismissed, 5: Active, 6: Inactive, 7: Testing, 8: Cancelled, 9: Completed, 10: Failed, 11: Booked

extdatafields Table ID serial 10 nextval('"extdatafields_ID_seq"'::regclass)
pricelists Table applytoall int2 5 0

Apply prices to all accounts

suppliers Table item int4 10 null
campaigns Table name text 2147483647 null
events Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

dunning Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

views Table user int4 10 null
participants Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

links Table owneruser int4 10 null

The owner user

transactions Table margin float8 17 0
contacts Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

links Table username text 2147483647 ''::text
transactions Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

services Table schedule int4 10 0
weblets Table url text 2147483647 ''::text
contacts Table company text 2147483647 ''::text
contacts Table department text 2147483647 ''::text
opportunities Table opportunitynum text 2147483647 ''::text

Unique number

stocktransactions Table reference text 2147483647 ''::text
items Table manufacturer text 2147483647 ''::text
contacts Table website text 2147483647 ''::text
ledgers Table creator int4 10 null

The object creator

messages Table size int4 10 0
projects Table name text 2147483647 null
events Table creator int4 10 null

The object creator

applications Table restricted int2 5 0
storages Table creator int4 10 null

The object creator

users Table activity int2 5 0

0: Active, 1: Deactivated

contacts Table email text 2147483647 ''::text
weblets Table application int4 10 null
mailinglists Table description text 2147483647 ''::text

The general description field

messages Table text text 2147483647 ''::text
davservers Table creator int4 10 null

The object creator

suppliers Table creator int4 10 null

The object creator

resources Table mimetype text 2147483647 'text/x-zymba'::text
notes Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

objects Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

components Table price float8 17 null
permissions Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

contacts Table postalcode text 2147483647 ''::text
couponcodes Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

feedservers Table etag text 2147483647 ''::text
couponcodes Table datefrom int8 19 null

Unix timestamp in seconds

tickets Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

transactions Table billingcity text 2147483647 ''::text
tickets Table creator int4 10 null

The object creator

categories Table creator int4 10 null

The object creator

participants Table email text 2147483647 ''::text
stocktransactions Table transaction int4 10 null

The underlying billing/procurement transaction

messagereads Table message int4 10 null
actionsteps Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

dunning Table duedate int8 19 null

Unix timestamp in seconds

messages Table bcc text 2147483647 ''::text
payments Table ledger int4 10 null
stocktransactions Table location text 2147483647 ''::text
opportunities Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

couponcodes Table code text 2147483647 null
contacts Table ID serial 10 nextval('"contacts_ID_seq"'::regclass)
users Table sessionid int4 10 null
davservers Table ctag text 2147483647 ''::text
users Table creator int4 10 null

The object creator

payments Table amount float8 17 null

Payment amount

addresses Table ID bigserial 19 nextval('"addresses_ID_seq"'::regclass)
projects Table ID serial 10 nextval('"projects_ID_seq"'::regclass)
weblets Table height int2 5 0
contacts Table creator int4 10 null

The object creator

mailservers Table signaturebinfile int4 10 null
mailservers Table name text 2147483647 null
objects Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

applications Table secret varchar 40 ''::character varying
tasks Table owneruser int4 10 null

The owner user

notifications Table user int4 10 null
ledgers Table ID serial 10 nextval('"ledgers_ID_seq"'::regclass)
notifications Table record int8 19 null
transactions Table exchangerate float8 17 1

Exchange rate for foreign currency

groups2users Table writable int2 5 0
opportunities Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

messages Table sender_name text 2147483647 ''::text
feedids Table record int8 19 null
opportunities Table status int2 5 0

0: Unveluated, 1: Eligible, 2: Feedback required, 3: In negotation, 4: Offered, 5: Accepted, 6: Rejected

mailservers Table usernamein text 2147483647 ''::text
links Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

opportunities Table name text 2147483647 null
addresses Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

items Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

actionsteps Table status int2 5 0

0: Draft, 1: Completed, 2: Cancelled, 3: Booked (e.g. if the action step is billed - see column transaction)

transactions Table item int4 10 null
notes Table ID serial 10 nextval('"notes_ID_seq"'::regclass)
actionsteps Table effort int4 10 null

The booked time effort in minutes

campaigns Table dateto int8 19 null

Unix timestamp in seconds

pricelists Table datefrom int8 19 null

Unix timestamp in seconds

associations Table index2 int4 10 null

Second object ID

contacts2contacts Table creator int4 10 null

The object creator

fields Table data text 2147483647 null
records Table ID bigserial 19 nextval('"records_ID_seq"'::regclass)
suppliers Table stock float8 17 null
messages Table to_name text 2147483647 ''::text
mailservers Table description text 2147483647 ''::text

The general description field

suppliers Table price float8 17 null
accounts Table firstname text 2147483647 ''::text
davservers Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

opportunities Table probability int2 5 0

Conversion probability

contacts Table fax text 2147483647 ''::text
tasks Table description text 2147483647 ''::text

The general description field

davservers Table activity int2 5 0

0: Active, 1: Deactivated

files Table creator int4 10 null

The object creator

transactions Table shippingcountry varchar 2 ''::character varying
components Table component int4 10 null
links Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

events Table index int4 10 null

The ID of the referenced entity

users Table logintoken varchar 40 ''::character varying
users Table settings json 2147483647 null
payments Table description text 2147483647 ''::text

The general description field

objects Table binfile int4 10 null
actionsteps Table creator int4 10 null

The object creator

groups Table ID serial 10 nextval('"groups_ID_seq"'::regclass)
projects Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

tickets Table ID serial 10 nextval('"tickets_ID_seq"'::regclass)
imapids Table uidvalidity int4 10 null
transactions Table assigneduser int4 10 null

The assigned user

storages Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

transactions Table weight float8 17 0
contacts Table phone2 text 2147483647 ''::text
transactions Table shippingcity text 2147483647 ''::text
tagrels Table index int8 19 null

The ID of the referenced entity

projects Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

tasks Table name text 2147483647 null
dunning2transactions Table transaction int4 10 null
coupons Table description text 2147483647 ''::text

The general description field

transactions Table discount float8 17 0
categories Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

extdata View name text 2147483647 null
suppliers Table account int4 10 null

Reference to the associated account

messages Table contenttype text 2147483647 ''::text
events Table name text 2147483647 null
campaigns Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

contacts Table description text 2147483647 ''::text

The general description field

transactions Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

records Table meta json 2147483647 null

Optional meta data

pricelists Table creator int4 10 null

The object creator

records Table creator int4 10 null

The object creator

tickets Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

items Table unit varchar 3 ''::character varying
extdatavalues Table field int4 10 null
opportunities Table ID serial 10 nextval('"opportunities_ID_seq"'::regclass)
contracts Table datefrom int8 19 null

Unix timestamp in seconds

messages Table cc text 2147483647 ''::text
messages Table date int8 19 (date_part('epoch'::text, now()))::bigint

Unix timestamp in seconds

weblets Table activity int2 5 0

0: Active, 1: Deactivated

permissions Table identifier text 2147483647 null
payments Table creator int4 10 null

The object creator

users Table expdate int8 19 null
contacts Table title text 2147483647 ''::text
items Table purchaseprice float8 17 0

Default purchase price

coupons Table ID serial 10 nextval('"coupons_ID_seq"'::regclass)
appointments Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

pricelists Table activity int2 5 0

0: Active, 1: Deactivated

follows Table index int8 19 null

The ID of the referenced entity

tokens Table user int4 10 null
mailinglists Table creator int4 10 null

The object creator

actionsteps Table account int4 10 null

Acion steps can also be assigned to a account

associations Table meta json 2147483647 null

Optional meta data

couponcodes Table value float8 17 0
mailservers Table serverin text 2147483647 ''::text
applications Table activity int2 5 0

0: Active, 1: Deactivated

invitations Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

invitations Table contact int4 10 null

Reference to the associated contact

storages Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

davservers Table recipientgroup int4 10 null
appointments Table ID serial 10 nextval('"appointments_ID_seq"'::regclass)
extdatafields Table name text 2147483647 null
imapids Table mailserver int4 10 null
accounts Table assigneduser int4 10 null

The assigned user

addresses Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

notes Table description text 2147483647 ''::text

The general description field

permissions Table creator int4 10 null

The object creator

campaigns Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

records Table owneruser int4 10 null

The owner user

extdata View number numeric 131089 null
imapids Table mailbox text 2147483647 null
stocktransactions Table storage int4 10 null

The referenced storage

contacts Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

files Table mimetype text 2147483647 'application/octet-stream'::text
applications Table name text 2147483647 null
objects Table assigneduser int4 10 null

The assigned user

items Table picbinfile int4 10 null

Picture bin file

contracts Table status int2 5 0
stocktransactions Table transfer int8 19 null

Flags the transaction as a transfer between two locations

associations Table creator int4 10 null

The object creator

comments Table text text 2147483647 null
resources Table ID serial 10 nextval('"resources_ID_seq"'::regclass)
components Table item int4 10 null
messages Table ticket int4 10 null

Reference to the associated ticket

tasks Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

objects Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

feedservers Table username text 2147483647 ''::text
stocktransactions Table serials _text 2147483647 null

Array of serial numbers (only for items with serial numbers)

contracts Table account int4 10 null

Reference to the associated account

services Table entity text 2147483647 ''::text

The referenced entity name (e.g. "contacts")

couponcodes Table transaction int4 10 null
items Table taxrate float8 17 null
weblets Table name text 2147483647 null
comments Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

items Table sellingprice float8 17 0

Default selling price

prices Table price float8 17 null
users Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

couponcodes Table date int8 19 (date_part('epoch'::text, now()))::bigint

Unix timestamp in seconds

tagnames Table entity TP_entity 2147483647 null

The referenced entity name (e.g. "contacts")

davservers Table ID serial 10 nextval('"davservers_ID_seq"'::regclass)
users Table ID serial 10 nextval('"users_ID_seq"'::regclass)
contracts Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

contacts Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

tasks Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

ledgers Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

permissions Table ID bigserial 19 nextval('"permissions_ID_seq"'::regclass)
pricelists Table ID serial 10 nextval('"pricelists_ID_seq"'::regclass)
dunning Table address text 2147483647 ''::text
participants Table creator int4 10 null

The object creator

storages Table description text 2147483647 ''::text

The general description field

opportunities Table contact int4 10 null

Reference to the associated contact

events Table owneruser int4 10 null

The owner user

services Table name text 2147483647 null
contacts2contacts Table contact2 int4 10 null
davids Table davserver int4 10 null
applications Table usersettingsbinfile int4 10 null
appointments Table color varchar 6 ''::character varying
tickets Table date int8 19 (date_part('epoch'::text, now()))::bigint

Unix timestamp in seconds

prices Table discount float8 17 0

Relative discount on an item

services Table accesskey text 2147483647 ''::text
payments Table subject text 2147483647 ''::text

Subject line (e.g. on your bank statement)

objects Table description text 2147483647 ''::text

The general description field

messages Table senddate int8 19 null
tasks Table status int2 5 0

0: Not started, 1: Awaiting acceptance, 2: Accepted, 3: Rejected, 4: Active, 5: Inactive, 6: Feedback required, 7: Testing, 8: Cancelled, 9: Completed, 10: Failed, 11: Booked

resources Table activity int2 5 0

0: Active, 1: Deactivated

mailservers Table ticketing json 2147483647 null
accounts Table currency varchar 3 null

Currency symbol (e.g. EUR or USD)

pricelists2accounts Table creator int4 10 null

The object creator

accounts Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

transactions Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

messages Table sender text 2147483647 ''::text
coupons Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

payments Table date int8 19 (date_part('epoch'::text, now()))::bigint

Unix timestamp in seconds

participants Table ID bigserial 19 nextval('"participants_ID_seq"'::regclass)
pricelists Table currency varchar 3 null
appointments Table interval int2 5 1

The interval in which a recurring event should take place

groups Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

transactions Table status int2 5 0

0: Draft, 1: Booked, 2: Hold, 3: Cancelled, 4: Closed, 5: Partly ordered, 6: Partly ordered cancelled, 7: Partly ordered closed, 8: Ordered, 9: Partly delivered, 10: Partly delivered cancelled, 11: Partly delivered closed, 12: Delivered, 13: Partly invoiced, 14: Partly invoiced cancelled, 15: Partly invoiced closed, 16: Invoiced, 17: Partly paid, 18: Partly paid cancelled, 19: Partly paid closed, 20: Paid, 21: Overpaid

records Table sender text 2147483647 ''::text
tasks Table duedate int8 19 null

Unix timestamp in seconds

links Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

mailinglists Table ID serial 10 nextval('"mailinglists_ID_seq"'::regclass)
tickets Table items json 2147483647 null
participants Table mailinglist int4 10 null
filters Table user int4 10 null
participants Table phone text 2147483647 ''::text
transactions Table type int2 5 null

0: Billing quote, 1: Billing order, 2: Billing delivery, 3: Billing invoice, 4: Billing credit, 5: Procurement request, 6: Procurement order, 7: Procurement delivery, 8: Procurement invoice, 9: Procurement credit

stocktransactions Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

coupons Table code text 2147483647 null
weblets Table width int2 5 0
mailservers Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

couponcodes Table creator int4 10 null

The object creator

messages Table reference int4 10 null
messagereads Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

suppliers Table minamount float8 17 0
addresses Table creator int4 10 null

The object creator

tasks Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

feedservers Table activity int2 5 0

0: Active, 1: Deactivated

services Table ID serial 10 nextval('"services_ID_seq"'::regclass)
coupons Table datefrom int8 19 null

Unix timestamp in seconds

suppliers Table ID bigserial 19 nextval('"suppliers_ID_seq"'::regclass)
contracts Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

dunning2transactions Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

dunning2transactions Table dunning int4 10 null
opportunities Table upside float8 17 0

Upside revenue

dunning Table dunningnum text 2147483647 null

A unique number for the dunning transaction

services Table creator int4 10 null

The object creator

accounts Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

appointments Table creator int4 10 null

The object creator

davservers Table type int2 5 null

0: Contacts, 1: Appointments, 2: Tasks

dunning Table status int2 5 0

0: Draft, 1: Booked, 2: Cancelled, 3: Closed

accounts Table customernum text 2147483647 ''::text

A unique customer number (only visible for types "Prospect" and "Customer")

opportunities Table priority int2 5 2

priority status (0: Lowest, 1: Low, 2: Medium, 3: High, 4: Highest)

mailservers Table folders json 2147483647 null
files Table ID bigserial 19 nextval('"files_ID_seq"'::regclass)
davservers Table description text 2147483647 ''::text

The general description field

davservers Table password text 2147483647 ''::text
pricelists Table dateto int8 19 null

Unix timestamp in seconds

opportunities Table creator int4 10 null

The object creator

appointments Table location text 2147483647 ''::text
binfiles Table ID int4 10 null
messages Table mailinglist int4 10 null
resources Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

tasks Table ID serial 10 nextval('"tasks_ID_seq"'::regclass)
groups2users Table creator int4 10 null

The object creator

filters Table data text 2147483647 null
notes Table name text 2147483647 null
users Table nopublic int2 5 0

User can only access group objects, but not public objects

tickets Table duedate int8 19 null

Unix timestamp in seconds

events Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

accounts Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

applications Table defaultsettings json 2147483647 null
pricelists Table description text 2147483647 ''::text

The general description field

comments Table sender text 2147483647 ''::text
couponcodes Table flag int2 5 0
imapids Table hash varchar 32 null
items Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

suppliers Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

weblets Table svgpath text 2147483647 ''::text
resources Table application int4 10 null
weblets Table ID serial 10 nextval('"weblets_ID_seq"'::regclass)
feedservers Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

messages Table ID serial 10 nextval('"messages_ID_seq"'::regclass)
dunning Table creator int4 10 null

The object creator

notifications Table flag int2 5 0
davservers Table synctoken text 2147483647 ''::text
appointments Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

storages Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

categories Table entity text 2147483647 null

The referenced entity name (e.g. "contacts")

participants Table name text 2147483647 null
tagnames Table ID serial 10 nextval('"tagnames_ID_seq"'::regclass)
dunning Table region text 2147483647 ''::text
records Table assigneduser int4 10 null

The assigned user

filters Table name text 2147483647 null
appointments Table assigneduser int4 10 null

The assigned user

opportunities Table assigneduser int4 10 null

The assigned user

messages Table opportunity int4 10 null
contacts Table owneruser int4 10 null

The owner user

tasks Table creator int4 10 null

The object creator

campaigns Table datefrom int8 19 null

Unix timestamp in seconds

groups2users Table user int4 10 null
mailinglists Table name text 2147483647 null
tokens Table identifier text 2147483647 null

Token identifier (e.g. device ID)

components Table ID bigserial 19 nextval('"components_ID_seq"'::regclass)
objects Table name text 2147483647 null
appointments Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

events Table entity TP_entity 2147483647 null

The referenced entity name (e.g. "contacts")

tags View entity TP_entity 2147483647 null
records Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

users Table email text 2147483647 null
projects Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

events Table meta json 2147483647 null

Optional meta data on the event

objects Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

groups2users Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

opportunities Table description text 2147483647 ''::text

The general description field

accounts Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

notes Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

objects Table ID serial 10 nextval('"objects_ID_seq"'::regclass)
davservers Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

pricelists Table type int2 5 0

0: Billing minimum, 1: Billing maximum, 2: Procurement minimum, 3: Procurement maximum

messages Table mailserver int4 10 null
stocktransactions Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

stocktransactions Table sellingprice float8 17 0
services Table application int4 10 null
ledgers Table name text 2147483647 null
records Table text text 2147483647 ''::text

Record text

objects Table data json 2147483647 null
accounts Table lastname text 2147483647 ''::text
mailinglists Table owneruser int4 10 null

The owner user

payments Table assigneduser int4 10 null

The assigned user

follows Table entity TP_entity 2147483647 null

The referenced entity name (e.g. "contacts")

actionsteps Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

tickets Table description text 2147483647 ''::text

The general description field

messages Table mailbox int2 5 0

0: Inbox, 1: Drafts, 2: Sent, 3: Templates, 4: Mailings, 5: Archive, 6: Trash, 7: Junk

notes Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

prices Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

davservers Table username text 2147483647 ''::text
links Table ID serial 10 nextval('"links_ID_seq"'::regclass)
notes Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

transactions Table currency varchar 3 null
campaigns Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

contacts2contacts Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

coupons Table value float8 17 0
messages Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

feedids Table uuid text 2147483647 null
appointments Table owneruser int4 10 null

The owner user

contracts Table items json 2147483647 null
payments Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

transactions Table billingpostalcode text 2147483647 ''::text
resources Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

likes Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

tickets Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

opportunities Table mostlikely float8 17 0

Most likely revenue

dunning Table date int8 19 (date_part('epoch'::text, now()))::bigint

Unix timestamp in seconds

transactions Table shippingpostalcode text 2147483647 ''::text
applications Table version int4 10 10000
davids Table appointment int4 10 null
messages Table to text 2147483647 ''::text
feedservers Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

tickets Table assigneduser int4 10 null

The assigned user

payments Table ID bigserial 19 nextval('"payments_ID_seq"'::regclass)
dunning2transactions Table creator int4 10 null

The object creator

notes Table text text 2147483647 ''::text
transactions Table creator int4 10 null

The object creator

applications Table identifier text 2147483647 null
payments Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

messages Table creator int4 10 null

The object creator

transactions Table netamount float8 17 0
stocktransactions Table creator int4 10 null

The object creator

feedservers Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

groups Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

weblets Table creator int4 10 null

The object creator

mailservers Table ID serial 10 nextval('"mailservers_ID_seq"'::regclass)
extdata View entity TP_entity 2147483647 null
mailinglists Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

imapids Table uid int4 10 null
messages Table to_email text 2147483647 ''::text
users Table lastloginattempt int8 19 null
payments Table status int2 5 0

0: Draft, 1: Completed, 2: Cancelled, 3: Booked

actionsteps Table ID serial 10 nextval('"actionsteps_ID_seq"'::regclass)
actionsteps Table ticket int4 10 null

Reference to the associated ticket

messages Table subject text 2147483647 ''::text
categories Table ID serial 10 nextval('"categories_ID_seq"'::regclass)
groups2users Table group int4 10 null
links Table assigneduser int4 10 null

The assigned user

addresses Table default int2 5 0

Use the specified address as default billing/shipping address

resources Table identifier text 2147483647 null
weblets Table type int2 5 null

0: Embedded, 1: Attached, 2: Standalone, 3: Detached, 4: Pop up framed, 5: Pop up unframed

users Table lastlogin int8 19 null
associations Table ID bigserial 19 nextval('"associations_ID_seq"'::regclass)
accounts Table description text 2147483647 ''::text

The general description field

weblets Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

tasks Table datefrom int8 19 null

Unix timestamp in seconds

objects Table owneruser int4 10 null

The owner user

tasks Table priority int2 5 2

priority status (0: Lowest, 1: Low, 2: Medium, 3: High, 4: Highest)

categories Table name text 2147483647 null

Category name

davservers Table owneruser int4 10 null

The owner user

contacts Table phone text 2147483647 ''::text
notes Table assigneduser int4 10 null

The assigned user

files Table comment int8 19 null
extdata View index int8 19 null
categories Table owneruser int4 10 null

The owner user

dunning2transactions Table fee float8 17 0

Optional dunning fee

prices Table rebate float8 17 0

Absolute rebate on an item

records Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

associations Table index1 int4 10 null

First object ID

dunning Table assigneduser int4 10 null

The assigned user

associations Table entity2 TP_entity 2147483647 null

Second entity name (e.g. "contracts")

contacts Table region text 2147483647 ''::text
services Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

dunning Table postalcode text 2147483647 ''::text
contacts Table type int2 5 0

Contact type (0: Company, 1: Person)

stocktransactions Table amount float8 17 null

Transaction amount

opportunities Table worstcase float8 17 0

Worst possible revenue

contacts Table birthdate int8 19 null
opportunities Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

dunning Table account int4 10 null

Reference to the associated account

feedservers Table name text 2147483647 null
davservers Table name text 2147483647 null
contacts Table email2 text 2147483647 ''::text
records Table index int4 10 null

The ID of the referenced entity

items Table creator int4 10 null

The object creator

fields Table user int4 10 null
davids Table vobject text 2147483647 ''::text
users Table description text 2147483647 ''::text

The general description field

dunning Table level int2 5 0

0: Reminder, 1: Initial, 2: Intermediate, 3: Final

objects Table creator int4 10 null

The object creator

messages Table to_count int4 10 0
mailservers Table recipientgroup int4 10 null
transactions Table date int8 19 (date_part('epoch'::text, now()))::bigint

Unix timestamp in seconds

groups Table creator int4 10 null

The object creator

coupons Table taxrate float8 17 null
notifications Table ID serial 10 nextval('"notifications_ID_seq"'::regclass)
views Table view text 2147483647 null
mailinglists Table campaign int4 10 null
prices Table pricelist int4 10 null
users Table name text 2147483647 null
views Table data text 2147483647 null
records Table entity TP_entity 2147483647 null

The referenced entity name (e.g. "contacts")

follows Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

groups2users Table ID bigserial 19 nextval('"groups2users_ID_seq"'::regclass)
components Table creator int4 10 null

The object creator

weblets Table color varchar 6 ''::character varying
invitations Table creator int4 10 null

The object creator

filters Table view text 2147483647 null
events Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

mailservers Table autoreplybinfile int4 10 null
appointments Table dateto int8 19 null

Unix timestamp in seconds

projects Table creator int4 10 null

The object creator

items Table type int2 5 0

0: Regular, 1: Serials, 2: Charges, 3: Serials & Charges, 4: Package Set, 5: Component Container, 6: No stock, 7: Model

addresses Table type int2 5 0

0: Billing/Shipping, 1: Billing/Billing, 2: Procurement/Shipping, 3: Procurement/Billing

comments Table record int8 19 null
tasks Table assigneduser int4 10 null

The assigned user

transactions Table billingrecipient text 2147483647 ''::text
davservers Table url text 2147483647 null
links Table url text 2147483647 ''::text
transactions Table ID serial 10 nextval('"transactions_ID_seq"'::regclass)
messages Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

groups Table leader int4 10 null
contacts Table address text 2147483647 ''::text
transactions Table shippingrecipient text 2147483647 ''::text
addresses Table account int4 10 null

Reference to the associated account

applications Table settings json 2147483647 null
permissions Table group int4 10 null
actionsteps Table actionnum text 2147483647 ''::text

A unique transaction number

users Table loginattempts int4 10 0
stocktransactions Table purchaseprice float8 17 0

Purchase price for the item (e.g. for later evaluation)

mailinglists Table sender text 2147483647 ''::text
likes Table creator int4 10 null

The object creator

coupons Table creator int4 10 null

The object creator

contracts Table dateto int8 19 null

Unix timestamp in seconds

notes Table size int4 10 0
applications Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

files Table record int8 19 null
transactions Table transactionnum text 2147483647 null

Unique transaction number

services Table mimetype text 2147483647 'text/x-zymba'::text
extdatavalues Table value text 2147483647 null
tokens Table token varchar 40 null

Token string

contacts Table picbinfile int4 10 null

Image file

weblets Table view text 2147483647 ''::text
mailservers Table serverout text 2147483647 ''::text
transactions Table tax float8 17 0
services Table type int2 5 null

0: Timing, 1: Remotecall, 2: After creation, 3: Before modification, 4: After modification, 5: After creation or modification, 6: Before deletion, 7: After deletion

campaigns Table description text 2147483647 ''::text

The general description field

ledgers Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

objects Table entity text 2147483647 null

The referenced entity name (e.g. "contacts")

pricelists Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

follows Table ID bigserial 19 nextval('"follows_ID_seq"'::regclass)
prices Table item int4 10 null
prices Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

contracts Table assigneduser int4 10 null

The assigned user

invitations Table ID bigserial 19 nextval('"invitations_ID_seq"'::regclass)
items Table model int4 10 null
pricelists2accounts Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

numcounters Table counter int4 10 null
items Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

accounts Table locked int2 5 0

If no transactions can be created for this account

contacts Table country varchar 2 ''::character varying
items Table barcode text 2147483647 ''::text
transactions Table shippingaddress text 2147483647 ''::text
notes Table contenttype text 2147483647 ''::text

MIME type for the note content, e.g. "text/plain"

notes Table creator int4 10 null

The object creator

applications Table settingsbinfile int4 10 null
associations Table entity1 TP_entity 2147483647 null

First entity name (e.g. "tasks")

applications Table ID serial 10 nextval('"applications_ID_seq"'::regclass)
mailservers Table sender text 2147483647 ''::text
records Table flag int2 5 0

0: Regular, 1: Object only, 2: Mindlog only, 3: Monitor entry

files Table binfile int4 10 null
projects Table owneruser int4 10 null

The owner user

contacts2contacts Table ID bigserial 19 nextval('"contacts2contacts_ID_seq"'::regclass)
davids Table task int4 10 null

Reference to the associated task

contracts Table datecancel int8 19 null
links Table description text 2147483647 ''::text

The general description field

events Table ID serial 10 nextval('"events_ID_seq"'::regclass)
tickets Table status int2 5 0

0: Not started, 1: Awaiting acceptance, 2: Accepted, 3: Rejected, 4: Active, 5: Inactive, 6: Feedback required, 7: Testing, 8: Cancelled, 9: Completed, 10: Failed, 11: Booked

mailservers Table owneruser int4 10 null

The owner user

components Table amount float8 17 1
groups Table name text 2147483647 null
contacts Table position text 2147483647 ''::text
contracts Table name text 2147483647 null
pricelists Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

associations Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

storages Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

events Table datefrom int8 19 null

Unix timestamp in seconds

couponcodes Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

opportunities Table campaign int4 10 null
projects Table projectnum text 2147483647 ''::text
mailservers Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

davids Table href text 2147483647 null
dunning Table country varchar 2 ''::character varying
links Table name text 2147483647 null
contacts2contacts Table contact1 int4 10 null
messagereads Table creator int4 10 null

The object creator

weblets Table langaliases json 2147483647 null
feedids Table feedserver int4 10 null
binfiles Table hash varchar 32 null

File hash

messages Table senderror text 2147483647 ''::text
links Table visits int4 10 0
mailservers Table recipientuser int4 10 null
tickets Table priority int2 5 2

priority status (0: Lowest, 1: Low, 2: Medium, 3: High, 4: Highest)

campaigns Table assigneduser int4 10 null

The assigned user

stocktransactions Table item int4 10 null
projects Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

transactions Table account int4 10 null

Reference to the associated account

coupons Table activity int2 5 0

0: Active, 1: Deactivated

permissions Table writable int2 5 0
tasks Table projectedeffort int4 10 0

Projected effort in minutes

feedservers Table url text 2147483647 null
tags View name text 2147483647 null
appointments Table recurrence int2 5 null

Number

tagrels Table name int4 10 null
likes Table record int8 19 null
coupons Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

notes Table status int2 5 0

0: Draft, 1: Feedback required, 2: In revision, 3: Awaiting approval, 4: Final, 5: Obsolete

actionsteps Table transaction int4 10 null

Linked billing transaction - if the transaction is cancelled, the action step status will reset to Completed (1)

users Table password text 2147483647 ''::text
campaigns Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

services Table binfile int4 10 null
notifications Table date int8 19 null

Unix timestamp in seconds

mailservers Table activity int2 5 0

0: Active, 1: Deactivated

coupons Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

prices Table ID bigserial 19 nextval('"prices_ID_seq"'::regclass)
campaigns Table creator int4 10 null

The object creator

groups Table activity int2 5 0

0: Active, 1: Deactivated

components Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

services Table interval int2 5 1
messages Table owneruser int4 10 null

The owner user

resources Table name text 2147483647 null
contacts Table city text 2147483647 ''::text
transactions Table shippingregion text 2147483647 ''::text
services Table url text 2147483647 ''::text
addresses Table contact int4 10 null

Reference to the associated contact

storages Table name text 2147483647 null
mailservers Table passwordin text 2147483647 ''::text
applications Table vendor text 2147483647 ''::text
contracts Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

binfiles Table date int8 19 (date_part('epoch'::text, now()))::bigint

Unix timestamp in seconds

dunning Table recipient text 2147483647 ''::text
transactions Table items json 2147483647 null
weblets Table mimetype text 2147483647 'text/x-zymba'::text
coupons Table name text 2147483647 null
participants Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

users Table persistentlogintoken varchar 40 ''::character varying
contacts Table cell text 2147483647 ''::text
actionsteps Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

couponcodes Table ID bigserial 19 nextval('"couponcodes_ID_seq"'::regclass)
messages Table sender_email text 2147483647 ''::text
coupons Table dateto int8 19 null

Unix timestamp in seconds

couponcodes Table dateto int8 19 null

Unix timestamp in seconds

stocktransactions Table ID bigserial 19 nextval('"stocktransactions_ID_seq"'::regclass)
components Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

dunning Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

actionsteps Table duedate int8 19 null

Unix timestamp in seconds

participants Table contact int4 10 null

Reference to the associated contact

campaigns Table ID serial 10 nextval('"campaigns_ID_seq"'::regclass)
messages Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

applications Table creator int4 10 null

The object creator

dunning Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

contacts Table lastname text 2147483647 ''::text
contracts Table contractnum text 2147483647 ''::text
tags View index int8 19 null
actionsteps Table task int4 10 null

Acion steps can belong to a task

mailinglists Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

users Table contact int4 10 null

Reference to the associated contact

items Table ID serial 10 nextval('"items_ID_seq"'::regclass)
follows Table creator int4 10 null

The object creator

contracts Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

actionsteps Table assigneduser int4 10 null

The assigned user

fields Table name text 2147483647 null
items Table weight float8 17 0
payments Table account int4 10 null

Reference to the associated account

projects Table assigneduser int4 10 null

The assigned user

actionsteps Table date int8 19 (date_part('epoch'::text, now()))::bigint

Unix timestamp in seconds

items Table name text 2147483647 null
suppliers Table deliverytime int2 5 null
prices Table minamount float8 17 0

Minimum amount to qualify for the rebate/discount

opportunities Table account int4 10 null

Reference to the associated account

actionsteps Table owneruser int4 10 null

The owner user

likes Table ID bigserial 19 nextval('"likes_ID_seq"'::regclass)
transactions Table productionfactor int4 10 null
appointments Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

ledgers Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

accounts Table contact int4 10 null

Reference to the associated contact

accounts Table creator int4 10 null

The object creator

invitations Table appointment int4 10 null
accounts Table suppliernum text 2147483647 ''::text

A unique supplier number (only visible for type "Supplier")

payments Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

accounts Table ID serial 10 nextval('"accounts_ID_seq"'::regclass)
contacts Table assigneduser int4 10 null

The assigned user

invitations Table flag int2 5 0

0: Unanswered, 1: Confirmed, 2: Rejected

mailservers Table creator int4 10 null

The object creator

extdatafields Table entity TP_entity 2147483647 null

The referenced entity name (e.g. "contacts")

tasks Table project int4 10 null
davservers Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

mailservers Table usernameout text 2147483647 ''::text
weblets Table identifier text 2147483647 null
contracts Table creator int4 10 null

The object creator

prices Table creator int4 10 null

The object creator

messages Table binfile int4 10 null
couponcodes Table coupon int4 10 null
items Table ownergroup int4 10 null

The owner group (if owneruser and ownergroup are NULL, the element is public)

feedservers Table password text 2147483647 ''::text
services Table activity int2 5 0

0: Active, 1: Deactivated

transactions Table billingcountry varchar 2 ''::character varying
tickets Table name text 2147483647 null
feedservers Table creator int4 10 null

The object creator

projects Table description text 2147483647 ''::text

The general description field

actionsteps Table name text 2147483647 null
users Table signature varchar 32 null
transactions Table billingaddress text 2147483647 ''::text
dunning Table city text 2147483647 ''::text
pricelists2accounts Table pricelist int4 10 null
applications Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

contacts Table firstname text 2147483647 ''::text
pricelists Table name text 2147483647 null
groups Table description text 2147483647 ''::text

The general description field

links Table password text 2147483647 ''::text
resources Table creator int4 10 null

The object creator

tasks Table visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

contracts Table ID serial 10 nextval('"contracts_ID_seq"'::regclass)
services Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

pricelists2accounts Table ID bigserial 19 nextval('"pricelists2accounts_ID_seq"'::regclass)
accounts Table excludetax int2 5 0

Exclude the customer from taxation

mailinglists Table assigneduser int4 10 null

The assigned user

participants Table campaign int4 10 null
davservers Table recipientuser int4 10 null
feedservers Table recipientgroup int4 10 null
binfiles Table size int4 10 null

File size

links Table creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

feedservers Table recipientuser int4 10 null
users Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

suppliers Table itemnum text 2147483647 ''::text
imapids Table message int4 10 null
tagnames Table name text 2147483647 null
tickets Table ticketnum text 2147483647 ''::text
items Table itemnum text 2147483647 ''::text

The unique item number

stocktransactions Table date int8 19 (date_part('epoch'::text, now()))::bigint

Unix timestamp in seconds

links Table creator int4 10 null

The object creator

contacts Table lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)