Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
mailservers Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)

messagereads Table ID int8 19 null

Message-read ID

dunning Table city text 2147483647 ''::text

City or municipality

feedservers Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

mailinglists Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

extdata View value text 2147483647 null
coupons Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)

contacts Table fax text 2147483647 ''::text

Fax number

accounts Table firstname text 2147483647 ''::text

First name (given name); is required if lastname is empty

accounts Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

pricelists Table currency varchar 3 null

Currency code (ISO 4217) (Pattern: ^[A-Z]{3}$)

records Table index int4 10 null

Entity ID; is required if entity is not null, otherwise must be null

projects Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

participants Table name text 2147483647 null

Name

payments Table autoadvance int2 5 0

Auto-advance to next transaction

objects Table name text 2147483647 null

Name

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

payments Table status int2 5 0

Status (0=DRAFT, 1=COMPLETED, 2=CANCELLED, 3=BOOKED)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

transactions Table shippingcountry varchar 2 ''::character varying

Shipping country code (ISO 3166-1 alpha-2) (Pattern: ^([A-Z]{2})?$)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

invitations Table name text 2147483647 null

Name

opportunities Table opportunitynum text 2147483647 ''::text

Opportunity number

users Table contact int4 10 null

Contact ID

items Table weight float8 17 0

Shipping weight per unit in kilogram

accounts Table currency varchar 3 null

Currency code (ISO 4217) (Pattern: ^[A-Z]{3}$)

associations Table index2 int4 10 null

Second entity ID

feedservers Table description text 2147483647 ''::text

Detailed general description

feedids Table record int8 19 null
opportunities Table status int2 5 0

Status (0=UNEVALUATED, 1=ELIGIBLE, 2=FEEDBACKREQUIRED, 3=INNEGOTIATION, 4=OFFERED, 5=ACCEPTED, 6=REJECTED)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

messages Table ID int4 10 null

Message ID

transactions Table item int4 10 null

Item ID; is required for PRODUCTION, otherwise must be null

permissions Table identifier text 2147483647 null

Permission identifier (Pattern: ^[\w.:-]+$)

pricelists Table ID int4 10 null

Price list ID

dunning2transactions Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

pg_stat_statements View max_time float8 17 null
mailservers Table recipientgroup int4 10 null

Recipient group ID (PUBLIC if recipientuser=null and recipientgroup=null)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

categories Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

services Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)

invitations Table appointment int4 10 null

Appointment ID (**dependency**)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

accounts Table contact int4 10 null

Contact ID

contacts Table website text 2147483647 ''::text

Website URL

items Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

actionsteps Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

items Table forcestock int2 5 null

Force stock check on depletion (0=STORAGE, 1=LOCATION)

notifications Table user int4 10 null
files Table ID int8 19 null

File ID

campaigns Table name text 2147483647 null

Name

contacts Table description text 2147483647 ''::text

Detailed general description

messages Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

items Table itemnum text 2147483647 ''::text

Item number (SKU)

transactions Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

resources Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

events Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

pg_stat_statements View blk_write_time float8 17 null
permissions Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

contacts2contacts Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

messages Table mailinglist int4 10 null

Mailing list ID

contacts Table postalcode text 2147483647 ''::text

Postal or ZIP code

davservers Table url text 2147483647 null

Endpoint URL

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

transactions Table items json 2147483647 null
fields Table user int4 10 null
groups2users Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

notes Table size int4 10 0

Size in bytes

weblets Table binfile int4 10 null
davservers Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

pg_stat_statements View temp_blks_written int8 19 null
appointments Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

items Table sellingprice float8 17 0

Default selling price per unit

events Table ID int4 10 null

Event ID

dunning2transactions Table transaction int4 10 null

Transaction ID (**dependency**)

users Table name text 2147483647 null

Username (case-insensitively unique)

views Table data text 2147483647 null
stocktransactions Table serials _text 2147483647 null

Serial numbers

storages Table name text 2147483647 null

Name

mailservers Table serverout text 2147483647 ''::text

Server (Outbound)

dunning2transactions Table dunning int4 10 null

Dunning notice ID (**dependency**)

extdatafields Table ID int4 10 null
imports Table date int8 19 null
services Table application int4 10 null

Application ID (null=STANDALONE)

mailservers Table sender text 2147483647 ''::text

Sender name and e-mail address

actionsteps Table transaction int4 10 null

Transaction ID

messages Table to_email text 2147483647 ''::text

First regular recipient e-mail address

users Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

participants Table ID int8 19 null

Particpants ID

services Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

extdatavalues Table number numeric 131089 null
couponcodes Table datefrom int8 19 null

Start date and time as a Unix time stamp; must be less than or equal to dateto

tasks Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

groups Table description text 2147483647 ''::text
contacts2contacts Table ID int8 19 null

Contact-to-contact ID

associations Table relation text 2147483647 ''::text
messages Table to_name text 2147483647 ''::text

First regular recipient name

services Table identifier varchar 200 null

Unique service identifier (Pattern: ^[a-zA-Z\d][\w.-]*$)

feedservers Table recipientuser int4 10 null

Recipient user ID (PUBLIC if recipientuser=null and recipientgroup=null)

tickets Table status int2 5 0

Status (0=NOTSTARTED, 1=AWAITINGACCEPTANCE, 2=ACCEPTED, 3=REJECTED, 4=ACTIVE, 5=INACTIVE, 6=FEEDBACKREQUIRED, 7=TESTING, 8=CANCELLED, 9=COMPLETED, 10=FAILED, 11=BOOKED)

projects Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

mailservers Table usernameout text 2147483647 ''::text

Username (Outbound)

stocktransactions Table amount float8 17 null

Amount (quantity); must not be zero (greater than zero if transfer is not null)

pg_stat_statements View local_blks_read int8 19 null
feedservers Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

services Table url text 2147483647 ''::text
links Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

contacts Table position text 2147483647 ''::text

Position or job title (only for PERSON)

mailservers Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

links Table name text 2147483647 null

Name

pricelists2accounts Table pricelist int4 10 null

Price list ID (**dependency**)

extdatavalues Table value text 2147483647 null
groups Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)

contracts Table datefrom int8 19 null

Start date as a Unix time stamp; must be less than or equal to dateto

accounts Table locked int2 5 0

Deny booking of billing or procurement transactions

events Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

transactions Table status int2 5 0

Status (0=DRAFT, 1=BOOKED, 2=HOLD, 3=CANCELLED, 4=CLOSED, 5=PARTLYORDERED, 6=PARTLYORDERED_CANCELLED, 7=PARTLYORDERED_CLOSED, 8=ORDERED, 9=PARTLYDELIVERED, 10=PARTLYDELIVERED_CANCELLED, 11=PARTLYDELIVERED_CLOSED, 12=DELIVERED, 13=PARTLYINVOICED, 14=PARTLYINVOICED_CANCELLED, 15=PARTLYINVOICED_CLOSED, 16=INVOICED, 17=PARTLYPAID, 18=PARTLYPAID_CANCELLED, 19=PARTLYPAID_CLOSED, 20=PAID, 21=OVERPAID, 22=PROCESSED, 23=PROCESSED_CANCELLED)

pricelists Table datefrom int8 19 null

Start date as a Unix time stamp; must be less than or equal to dateto

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

tickets Table priority int2 5 2

Priority (0=LOWEST, 1=LOW, 2=MEDIUM, 3=HIGH, 4=HIGHEST)

davservers Table username text 2147483647 ''::text

Username

feedids Table feedserver int4 10 null
items Table creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

transactions Table billingregion text 2147483647 ''::text

Billing region or state

ledgers Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

messages Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

projects Table projectnum text 2147483647 ''::text

Project number

davservers Table recipientuser int4 10 null

Recipient user ID (PUBLIC if recipientuser=null and recipientgroup=null)

tagrels Table name int4 10 null
applications Table creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

dunning Table account int4 10 null

Account ID

notes Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

resources Table binfile int4 10 null
extdataregular Table field int4 10 null
dunning Table country varchar 2 ''::character varying

Country code (ISO 3166-1 alpha-2) (Pattern: ^([A-Z]{2})?$)

objects Table assigneduser int4 10 null

Assigned user ID

objects Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

transactions Table exchangerate float8 17 1

Exchange rate as a multiple of one monetary unit of the fixed system currency

tickets Table account int4 10 null

Account ID

messagereads Table message int4 10 null

Message ID (**dependency**)

pricelists Table dateto int8 19 null

End date as a Unix time stamp; must be greater than or equal to datefrom

imports Table name text 2147483647 null
tickets Table project int4 10 null

Project ID

dunning2transactions Table fee float8 17 0

Transaction-specific dunning fee

services Table accesskey text 2147483647 ''::text
couponcodes Table date int8 19 date_part('epoch'::text, now())

Designated date and time as a Unix time stamp (defaults to current date and time on creation)

extdataregular Table number numeric 131089 null
files Table mimetype text 2147483647 'application/octet-stream'::text

MIME type (RFC 2045) (Pattern: ^[a-z]+/[^ \t\v\r\n]+$)

dunning Table dunningnum text 2147483647 null

Dunning number

services Table ID int4 10 null

Service ID

transactions Table ID int4 10 null

Transaction ID

weblets Table view text 2147483647 ''::text

Canonical view

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

extdata View entity text 2147483647 null
dunning Table recipient text 2147483647 ''::text

Recipient

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

messages Table cc text 2147483647 ''::text

All carbon copy recipient names and e-mail addresses

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

associations Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

transactions Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

contracts Table lastbilling int8 19 null

Last billing date and time as a Unix time stamp

imports Table user int4 10 null
tasks Table datefrom int8 19 null

Start date and time as a Unix time stamp

tasks Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

components Table price float8 17 null

Imputed price per unit

tasks Table project int4 10 null

Project ID; is mutually exclusive to ticket

records Table sender text 2147483647 ''::text

Sender

applications Table usersettingsbinfile int4 10 null
invitations Table contact int4 10 null

Contact ID

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

notes Table status int2 5 0
prices Table discount float8 17 0

Relative discount in percent (applied after rebate)

items Table picbinfile int4 10 null
events Table datefrom int8 19 null

Start date and time as a Unix time stamp; must be less than or equal to dateto

links Table ID int4 10 null

Link ID

items Table taxrate float8 17 null

Tax rate in percent

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

files Table filename text 2147483647 ''::text

Filename

payments Table transaction int4 10 null

Transaction ID; is mutually exclusive to account

campaigns Table datefrom int8 19 null

Start date as a Unix time stamp; must be less than or equal to dateto

users Table password text 2147483647 ''::text
events Table color varchar 6 ''::character varying

Color code (CSS-style hexadecimal without #) (Pattern: ^([A-F\d]{3}){0,2}$)

filters Table name text 2147483647 null
groups2users Table group int4 10 null

Group ID

items Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

notes Table contenttype text 2147483647 ''::text

Content MIME type (RFC 2045)

contracts Table billingitems json 2147483647 null
contacts Table email2 text 2147483647 ''::text

Secondary e-mail address

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

accounts Table type int2 5 0

Account type (0=PROSPECT, 1=CUSTOMER, 2=SUPPLIER, 3=CUSTOMERANDSUPPLIER, 4=COMPETITOR, 5=EMPLOYEE)

appointments Table assigneduser int4 10 null

Assigned user ID

suppliers Table account int4 10 null

Account ID (**dependency**)

tasks Table assigneduser int4 10 null

Assigned user ID

coupons Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

extdatavalues Table field int4 10 null
services Table schedule int4 10 0

Schedule as a minute of each day (only for TIMING)

feedids Table uuid text 2147483647 null
contracts Table procurementitems json 2147483647 null
feedservers Table notify int2 5 0

Notify about new records

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

tasks Table ID int4 10 null

Task ID

transactions Table netamount float8 17 0

Total net amount

tasks Table tasknum text 2147483647 ''::text

Task number

records Table text text 2147483647 ''::text

Record text (Markdown for rich text representation)

davservers Table type int2 5 0

Collection type (0=CONTACTS, 2=APPOINTMENTS, 1=TASKS)

payments Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

applications Table ID int4 10 null

Application ID

associations Table index1 int4 10 null

First entity ID

applications Table defaultsettings json 2147483647 null
addresses Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)

couponcodes Table code text 2147483647 null

Coupon code

dunning Table address text 2147483647 ''::text

Address (street and building/suite number)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

records Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

weblets Table svgpath text 2147483647 ''::text

SVG path for icon (square)

categories Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

comments Table record int8 19 null

Record ID (**dependency**)

numcounters Table counter int4 10 0
imports Table settings json 2147483647 null
feedservers Table url text 2147483647 null

Feed URL

appointments Table daterecurrence int8 19 null

Recurrence end date as a Unix time stamp

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

recent Table user int4 10 null
services Table binfile int4 10 null
events Table meta json 2147483647 null
transactions Table shippingcity text 2147483647 ''::text

Shipping city or municipality

contacts Table department text 2147483647 ''::text

Department (only for PERSON)

suppliers Table minamount float8 17 0

Minimum order amount (quantity)

recent Table index int4 10 null
messages Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

pricelists2accounts Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

campaigns Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

transactions Table weight float8 17 0

Total shipping weight in kilogram

appointments Table datefrom int8 19 null

Start date and time as a Unix time stamp; must be less than or equal to dateto

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

ledgers Table description text 2147483647 ''::text

Detailed general description

extdataempty Table value text 2147483647 null
davservers Table synctoken text 2147483647 ''::text

Synchronization token (RFC 6578)

applications Table restricted int2 5 0
objects Table entity text 2147483647 null

Custom entity

mailinglists Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

projects Table ID int4 10 null

Project ID

tasks Table projectedeffort int4 10 0

Projected effort in minutes

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

ledgers Table ID int4 10 null

Ledger ID

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

pg_stat_statements View shared_blks_hit int8 19 null
payments Table ID int8 19 null

Payment ID

groups2users Table user int4 10 null

User ID

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

extdataregular Table index int8 19 null
likes Table record int8 19 null

Record ID (**dependency**)

storages Table description text 2147483647 ''::text

Detailed general description

opportunities Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

participants Table phone text 2147483647 ''::text

Phone number

projects Table assigneduser int4 10 null

Assigned user ID

contacts Table cell text 2147483647 ''::text

Cell phone number

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

couponcodes Table transaction int4 10 null

Transaction ID

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

addresses Table ID int8 19 null

Address ID

actionsteps Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

groups Table name text 2147483647 null

Name (case-insensitively unique)

tasks Table priority int2 5 2

Priority (0=LOWEST, 1=LOW, 2=MEDIUM, 3=HIGH, 4=HIGHEST)

accounts Table description text 2147483647 ''::text

Detailed general description

imapids Table hash varchar 32 null
davservers Table creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

stocktransactions Table item int4 10 null

Item ID (**dependency**)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

contracts Table assigneduser int4 10 null

Assigned user ID

stocktransactions Table ID int8 19 null

Stock transaction ID

transactions Table duedate int8 19 null

Due date as a Unix time stamp

davids Table task int4 10 null
pg_stat_statements View local_blks_written int8 19 null
storages Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

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

Designated date and time as a Unix time stamp (defaults to current date and time on creation)

mailservers Table signaturebinfile int4 10 null
payments Table ledger int4 10 null

Ledger ID

davservers Table ctag text 2147483647 ''::text

Collection entity tag (CTag) (caldav-ctag-03)

campaigns Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

filters Table data text 2147483647 null
resources Table name text 2147483647 null

Name

coupons Table type int2 5 0

Coupon type (0=PROMOTION, 1=INDIVIDUAL)

coupons Table dateto int8 19 null

End date and time as a Unix time stamp; must be greater than or equal to datefrom

dunning Table status int2 5 0

Status (0=DRAFT, 1=BOOKED, 2=CANCELLED, 3=CLOSED)

tickets Table name text 2147483647 null

Name

permissions Table ID int8 19 null

Permission ID

transactions Table billingaddress text 2147483647 ''::text

Billing address (street and building/suite number)

transactions Table billingpostalcode text 2147483647 ''::text

Billing postal or ZIP code

stocktransactions Table subtransactions _int8 19 null

Sub-transaction IDs

accounts Table suppliernum text 2147483647 ''::text

Supplier number (only for SUPPLIER or CUSTOMERANDSUPPLIER)

projects Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

users Table otpsecret text 2147483647 ''::text
prices Table pricelist int4 10 null

Price list ID (**dependency**)

coupons Table value float8 17 0

Default value

weblets Table application int4 10 null

Application ID (null=STANDALONE)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

appointments Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

transactions Table productionfactor int4 10 null

Production factor; is required for PRODUCTION, otherwise must be null

opportunities Table priority int2 5 2

Priority (0=LOWEST, 1=LOW, 2=MEDIUM, 3=HIGH, 4=HIGHEST)

users Table lastlogin int8 19 null

Last login date and time as a Unix time stamp

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

suppliers Table ID int8 19 null

Supplier ID

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

comments Table text text 2147483647 ''::text

Comment text (Markdown for rich text representation)

items Table type int2 5 0

Item type (0=SIMPLE, 1=SERIALS, 2=CHARGES, 3=SERIALSANDCHARGES, 4=SET, 5=CONTAINER, 6=NOSTOCK, 7=MODEL)

davservers Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

binfiles Table hash varchar 32 null
categories Table ID int4 10 null

Category ID

items Table model int4 10 null

Model item ID (only for non-MODEL)

notes Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

pg_stat_statements View rows int8 19 null
tagnames Table name text 2147483647 null
items Table barcode text 2147483647 ''::text

Barcode (e.g. UPC or EAN/GTIN)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

prices Table price float8 17 null

Price per unit (null=item.sellingprice for billing or null=item.purchaseprice for procurement)

pg_stat_statements View mean_time float8 17 null
accounts Table ID int4 10 null

Account ID

pricelists Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)

applications Table secret varchar 40 ''::character varying
invitations Table flag int2 5 0

Flag (0=UNANSWERED, 1=CONFIRMED, 2=REJECTED)

messages Table mailbox int2 5 0

Type (0=INBOX, 1=DRAFTS, 2=SENT, 3=TEMPLATES, 4=MAILINGS, 5=ARCHIVE, 6=TRASH, 7=JUNK)

notes Table binfile int4 10 null
contracts Table autobilling json 2147483647 null
pg_stat_statements View shared_blks_dirtied int8 19 null
components Table ID int8 19 null

Component ID

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

groups Table ID int4 10 null

Group ID

contracts Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

suppliers Table item int4 10 null

Item ID (**dependency**)

contacts Table region text 2147483647 ''::text

Region or state

applications Table version int4 10 10000

Version number (formatted as 1.00-00)

mailservers Table passwordin text 2147483647 ''::text
components Table component int4 10 null

Component item ID; must be distinct from item

stocktransactions Table chargenum text 2147483647 ''::text

Charge (lot) number

opportunities Table duedate int8 19 null

Due date as a Unix time stamp

applications Table vendor text 2147483647 ''::text

Vendor (developer or company name)

coupons Table code text 2147483647 ''::text

Promotion code (only for PROMOTION)

ledgers Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

records Table ID int8 19 null

Record ID

groups Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

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

Designated date and time as a Unix time stamp (defaults to current date and time on creation)

binfiles Table date int8 19 date_part('epoch'::text, now())
dunning Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

contacts Table title text 2147483647 ''::text

Title or salutation (only for PERSON)

items Table purchaseprice float8 17 0

Default purchase price per unit

contacts Table phone text 2147483647 ''::text

Primary phone number

transactions Table assigneduser int4 10 null

Assigned user ID

associations Table ID int8 19 null

Association ID

links Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

feedservers Table ID int4 10 null

Feed server ID

pricelists Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

contracts Table ID int4 10 null

Contract ID

tickets Table procurementitems json 2147483647 null
addresses Table default int2 5 0

Default for this address type

feedservers Table recipientgroup int4 10 null

Recipient group ID (PUBLIC if recipientuser=null and recipientgroup=null)

users Table email text 2147483647 null

System e-mail address (case-insensitively unique)

payments Table amount float8 17 null

Amount (monetary); must not be zero

applications Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)

events Table index int4 10 null

Entity ID; is required if entity is not null, otherwise must be null

payments Table subject text 2147483647 ''::text

Subject (e.g. bank statement or reference number)

participants Table contact int4 10 null

Contact ID

recent Table date int8 19 null
contracts Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)

pg_stat_statements View stddev_time float8 17 null
users Table lastloginattempt int8 19 null
applications Table settingsbinfile int4 10 null
users Table loginattempts int4 10 0
davservers Table ID int4 10 null

DAV server ID

events Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

davservers Table recipientgroup int4 10 null

Recipient group ID (PUBLIC if recipientuser=null and recipientgroup=null)

messages Table contenttype text 2147483647 ''::text

Content MIME type (RFC 2045)

messages Table sender_name text 2147483647 ''::text

Sender name

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

opportunities Table account int4 10 null

Account ID

resources Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)

opportunities Table campaign int4 10 null

Campaign ID

pg_stat_statements View total_time float8 17 null
couponcodes Table ID int8 19 null

Coupon code ID

coupons Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)

dunning2transactions Table ID int8 19 null

Dunning-to-transaction ID

couponcodes Table coupon int4 10 null

Coupon ID (**dependency**)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

messages Table reference int4 10 null

Reference message (reply-to) ID; must be distinct from ID

events Table dateto int8 19 null

End date and time as a Unix time stamp; must be greater than or equal to datefrom

coupons Table description text 2147483647 ''::text

Detailed general description

accounts Table customernum text 2147483647 ''::text

Customer number (only for PROSPECT, CUSTOMERANDSUPPLIER, CUSTOMER or EMPLOYEE)

campaigns Table status int2 5 0

Status (0=DRAFT, 1=NOTSTARTED, 2=AWAITINGAPPROVAL, 3=APPROVED, 4=DISMISSED, 5=ACTIVE, 6=INACTIVE, 7=INEVALUATION, 8=CANCELLED, 9=CLOSED)

items Table unit varchar 3 ''::character varying

Unit code (UN/CEFACT Recommendation 20)

comments Table sender text 2147483647 ''::text

Sender

messages Table ticket int4 10 null

Ticket ID; is mutually exclusive to opportunity

actionsteps Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

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

Designated date and time as a Unix time stamp (defaults to current date and time on creation)

transactions Table account int4 10 null

Account ID; must be null for PRODUCTION

contacts Table company text 2147483647 ''::text

Company name (only for PERSON)

contacts Table email text 2147483647 ''::text

Primary e-mail address

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

mailinglists Table description text 2147483647 ''::text

Detailed general description

follows Table entity text 2147483647 null

Canonical entity

tasks Table description text 2147483647 ''::text

Detailed general description

resources Table public int2 5 0

Publicly accessible

opportunities Table upside float8 17 0

Upside monetary outcome

links Table url text 2147483647 ''::text

URL

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

objects Table binfile int4 10 null
contracts Table account int4 10 null

Account ID

numcounters Table identifier text 2147483647 null
feedservers Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)

users Table ID int4 10 null

User ID

payments Table account int4 10 null

Account ID; is mutually exclusive to transaction

users Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)

pricelists Table applytoall int2 5 0

Apply to all accounts regardless of association via pricelists2accounts

contracts Table name text 2147483647 null

Name

addresses Table type int2 5 0

Address type (0=BILLING_SHIPPING, 1=BILLING_BILLING, 2=PROCUREMENT_SHIPPING, 3=PROCUREMENT_BILLING)

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

Designated date and time as a Unix time stamp (defaults to current date and time on creation)

opportunities Table mostlikely float8 17 0

Most likely monetary outcome

contracts Table datecancel int8 19 null

Cancellation date as a Unix time stamp

contacts Table address text 2147483647 ''::text

Address (street and building/suite number)

contacts Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

weblets Table identifier varchar 200 null

Unique weblet identifier (Pattern: ^[a-zA-Z\d][\w.-]*$)

transactions Table currency varchar 3 null

Currency code (ISO 4217) (Pattern: ^[A-Z]{3}$)

transactions Table margin float8 17 0

Total absolute margin

davservers Table description text 2147483647 ''::text

Detailed general description

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

coupons Table datefrom int8 19 null

Start date and time as a Unix time stamp; must be less than or equal to dateto

links Table username text 2147483647 ''::text

Username

tags View index int8 19 null
campaigns Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

likes Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

tickets Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

tickets Table description text 2147483647 ''::text

Detailed general description

files Table comment int8 19 null

Comment ID (**dependency**); is mutually exclusive to record (either one is required)

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

Designated date and time as a Unix time stamp (defaults to current date and time on creation)

mailinglists Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

follows Table index int8 19 null

Entity ID

imapids Table uid int4 10 null
imapids Table mailserver int4 10 null
campaigns Table dateto int8 19 null

End date as a Unix time stamp; must be greater than or equal to datefrom

users Table resetlogintoken varchar 40 ''::character varying
recent Table entity text 2147483647 null
tasks Table status int2 5 0

Status (0=NOTSTARTED, 1=AWAITINGACCEPTANCE, 2=ACCEPTED, 3=REJECTED, 4=ACTIVE, 5=INACTIVE, 6=FEEDBACKREQUIRED, 7=TESTING, 8=CANCELLED, 9=COMPLETED, 10=FAILED, 11=BOOKED)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

extdata View number numeric 131089 null
opportunities Table name text 2147483647 null

Name

pg_stat_statements View min_time float8 17 null
events Table entity text 2147483647 null

Canonical entity

mailinglists Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

contacts Table birthdate int8 19 null

Birth date as a Unix time stamp (only for PERSON)

appointments Table name text 2147483647 null

Name

transactions Table type int2 5 0

Transaction type (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, 10=PRODUCTION_FABRICATION, 11=PRODUCTION_DISASSEMBLY)

extdata View name text 2147483647 null
couponcodes Table flag int2 5 0

Flag (0=BOOKED, 1=RESERVED, 2=CANCELLED)

binfiles Table size int4 10 null
coupons Table taxrate float8 17 null

Tax rate in percent

extdataempty Table field int4 10 null
fields Table view text 2147483647 null
items Table description text 2147483647 ''::text

Detailed general description

stocktransactions Table transaction int4 10 null

Transaction ID

participants Table email text 2147483647 ''::text

E-mail address

messages Table bcc text 2147483647 ''::text

All blind carbon copy recipient names and e-mail addresses

mailinglists Table sender text 2147483647 ''::text

Sender name and e-mail address

files Table record int8 19 null

Record ID (**dependency**); is mutually exclusive to comment (either one is required)

opportunities Table ID int4 10 null

Opportunity ID

messages Table senddate int8 19 null

Scheduled send date and time as a Unix time stamp

addresses Table contact int4 10 null

Contact ID

weblets Table url text 2147483647 ''::text
couponcodes Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)

transactions Table shippingrecipient text 2147483647 ''::text

Shipping recipient

participants Table mailinglist int4 10 null

Mailing list ID (**dependency**); is mutually exclusive to campaign (either one is required)

messages Table to text 2147483647 ''::text

All regular recipient names and e-mail addresses

tickets Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

messages Table mailserver int4 10 null

Mail server ID

tasks Table name text 2147483647 null

Name

feedservers Table username text 2147483647 ''::text

Username

notes Table name text 2147483647 null

Name

users Table sessionid varchar 40 ''::character varying
actionsteps Table duedate int8 19 null

Due date and time as a Unix time stamp

tasks Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

transactions Table transactionnum text 2147483647 null

Transaction number

weblets Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)

contracts Table billingcycle int2 5 null

Billing cycle in months

addresses Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

comments Table ID int8 19 null

Comment ID

couponcodes Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

dunning Table duedate int8 19 null

Due date as a Unix time stamp

weblets Table height int2 5 0

Height in pixels (0=100%)

extdatafields Table entity text 2147483647 null
pg_stat_statements View dbid oid 10 null
mailservers Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

groups Table leader int4 10 null

Leader user ID

ledgers Table name text 2147483647 null

Name

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

payments Table description text 2147483647 ''::text

Detailed general description

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

contracts Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

mailservers Table autoreplybinfile int4 10 null
mailinglists Table ID int4 10 null

Mailing list ID

stocktransactions Table flag int2 5 0

Flag (0=BOOKED, 1=RESERVED, 2=CANCELLED)

davids Table vobject text 2147483647 ''::text
ledgers Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

tickets Table ID int4 10 null

Ticket ID

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

couponcodes Table value float8 17 0

Value

contacts Table ID int4 10 null

Contact ID

projects Table description text 2147483647 ''::text

Detailed general description

stocktransactions Table location text 2147483647 ''::text

Physical location (e.g. shelf identification)

stocktransactions Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

mailservers Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

imapids Table mailbox text 2147483647 null
transactions Table discount float8 17 0

Total absolute discount

pricelists2accounts Table ID int8 19 null

Pricelist-to-account ID

weblets Table type int2 5 0

Weblet type (0=INTEGRATED, 1=STANDALONE, 2=DETACHED, 3=POPUP_FRAMED, 4=POPUP_PLAIN, 5=EMBEDDED_FRAMED, 6=EMBEDDED_COLLAPSED, 7=EMBEDDED_PLAIN)

notes Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

suppliers Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

stocktransactions Table storage int4 10 null

Storage ID

mailinglists Table name text 2147483647 null

Name

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

opportunities Table description text 2147483647 ''::text

Detailed general description

weblets Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

tasks Table duedate int8 19 null

Due date and time as a Unix time stamp

links Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

contacts Table picbinfile int4 10 null
prices Table ID int8 19 null

Price ID

davids Table href text 2147483647 null
ledgers Table creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

views Table user int4 10 null
suppliers Table itemnum text 2147483647 ''::text

Supplier item number (SKU)

resources Table ID int4 10 null

Resource ID

actionsteps Table description text 2147483647 ''::text

Detailed general description

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

categories Table name text 2147483647 null

Name

mailservers Table folders json 2147483647 null
actionsteps Table effort int4 10 0

Effort in minutes

imports Table entity text 2147483647 null
mailservers Table serverin text 2147483647 ''::text

Server (Inbound)

messages Table binfile int4 10 null
pg_stat_statements View userid oid 10 null
actionsteps Table ticket int4 10 null

Ticket ID; is mutually exclusive to task and account

items Table ID int4 10 null

Item ID

messages Table subject text 2147483647 ''::text

Subject

feedservers Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

opportunities Table worstcase float8 17 0

Worst-case monetary outcome

notes Table ID int4 10 null

Note ID

permissions Table group int4 10 null

Group ID

suppliers Table deliverytime int2 5 null

Expected delivery time in days

messages Table sender_email text 2147483647 ''::text

Sender e-mail address

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

objects Table data json 2147483647 null
records Table entity text 2147483647 null

Canonical entity

actionsteps Table actionnum text 2147483647 ''::text

Action number

mailinglists Table campaign int4 10 null

Campaign ID

accounts Table lastname text 2147483647 ''::text

Last name (surname or company name); is required if firstname is empty

links Table assigneduser int4 10 null

Assigned user ID

tagnames Table entity text 2147483647 null
contacts Table assigneduser int4 10 null

Assigned user ID

records Table stickydate int8 19 null
dunning Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

appointments Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

components Table amount float8 17 0

Amount (quantity)

applications Table identifier varchar 200 null

Unique application identifier (Pattern: ^[a-zA-Z\d][\w.-]*$)

appointments Table color varchar 6 ''::character varying

Color code (CSS-style hexadecimal without #) (Pattern: ^([A-F\d]{3}){0,2}$)

dunning Table postalcode text 2147483647 ''::text

Postal or ZIP code

extdataregular Table value text 2147483647 null
opportunities Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

weblets Table ID int4 10 null

Weblet ID

messages Table senderror text 2147483647 ''::text

Last error message from failure to send

pg_stat_statements View calls int8 19 null
appointments Table dateto int8 19 null

End date and time as a Unix time stamp; must be greater than or equal to datefrom

likes Table ID int8 19 null

Like ID

actionsteps Table status int2 5 0

Status (0=DRAFT, 1=COMPLETED, 2=CANCELLED, 3=BOOKED)

services Table entity text 2147483647 ''::text

Canonical entity (only for AFTERCREATION, BEFOREMODIFICATION, AFTERMODIFICATION, AFTERCREATIONORMODIFICATION, BEFOREDELETION or AFTERDELETION)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

notes Table text text 2147483647 ''::text

Plain text version of content

tasks Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

pricelists Table name text 2147483647 null

Name

weblets Table langaliases json 2147483647 null

Language-specific aliases; use language code as object key

mailinglists Table assigneduser int4 10 null

Assigned user ID

addresses Table account int4 10 null

Account ID (**dependency**)

invitations Table email text 2147483647 ''::text

E-mail address

comments Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

tags View name text 2147483647 null
pg_stat_statements View queryid int8 19 null
tickets Table billingitems json 2147483647 null
services Table name text 2147483647 null

Name

contracts Table contractnum text 2147483647 ''::text

Contract number

projects Table status int2 5 0

Status (0=DRAFT, 1=NOTSTARTED, 2=AWAITINGAPPROVAL, 3=APPROVED, 4=DISMISSED, 5=ACTIVE, 6=INACTIVE, 7=TESTING, 8=CANCELLED, 9=COMPLETED, 10=FAILED, 11=BOOKED)

dunning Table level int2 5 0

Dunning level (0=REMINDER, 1=INITIAL, 2=INTERMEDIATE, 3=FINAL)

accounts Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

tagnames Table ID int4 10 null
groups Table creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

notes Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

davids Table contact int4 10 null
notifications Table date int8 19 null
actionsteps Table task int4 10 null

Task ID; is mutually exclusive to ticket and account

prices Table item int4 10 null

Item ID (**dependency**)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

mailservers Table recipientuser int4 10 null

Recipient user ID (PUBLIC if recipientuser=null and recipientgroup=null)

dunning Table region text 2147483647 ''::text

Region or state

resources Table mimetype text 2147483647 'text/x-zymba'::text

MIME type (RFC 2045) (Pattern: ^[a-z]+/[^ \t\v\r\n]+$)

appointments Table interval int2 5 1

Recurrence interval in minutes

tickets Table assigneduser int4 10 null

Assigned user ID

items Table name text 2147483647 null

Product name

pg_stat_statements View blk_read_time float8 17 null
records Table assigneduser int4 10 null

Assigned user (recipient) ID; must be distinct from creator

objects Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

categories Table entity text 2147483647 null

Canonical entity

coupons Table ID int4 10 null

Coupon ID

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

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

Designated date and time as a Unix time stamp (defaults to current date and time on creation)

transactions Table billingcountry varchar 2 ''::character varying

Billing country code (ISO 3166-1 alpha-2) (Pattern: ^([A-Z]{2})?$)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

pricelists2accounts Table account int4 10 null

Account ID (**dependency**)

suppliers Table stock float8 17 null

Expected stock/inventory amount (quantity)

fields Table data text 2147483647 null
objects Table description text 2147483647 ''::text

Detailed general description

weblets Table color varchar 6 ''::character varying

Color code (CSS-style hexadecimal without #) (Pattern: ^([A-F\d]{3}){0,2}$)

records Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

groups2users Table ID int8 19 null

Group-to-user ID

pg_stat_statements View shared_blks_written int8 19 null
appointments Table ID int4 10 null

Appointment ID

components Table item int4 10 null

Item ID (**dependency**)

users Table nopublic int2 5 0

Deny access to public data

pg_stat_statements View local_blks_dirtied int8 19 null
opportunities Table creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

pg_stat_statements View shared_blks_read int8 19 null
messagereads Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

follows Table ID int8 19 null

Follow ID

transactions Table shippingregion text 2147483647 ''::text

Shipping region or state

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

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

Designated date and time as a Unix time stamp (defaults to current date and time on creation)

contacts Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

pg_stat_statements View local_blks_hit int8 19 null
records Table meta json 2147483647 null
davids Table etag text 2147483647 ''::text
links Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

records Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

mailservers Table usernamein text 2147483647 ''::text

Username (Inbound)

participants Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

contacts Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

objects Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

tickets Table duedate int8 19 null

Due date and time as a Unix time stamp

stocktransactions Table transfer int8 19 null

Transfer stock transaction ID; must be distinct from ID and null for RESERVED

tokens Table identifier text 2147483647 null
messages Table to_count int4 10 0

Number of regular recipients

contacts Table type int2 5 0

Contact type (0=COMPANY, 1=PERSON)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

payments Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

services Table type int2 5 null

Service type (0=TIMING, 1=REMOTECALL, 2=AFTERCREATION, 3=BEFOREMODIFICATION, 4=AFTERMODIFICATION, 5=AFTERCREATIONORMODIFICATION, 6=BEFOREDELETION, 7=AFTERDELETION)

projects Table name text 2147483647 null

Name

contacts Table lastname text 2147483647 ''::text

Last name (surname or company name); is required if firstname is empty

storages Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

appointments Table recurrence int2 5 null

Recurrence (0=DAY, 1=WORKDAY, 2=WEEK, 3=MONTH, 4=YEAR)

follows Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

extdataempty Table number numeric 131089 null
tags View entity text 2147483647 null
appointments Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

objects Table ID int4 10 null

Object ID

contacts2contacts Table contact1 int4 10 null

First contact ID (**dependency**)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

actionsteps Table account int4 10 null

Account ID; is mutually exclusive to task and ticket

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

accounts Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

opportunities Table contact int4 10 null

Contact ID

filters Table view text 2147483647 null
pricelists Table creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

records Table flag int2 5 0

Flag (0=REGULAR, 1=ASSOCONLY, 2=MINDLOGONLY, 3=MONITOR); must be REGULAR if entity is null

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

contacts Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

contracts Table exchangerate float8 17 1

Exchange rate as a multiple of one monetary unit of the fixed system currency

mailservers Table description text 2147483647 ''::text

Detailed general description

davids Table davserver int4 10 null
messages Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)

contracts Table description text 2147483647 ''::text

Detailed general description

files Table binfile int4 10 null
opportunities Table probability int2 5 0

Probability of success in percent; must be 100 for ACCEPTED

services Table interval int2 5 1

Interval in minutes (only for TIMING)

weblets Table name text 2147483647 null

Name

actionsteps Table assigneduser int4 10 null

Assigned user ID

pg_stat_statements View temp_blks_read int8 19 null
binfiles Table ID int4 10 null
notes Table assigneduser int4 10 null

Assigned user ID

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

suppliers Table price float8 17 null

Supplier price per unit

categories Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

messages Table opportunity int4 10 null

Opportunity ID; is mutually exclusive to ticket

contacts Table firstname text 2147483647 ''::text

First name (given name); is required if lastname is empty

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

invitations Table ID int8 19 null

Invitation ID

extdataempty Table index int8 19 null
files Table size int4 10 0

Size in bytes

files Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

davservers Table ownergroup int4 10 null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

transactions Table billingrecipient text 2147483647 ''::text

Billing recipient

contacts Table phone2 text 2147483647 ''::text

Secondary phone number

applications Table settings json 2147483647 null
imapids Table message int4 10 null
contracts Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

tokens Table application int4 10 null
transactions Table contract int4 10 null

Contract ID

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

davids Table appointment int4 10 null
mailservers Table ID int4 10 null

Mail server ID

tokens Table expdate int8 19 null
pg_stat_statements View query text 2147483647 null
stocktransactions Table sellingprice float8 17 0

Selling price per unit

associations Table meta json 2147483647 null
notifications Table flag int2 5 0
resources Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)

components Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

fields Table name text 2147483647 null
invitations Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

users Table expdate int8 19 null

Expiry date and time as a Unix time stamp

stocktransactions Table purchaseprice float8 17 0

Purchase price per unit

weblets Table mimetype text 2147483647 'text/x-zymba'::text

MIME type (RFC 2045)

services Table mimetype text 2147483647 'text/x-zymba'::text

MIME type (RFC 2045)

contacts Table city text 2147483647 ''::text

City or municipality

feedservers Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)

davservers Table password text 2147483647 ''::text
applications Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

imapids Table uidvalidity int4 10 null
mailservers Table passwordout text 2147483647 ''::text
contacts2contacts Table contact2 int4 10 null

Second contact ID (**dependency**)

applications Table name text 2147483647 null

Name

contracts Table currency varchar 3 null

Currency code (ISO 4217) (Pattern: ^[A-Z]{3}$)

accounts Table excludetax int2 5 0

Exclude from taxation

events Table name text 2147483647 null

Name

filters Table user int4 10 null
campaigns Table creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

mailservers Table ticketing json 2147483647 null
storages Table ID int4 10 null

Storage ID

feedservers Table password text 2147483647 ''::text
associations Table entity1 text 2147483647 null

First canonical entity

pricelists Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

contacts Table country varchar 2 ''::character varying

Country code (ISO 3166-1 alpha-2) (Pattern: ^([A-Z]{2})?$)

tagrels Table index int8 19 null
payments Table creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

campaigns Table ID int4 10 null

Campaign ID

extdatavalues Table index int8 19 null
users Table signature varchar 32 null
links Table description text 2147483647 ''::text

Detailed general description

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

dunning Table ID int4 10 null

Dunning notice ID

prices Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

tasks Table ticket int4 10 null

Ticket ID; is mutually exclusive to project

projects Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

actionsteps Table name text 2147483647 null

Name

objects Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

campaigns Table description text 2147483647 ''::text

Detailed general description

users Table settings json 2147483647 null
users Table description text 2147483647 ''::text
davservers Table name text 2147483647 null

Name

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

participants Table campaign int4 10 null

Campaign ID (**dependency**); is mutually exclusive to mailinglist (either one is required)

coupons Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

davservers Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)

extdata View index int8 19 null
appointments Table description text 2147483647 ''::text

Detailed general description

pricelists Table type int2 5 0

Price list type (0=BILLING_MIN, 1=BILLING_MAX, 2=PROCUREMENT_MIN, 3=PROCUREMENT_MAX)

users Table persistentlogintoken varchar 40 ''::character varying
tickets Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

prices Table rebate float8 17 0

Absolute rebate per unit (applied before discount)

views Table view text 2147483647 null
opportunities Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

items Table manufacturer text 2147483647 ''::text

Manufacturer (brand or company name)

links Table password text 2147483647 ''::text

Password

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

items Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

transactions Table tax float8 17 0

Total tax amount

feedservers Table name text 2147483647 null

Name

notes Table description text 2147483647 ''::text

Detailed general description

extdatafields Table name text 2147483647 null
transactions Table shippingpostalcode text 2147483647 ''::text

Shipping postal or ZIP code

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

Designated date and time as a Unix time stamp (defaults to current date and time on creation)

links Table visits int4 10 0

Number of visits

messages Table size int4 10 0

Size in bytes

mailservers Table name text 2147483647 null

Name

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

stocktransactions Table reference text 2147483647 ''::text

Reference identification

messages Table text text 2147483647 ''::text

Plain text version of content

feedservers Table etag text 2147483647 ''::text

Entity tag (ETag) (RFC 7232)

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

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

contracts Table status int2 5 0

Status (0=DRAFT, 1=AWAITINGAPPROVAL, 2=APPROVED, 3=DISMISSED, 4=ACTIVE, 5=INACTIVE, 6=EXPIRED, 7=CANCELLED, 8=CLOSED)

campaigns Table assigneduser int4 10 null

Assigned user ID

messages Table sender text 2147483647 ''::text

Sender name and e-mail address

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

Last modification date and time as a Unix time stamp (auto-reset on modification)

opportunities Table assigneduser int4 10 null

Assigned user ID

dunning Table assigneduser int4 10 null

Assigned user ID

resources Table application int4 10 null

Application ID (null=STANDALONE)

resources Table identifier varchar 200 null

Unique resource identifier (Pattern: ^[a-zA-Z\d][\w.-]*$)

tickets Table ticketnum text 2147483647 ''::text

Ticket number

contracts Table dateto int8 19 null

End date as a Unix time stamp; must be greater than or equal to datefrom

storages Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

actionsteps Table ID int4 10 null

Action step ID

transactions Table billingcity text 2147483647 ''::text

Billing city or municipality

pricelists Table description text 2147483647 ''::text

Detailed general description

appointments Table location text 2147483647 ''::text

Location

groups2users Table writable int2 5 0

Allow writing of group-owned data by user

notifications Table record int8 19 null
weblets Table width int2 5 0

Width in pixels (0=100%)

payments Table assigneduser int4 10 null

Assigned user ID

permissions Table writable int2 5 0

Allow writing of permission-specific data by group members

prices Table minamount float8 17 0

Minimum amount (quantity)

accounts Table assigneduser int4 10 null

Assigned user ID

couponcodes Table dateto int8 19 null

End date and time as a Unix time stamp; must be greater than or equal to datefrom

coupons Table name text 2147483647 null

Name

transactions Table shippingaddress text 2147483647 ''::text

Shipping address (street and building/suite number)

tokens Table user int4 10 null
associations Table entity2 text 2147483647 null

Second canonical entity

tokens Table token varchar 40 null