Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
components Table amount float8 17 0

Amount (quantity)
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)
pg_stat_statements View temp_blks_written int8 19 √ null
tokens Table expdate int8 19 √ null
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)
davservers Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
applications Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
messages Table to_email text 2147483647 ''::text

First regular recipient e-mail address
appointments Table location text 2147483647 ''::text

Location
davids Table href text 2147483647 null
items Table itemnum text 2147483647 ''::text

Item number (SKU)
coupons Table name text 2147483647 null

Name
appointments Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
messages Table senddate int8 19 √ null

Scheduled send date and time as a Unix time stamp
transactions Table shippingcity text 2147483647 ''::text

Shipping city or municipality
appointments Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
follows Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)
imapids Table uidvalidity int4 10 null
mailinglists Table assigneduser int4 10 √ null

Assigned user ID
events Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
feedservers Table url text 2147483647 null

Feed URL
mailinglists Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
notes Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
users Table resetlogintoken varchar 40 ''::character varying
messages Table contenttype text 2147483647 ''::text

Content MIME type (RFC 2045)
contacts Table position text 2147483647 ''::text

Position or job title (only for PERSON)
campaigns Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
applications Table secret varchar 40 ''::character varying
tasks Table ID int4 10 √ null

Task ID
resources Table binfile int4 10 √ null
messages Table subject text 2147483647 ''::text

Subject
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)
tags View name text 2147483647 √ null
items Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
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)
coupons Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
recent Table index int4 10 null
opportunities Table contact int4 10 √ null

Contact ID
dunning Table dunningnum text 2147483647 null

Dunning number
feedids Table uuid text 2147483647 null
components Table price float8 17 √ null

Imputed price per unit
storages Table ownergroup int4 10 √ null

Owner group ID (null=PUBLIC)
messages Table ticket int4 10 √ null

Ticket ID; is mutually exclusive to opportunity
dunning Table city text 2147483647 ''::text

City or municipality
dunning Table address text 2147483647 ''::text

Address (street and building/suite number)
associations Table creator int4 10 √ null

Creator user ID (defaults to authenticated user 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)
opportunities Table account int4 10 √ null

Account ID
opportunities Table name text 2147483647 null

Name
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)
contacts Table birthdate int8 19 √ null

Birth date as a Unix time stamp (only for PERSON)
associations Table relation text 2147483647 ''::text
mailservers Table serverout text 2147483647 ''::text

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

Last modification date and time as a Unix time stamp (auto-reset on modification)
suppliers Table stock float8 17 √ null

Expected stock/inventory amount (quantity)
events 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)
weblets Table ID int4 10 √ null

Weblet ID
pricelists Table ownergroup int4 10 √ null

Owner group ID (null=PUBLIC)
tickets Table ID int4 10 √ null

Ticket ID
permissions Table group int4 10 null

Group ID
participants Table contact int4 10 √ null

Contact ID
accounts Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
pricelists Table datefrom int8 19 √ null

Start date as a Unix time stamp; must be less than or equal to dateto
accounts Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
contacts Table ID int4 10 √ null

Contact ID
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)
projects Table ID int4 10 √ null

Project ID
ledgers Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
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)
mailinglists Table name text 2147483647 null

Name
contracts Table ID int4 10 √ null

Contract ID
ledgers Table description text 2147483647 ''::text

Detailed general description
stocktransactions Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
filters Table user int4 10 null
follows Table entity text 2147483647 null

Canonical entity
transactions Table billingpostalcode text 2147483647 ''::text

Billing postal or ZIP code
coupons Table ownergroup int4 10 √ null

Owner group ID (null=PUBLIC)
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)
associations Table entity2 text 2147483647 null

Second canonical entity
users Table ID int4 10 √ null

User ID
suppliers Table account int4 10 null

Account ID (**dependency**)
contacts Table department text 2147483647 ''::text

Department (only for PERSON)
contacts Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
links Table url text 2147483647 ''::text

URL
contracts Table description text 2147483647 ''::text

Detailed general description
notes Table size int4 10 0

Size in bytes
feedservers Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
projects Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
transactions Table currency varchar 3 null

Currency code (ISO 4217) (Pattern: ^[A-Z]{3}$)
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)
groups Table leader int4 10 √ null

Leader user ID
tasks Table ticket int4 10 √ null

Ticket ID; is mutually exclusive to project
events Table dateto int8 19 null

End date and time as a Unix time stamp; must be greater than or equal to datefrom
transactions Table billingregion text 2147483647 ''::text

Billing region or state
contracts Table lastbilling int8 19 √ null

Last billing date and time as a Unix time stamp
pg_stat_statements View calls int8 19 √ null
davids Table contact int4 10 √ null
pricelists2accounts Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
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)
contracts Table datecancel int8 19 √ null

Cancellation date as a Unix time stamp
pricelists Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
messages Table mailinglist int4 10 √ null

Mailing list ID
davservers Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
payments Table account int4 10 √ null

Account ID; is mutually exclusive to transaction
resources Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
users Table email text 2147483647 null

System e-mail address (case-insensitively unique)
campaigns Table description text 2147483647 ''::text

Detailed general description
appointments Table dateto int8 19 null

End date and time as a Unix time stamp; must be greater than or equal to datefrom
actionsteps Table status int2 5 0

Status (0=DRAFT, 1=COMPLETED, 2=CANCELLED, 3=BOOKED)
addresses Table account int4 10 null

Account ID (**dependency**)
files Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
participants Table name text 2147483647 null

Name
addresses Table default int2 5 0

Default for this address type
comments 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
messages Table mailserver int4 10 √ null

Mail server ID
actionsteps Table account int4 10 √ null

Account ID; is mutually exclusive to task and ticket
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)
pg_stat_statements View shared_blks_hit int8 19 √ null
records Table stickydate int8 19 √ null
transactions Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
davservers Table recipientuser int4 10 √ null

Recipient user ID (PUBLIC if recipientuser=null and recipientgroup=null)
services Table interval int2 5 1

Interval in minutes (only for TIMING)
ledgers Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
services Table schedule int4 10 0

Schedule as a minute of each day (only for TIMING)
mailinglists Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
actionsteps Table effort int4 10 0

Effort in minutes
messages Table binfile int4 10 √ null
payments Table subject text 2147483647 ''::text

Subject (e.g. bank statement or reference number)
groups Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
associations Table meta json 2147483647 √ null
tickets Table billingitems json 2147483647 √ null
contacts Table cell text 2147483647 ''::text

Cell phone number
permissions Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
services Table ID int4 10 √ null

Service ID
files Table comment int8 19 √ null

Comment ID (**dependency**); is mutually exclusive to record (either one is required)
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)
projects 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 ID int8 19 √ null

Particpants ID
applications Table name text 2147483647 null

Name
likes Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)
users Table otpsecret text 2147483647 ''::text
pg_stat_statements View shared_blks_read int8 19 √ null
records Table assigneduser int4 10 √ null

Assigned user (recipient) ID; must be distinct from creator
tasks 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 to_name text 2147483647 ''::text

First regular recipient name
weblets Table identifier varchar 200 null

Unique weblet identifier (Pattern: ^[a-zA-Z\d][\w.-]*$)
likes Table ID int8 19 √ null

Like ID
invitations Table ID int8 19 √ null

Invitation ID
davservers Table ID int4 10 √ null

DAV server ID
resources Table mimetype text 2147483647 'text/x-zymba'::text

MIME type (RFC 2045) (Pattern: ^[a-z]+/[^ \t\v\r\n]+$)
pricelists Table dateto int8 19 √ null

End date as a Unix time stamp; must be greater than or equal to datefrom
tagnames Table entity text 2147483647 null
payments Table ledger int4 10 √ null

Ledger ID
imports Table settings json 2147483647 √ null
tasks Table project int4 10 √ null

Project ID; is mutually exclusive to ticket
components Table ID int8 19 √ null

Component ID
extdatafields Table entity text 2147483647 null
tickets Table description text 2147483647 ''::text

Detailed general description
associations Table index1 int4 10 null

First entity ID
opportunities Table probability int2 5 0

Probability of success in percent; must be 100 for ACCEPTED
stocktransactions Table sellingprice float8 17 0

Selling price per unit
records Table sender text 2147483647 ''::text

Sender
weblets Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
appointments Table name text 2147483647 null

Name
items Table weight float8 17 0

Shipping weight per unit in kilogram
transactions Table item int4 10 √ null

Item ID; is required for PRODUCTION, otherwise must be null
coupons Table description text 2147483647 ''::text

Detailed general description
messages Table cc text 2147483647 ''::text

All carbon copy recipient names and e-mail addresses
accounts 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)
mailservers Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
appointments Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
recent Table date int8 19 null
notes Table description text 2147483647 ''::text

Detailed general description
links Table visits int4 10 0

Number of visits
links Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
dunning2transactions Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
payments Table transaction int4 10 √ null

Transaction ID; is mutually exclusive to account
tasks Table assigneduser int4 10 √ null

Assigned 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)
feedservers Table etag text 2147483647 ''::text

Entity tag (ETag) (RFC 7232)
payments Table assigneduser int4 10 √ null

Assigned user ID
couponcodes Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
davservers Table url text 2147483647 null

Endpoint URL
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)
campaigns 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 application int4 10 √ null

Application ID (null=STANDALONE)
filters Table view text 2147483647 null
items Table unit varchar 3 ''::character varying

Unit code (UN/CEFACT Recommendation 20)
couponcodes Table value float8 17 0

Value
resources Table identifier varchar 200 null

Unique resource identifier (Pattern: ^[a-zA-Z\d][\w.-]*$)
stocktransactions Table subtransactions _int8 19 √ null

Sub-transaction IDs
feedservers Table name text 2147483647 null

Name
tokens Table token varchar 40 null
events Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
follows Table ID int8 19 √ null

Follow ID
tasks 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
actionsteps Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
invitations Table appointment int4 10 null

Appointment ID (**dependency**)
weblets Table height int2 5 0

Height in pixels (0=100%)
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)
opportunities Table status int2 5 0

Status (0=UNEVALUATED, 1=ELIGIBLE, 2=FEEDBACKREQUIRED, 3=INNEGOTIATION, 4=OFFERED, 5=ACCEPTED, 6=REJECTED)
users Table persistentlogintoken varchar 40 ''::character varying
mailinglists Table campaign int4 10 √ null

Campaign ID
pg_stat_statements View queryid int8 19 √ null
feedservers Table description text 2147483647 ''::text

Detailed general description
invitations 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 contract int4 10 √ null

Contract ID
contacts Table postalcode text 2147483647 ''::text

Postal or ZIP code
invitations Table email text 2147483647 ''::text

E-mail address
mailservers Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
mailservers Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
tickets Table assigneduser int4 10 √ null

Assigned user ID
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)
prices Table item int4 10 null

Item ID (**dependency**)
services Table binfile int4 10 √ null
contacts Table picbinfile int4 10 √ null
pricelists2accounts Table account int4 10 null

Account ID (**dependency**)
pricelists Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
feedservers Table password text 2147483647 ''::text
extdata View index int8 19 √ null
messages Table sender text 2147483647 ''::text

Sender name and e-mail address
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)
campaigns Table datefrom int8 19 null

Start date as a Unix time stamp; must be less than or equal to dateto
suppliers Table ID int8 19 √ null

Supplier ID
mailservers Table usernamein text 2147483647 ''::text

Username (Inbound)
projects Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
pg_stat_statements View min_time float8 17 √ null
pg_stat_statements View userid oid 10 √ null
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)
imports Table name text 2147483647 null
applications Table ID int4 10 √ null

Application ID
applications Table defaultsettings json 2147483647 √ null
actionsteps Table transaction int4 10 √ null

Transaction ID
feedservers Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=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)
pg_stat_statements View temp_blks_read int8 19 √ null
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)
permissions Table ID int8 19 √ null

Permission ID
contacts Table region text 2147483647 ''::text

Region or state
projects Table name text 2147483647 null

Name
events Table meta json 2147483647 √ null
mailservers 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 actionnum text 2147483647 ''::text

Action number
contacts Table creator int4 10 √ null

Creator user ID (defaults to authenticated user 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)
accounts Table assigneduser int4 10 √ null

Assigned user ID
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)
contacts Table lastname text 2147483647 ''::text

Last name (surname or company name); is required if firstname is empty
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)
addresses Table type int2 5 0

Address type (0=BILLING_SHIPPING, 1=BILLING_BILLING, 2=PROCUREMENT_SHIPPING, 3=PROCUREMENT_BILLING)
opportunities Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
mailservers Table usernameout text 2147483647 ''::text

Username (Outbound)
contacts Table firstname text 2147483647 ''::text

First name (given name); is required if lastname is empty
extdataregular Table number numeric 131089 √ null
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)
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)
participants Table mailinglist int4 10 √ null

Mailing list ID (**dependency**); is mutually exclusive to campaign (either one is required)
transactions Table shippingrecipient text 2147483647 ''::text

Shipping recipient
pricelists2accounts Table pricelist int4 10 null

Price list ID (**dependency**)
dunning Table postalcode text 2147483647 ''::text

Postal or ZIP code
imports Table entity text 2147483647 null
appointments Table color varchar 6 ''::character varying

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

Apply to all accounts regardless of association via pricelists2accounts
mailinglists Table sender text 2147483647 ''::text

Sender name and e-mail address
campaigns Table name text 2147483647 null

Name
contacts Table description text 2147483647 ''::text

Detailed general description
links Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
users Table password text 2147483647 ''::text
contacts Table type int2 5 0

Contact type (0=COMPANY, 1=PERSON)
payments Table ownergroup int4 10 √ null

Owner group ID (null=PUBLIC)
users Table lastloginattempt int8 19 √ null
invitations Table name text 2147483647 null

Name
davservers Table synctoken text 2147483647 ''::text

Synchronization token (RFC 6578)
invitations Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
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)
extdata View number numeric 131089 √ 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)
davids Table davserver int4 10 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)
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 lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
transactions Table billingrecipient text 2147483647 ''::text

Billing recipient
messages Table sender_email text 2147483647 ''::text

Sender e-mail address
messages Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
records Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
tagnames Table ID int4 10 √ null
tickets Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
filters Table name text 2147483647 null
mailservers Table recipientgroup int4 10 √ null

Recipient group ID (PUBLIC if recipientuser=null and recipientgroup=null)
transactions Table shippingcountry varchar 2 ''::character varying

Shipping country code (ISO 3166-1 alpha-2) (Pattern: ^([A-Z]{2})?$)
categories Table ID int4 10 √ null

Category ID
messages Table bcc text 2147483647 ''::text

All blind carbon copy recipient names and e-mail addresses
couponcodes Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
items Table description text 2147483647 ''::text

Detailed general description
accounts Table excludetax int2 5 0

Exclude from taxation
imapids Table mailbox text 2147483647 null
messagereads Table message int4 10 null

Message ID (**dependency**)
contracts Table billingcycle int2 5 √ null

Billing cycle in months
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)
contacts Table company text 2147483647 ''::text

Company name (only for PERSON)
accounts Table suppliernum text 2147483647 ''::text

Supplier number (only for SUPPLIER or CUSTOMERANDSUPPLIER)
dunning Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
extdataempty Table value text 2147483647 null
participants Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
projects 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)
links Table assigneduser int4 10 √ null

Assigned user ID
suppliers Table price float8 17 √ null

Supplier price per unit
items Table manufacturer text 2147483647 ''::text

Manufacturer (brand or company name)
stocktransactions Table amount float8 17 null

Amount (quantity); must not be zero (greater than zero if transfer is not null)
transactions Table assigneduser int4 10 √ null

Assigned user ID
events Table entity text 2147483647 √ null

Canonical entity
contacts2contacts Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
projects Table projectnum text 2147483647 ''::text

Project number
dunning2transactions Table fee float8 17 0

Transaction-specific dunning fee
feedids Table feedserver int4 10 null
dunning Table region text 2147483647 ''::text

Region or state
applications Table usersettingsbinfile int4 10 √ null
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)
imapids Table message int4 10 √ null
contracts Table dateto int8 19 √ null

End date as a Unix time stamp; must be greater than or equal to datefrom
actionsteps Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
tickets Table priority int2 5 2

Priority (0=LOWEST, 1=LOW, 2=MEDIUM, 3=HIGH, 4=HIGHEST)
items Table picbinfile int4 10 √ null
resources Table public int2 5 0

Publicly accessible
davservers Table ctag text 2147483647 ''::text

Collection entity tag (CTag) (caldav-ctag-03)
opportunities 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 item int4 10 null

Item ID (**dependency**)
weblets Table svgpath text 2147483647 ''::text

SVG path for icon (square)
links Table ID int4 10 √ null

Link ID
messages Table reference int4 10 √ null

Reference message (reply-to) ID; must be distinct from ID
extdataregular Table field int4 10 null
transactions Table discount float8 17 0

Total absolute discount
items 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 dateto int8 19 √ null

End date and time as a Unix time stamp; must be greater than or equal to datefrom
contacts2contacts Table ID int8 19 √ null

Contact-to-contact ID
extdatavalues Table index int8 19 null
tickets Table ticketnum text 2147483647 ''::text

Ticket number
suppliers Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
davservers Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
groups Table ID int4 10 √ null

Group ID
contracts Table exchangerate float8 17 1

Exchange rate as a multiple of one monetary unit of the fixed system currency
messages Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
mailservers Table serverin text 2147483647 ''::text

Server (Inbound)
notes Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
filters Table data text 2147483647 null
views Table view text 2147483647 null
actionsteps Table ticket int4 10 √ null

Ticket ID; is mutually exclusive to task and account
stocktransactions Table transaction int4 10 √ null

Transaction ID
categories Table name text 2147483647 null

Name
tasks Table tasknum text 2147483647 ''::text

Task number
contacts Table assigneduser int4 10 √ null

Assigned user ID
davservers Table name text 2147483647 null

Name
comments Table ID int8 19 √ null

Comment ID
notes Table status 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)
comments Table text text 2147483647 ''::text

Comment text (Markdown for rich text representation)
categories Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
addresses Table ID int8 19 √ null

Address ID
feedservers Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
dunning Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
weblets Table mimetype text 2147483647 'text/x-zymba'::text

MIME type (RFC 2045)
notes Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
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)
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)
objects Table entity text 2147483647 null

Custom entity
accounts Table contact int4 10 √ null

Contact ID
dunning Table country varchar 2 ''::character varying

Country code (ISO 3166-1 alpha-2) (Pattern: ^([A-Z]{2})?$)
messagereads Table ID int8 19 √ null

Message-read ID
opportunities Table priority int2 5 2

Priority (0=LOWEST, 1=LOW, 2=MEDIUM, 3=HIGH, 4=HIGHEST)
applications Table identifier varchar 200 null

Unique application identifier (Pattern: ^[a-zA-Z\d][\w.-]*$)
addresses Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
opportunities Table upside float8 17 0

Upside monetary outcome
prices Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
payments Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
davids Table task int4 10 √ null
extdatafields Table name text 2147483647 null
notifications Table date int8 19 null
storages Table description text 2147483647 ''::text

Detailed general description
accounts Table type int2 5 0

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

Allow writing of group-owned data by user
files Table record int8 19 √ null

Record ID (**dependency**); is mutually exclusive to comment (either one is required)
permissions Table writable int2 5 0

Allow writing of permission-specific data by group members
transactions Table margin float8 17 0

Total absolute margin
tickets Table procurementitems json 2147483647 √ null
contacts Table country varchar 2 ''::character varying

Country code (ISO 3166-1 alpha-2) (Pattern: ^([A-Z]{2})?$)
coupons Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
tasks Table datefrom int8 19 √ null

Start date and time as a Unix time stamp
stocktransactions Table reference text 2147483647 ''::text

Reference identification
addresses Table contact int4 10 null

Contact ID
stocktransactions Table serials _text 2147483647 √ null

Serial numbers
feedservers Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
records Table entity text 2147483647 √ null

Canonical entity
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)
messages Table senderror text 2147483647 ''::text

Last error message from failure to send
campaigns Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
pricelists Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
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)
notes Table name text 2147483647 null

Name
groups Table name text 2147483647 null

Name (case-insensitively unique)
actionsteps Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
tagrels Table index int8 19 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)
accounts Table description text 2147483647 ''::text

Detailed general description
contacts2contacts Table contact2 int4 10 null

Second contact ID (**dependency**)
tags View entity text 2147483647 √ null
pg_stat_statements View query text 2147483647 √ null
prices Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
dunning2transactions Table ID int8 19 √ null

Dunning-to-transaction ID
events Table name text 2147483647 null

Name
coupons Table datefrom int8 19 √ null

Start date and time as a Unix time stamp; must be less than or equal to dateto
notifications Table record int8 19 null
objects 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 name text 2147483647 null

Name
prices Table rebate float8 17 0

Absolute rebate per unit (applied before discount)
prices Table pricelist int4 10 null

Price list ID (**dependency**)
tasks Table projectedeffort int4 10 0

Projected effort in minutes
records Table ID int8 19 √ null

Record ID
binfiles Table ID int4 10 null
dunning Table recipient text 2147483647 ''::text

Recipient
dunning Table ID int4 10 √ null

Dunning notice ID
actionsteps Table assigneduser int4 10 √ null

Assigned user ID
coupons Table ID int4 10 √ null

Coupon ID
pg_stat_statements View rows int8 19 √ null
contracts Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
associations Table ID int8 19 √ null

Association ID
couponcodes Table ID int8 19 √ null

Coupon code ID
components Table item int4 10 null

Item ID (**dependency**)
mailservers Table recipientuser int4 10 √ null

Recipient user ID (PUBLIC if recipientuser=null and recipientgroup=null)
davservers Table type int2 5 0

Collection type (0=CONTACTS, 2=APPOINTMENTS, 1=TASKS)
notes 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 ID int4 10 √ null

Action step ID
suppliers Table itemnum text 2147483647 ''::text

Supplier item number (SKU)
items Table taxrate float8 17 √ null

Tax rate in percent
dunning2transactions Table dunning int4 10 null

Dunning notice ID (**dependency**)
transactions Table shippingaddress text 2147483647 ''::text

Shipping address (street and building/suite number)
objects Table name text 2147483647 null

Name
files Table mimetype text 2147483647 'application/octet-stream'::text

MIME type (RFC 2045) (Pattern: ^[a-z]+/[^ \t\v\r\n]+$)
items Table forcestock int2 5 √ null

Force stock check on depletion (0=STORAGE, 1=LOCATION)
opportunities Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
storages Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
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 record int8 19 null

Record ID (**dependency**)
users Table description text 2147483647 ''::text
transactions Table productionfactor int4 10 √ null

Production factor; is required for PRODUCTION, otherwise must be null
applications 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 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)
services Table entity text 2147483647 ''::text

Canonical entity (only for AFTERCREATION, BEFOREMODIFICATION, AFTERMODIFICATION, AFTERCREATIONORMODIFICATION, BEFOREDELETION or AFTERDELETION)
services Table url text 2147483647 ''::text
files Table filename text 2147483647 ''::text

Filename
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)
numcounters Table counter int4 10 0
events Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
pricelists Table currency varchar 3 null

Currency code (ISO 4217) (Pattern: ^[A-Z]{3}$)
opportunities Table ownergroup int4 10 √ null

Owner group ID (null=PUBLIC)
transactions Table ownergroup int4 10 √ null

Owner group ID (null=PUBLIC)
messages Table to text 2147483647 ''::text

All regular recipient names and e-mail addresses
users Table lastlogin int8 19 √ null

Last login date and time as a Unix time stamp
extdataregular Table index int8 19 null
campaigns Table assigneduser int4 10 √ null

Assigned user ID
pricelists Table description text 2147483647 ''::text

Detailed general description
weblets Table url text 2147483647 ''::text
groups2users 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 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 name text 2147483647 √ null
extdatavalues Table number numeric 131089 √ null
appointments Table ID int4 10 √ null

Appointment 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)
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)
pg_stat_statements View shared_blks_dirtied int8 19 √ null
applications Table vendor text 2147483647 ''::text

Vendor (developer or company name)
pg_stat_statements View stddev_time float8 17 √ null
notes Table binfile int4 10 √ null
categories Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
links Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
extdatafields Table ID int4 10 √ null
messages Table sender_name text 2147483647 ''::text

Sender name
files Table size int4 10 0

Size in bytes
messages Table size int4 10 0

Size in bytes
views Table data text 2147483647 null
mailservers Table sender text 2147483647 ''::text

Sender name and e-mail address
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)
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)
tasks Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
opportunities Table duedate int8 19 √ null

Due date as a Unix time stamp
mailservers Table ID int4 10 √ null

Mail server ID
pricelists Table name text 2147483647 null

Name
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)
records Table index int4 10 √ null

Entity ID; is required if entity is not null, otherwise must be null
contracts Table ownergroup int4 10 √ null

Owner group ID (null=PUBLIC)
binfiles Table size int4 10 null
suppliers Table item int4 10 null

Item ID (**dependency**)
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)
messages Table text text 2147483647 ''::text

Plain text version of content
mailservers Table folders json 2147483647 √ null
records Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
mailservers Table passwordin text 2147483647 ''::text
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)
imports Table date int8 19 null
davids Table etag text 2147483647 ''::text
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)
stocktransactions Table flag int2 5 0

Flag (0=BOOKED, 1=RESERVED, 2=CANCELLED)
items Table barcode text 2147483647 ''::text

Barcode (e.g. UPC or EAN/GTIN)
appointments Table recurrence int2 5 √ null

Recurrence (0=DAY, 1=WORKDAY, 2=WEEK, 3=MONTH, 4=YEAR)
dunning Table ownergroup int4 10 √ null

Owner group ID (null=PUBLIC)
contacts Table website text 2147483647 ''::text

Website URL
follows Table index int8 19 null

Entity ID
links Table password text 2147483647 ''::text

Password
links Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
mailservers Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
feedservers Table notify int2 5 0

Notify about new records
tags View index int8 19 √ null
davservers Table password text 2147483647 ''::text
davservers Table description text 2147483647 ''::text

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

Last modification date and time as a Unix time stamp (auto-reset on modification)
associations Table entity1 text 2147483647 null

First canonical entity
messages Table to_count int4 10 0

Number of regular recipients
opportunities Table ID int4 10 √ null

Opportunity ID
services Table accesskey text 2147483647 ''::text
transactions Table duedate int8 19 √ null

Due date as a Unix time stamp
prices Table ID int8 19 √ null

Price ID
tickets Table name text 2147483647 null

Name
payments Table amount float8 17 null

Amount (monetary); must not be zero
mailinglists 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 ID int4 10 √ null

Price list ID
invitations Table contact int4 10 √ null

Contact ID
transactions Table billingaddress text 2147483647 ''::text

Billing address (street and building/suite number)
pg_stat_statements View total_time float8 17 √ null
messages Table ID int4 10 √ null

Message ID
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)
transactions Table shippingpostalcode text 2147483647 ''::text

Shipping postal or ZIP code
storages Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
weblets Table name text 2147483647 null

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

Last modification date and time as a Unix time stamp (auto-reset on modification)
tokens Table user int4 10 null
weblets Table width int2 5 0

Width in pixels (0=100%)
components Table component int4 10 null

Component item ID; must be distinct from item
dunning Table status int2 5 0

Status (0=DRAFT, 1=BOOKED, 2=CANCELLED, 3=CLOSED)
events Table datefrom int8 19 null

Start date and time as a Unix time stamp; must be less than or equal to dateto
notes Table contenttype text 2147483647 ''::text

Content MIME type (RFC 2045)
applications Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
actionsteps Table task int4 10 √ null

Task ID; is mutually exclusive to ticket and account
actionsteps Table description text 2147483647 ''::text

Detailed general description
services Table mimetype text 2147483647 'text/x-zymba'::text

MIME type (RFC 2045)
tasks Table name text 2147483647 null

Name
notes Table text text 2147483647 ''::text

Plain text version of content
couponcodes Table datefrom int8 19 √ null

Start date and time as a Unix time stamp; must be less than or equal to dateto
contacts Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
users 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)
stocktransactions Table location text 2147483647 ''::text

Physical location (e.g. shelf identification)
imapids Table hash varchar 32 null
payments Table status int2 5 0

Status (0=DRAFT, 1=COMPLETED, 2=CANCELLED, 3=BOOKED)
groups2users Table ID int8 19 √ null

Group-to-user ID
groups2users Table user int4 10 null

User ID
pg_stat_statements View shared_blks_written int8 19 √ null
items Table name text 2147483647 null

Product name
transactions Table billingcity text 2147483647 ''::text

Billing city or municipality
users Table nopublic int2 5 0

Deny access to public data
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)
groups2users Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
davservers Table username text 2147483647 ''::text

Username
links Table description text 2147483647 ''::text

Detailed general description
pg_stat_statements View local_blks_written int8 19 √ null
feedservers Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
messagereads Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)
groups2users Table group int4 10 null

Group ID
contracts Table procurementitems json 2147483647 √ null
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)
associations Table index2 int4 10 null

Second entity ID
imports Table user int4 10 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)
applications Table version int4 10 10000

Version number (formatted as 1.00-00)
davservers Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
stocktransactions Table purchaseprice float8 17 0

Purchase price per unit
permissions Table identifier text 2147483647 null

Permission identifier (Pattern: ^[\w.:-]+$)
contracts Table assigneduser int4 10 √ null

Assigned user ID
notes Table assigneduser int4 10 √ null

Assigned user ID
records Table text text 2147483647 ''::text

Record text (Markdown for rich text representation)
transactions Table account int4 10 √ null

Account ID; must be null for PRODUCTION
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)
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)
stocktransactions Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
dunning2transactions Table transaction int4 10 null

Transaction ID (**dependency**)
accounts Table ID int4 10 √ null

Account ID
binfiles Table hash varchar 32 null
users Table signature varchar 32 null
objects Table binfile int4 10 √ null
dunning Table level int2 5 0

Dunning level (0=REMINDER, 1=INITIAL, 2=INTERMEDIATE, 3=FINAL)
transactions Table items json 2147483647 √ null
fields Table name text 2147483647 null
tasks Table priority int2 5 2

Priority (0=LOWEST, 1=LOW, 2=MEDIUM, 3=HIGH, 4=HIGHEST)
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)
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)
contracts Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
mailservers Table autoreplybinfile int4 10 √ null
contracts Table account int4 10 √ null

Account ID
messages Table mailbox int2 5 0

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

Price list type (0=BILLING_MIN, 1=BILLING_MAX, 2=PROCUREMENT_MIN, 3=PROCUREMENT_MAX)
tasks Table duedate int8 19 √ null

Due date and time as a Unix time stamp
contracts Table autobilling json 2147483647 √ null
contracts Table currency varchar 3 null

Currency code (ISO 4217) (Pattern: ^[A-Z]{3}$)
contracts Table datefrom int8 19 null

Start date as a Unix time stamp; must be less than or equal to dateto
appointments Table daterecurrence int8 19 √ null

Recurrence end date as a Unix time stamp
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)
categories Table entity text 2147483647 null

Canonical entity
tickets Table project int4 10 √ null

Project ID
couponcodes Table flag int2 5 0

Flag (0=BOOKED, 1=RESERVED, 2=CANCELLED)
transactions Table weight float8 17 0

Total shipping weight in kilogram
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)
pg_stat_statements View max_time float8 17 √ null
items Table sellingprice float8 17 0

Default selling price per unit
pg_stat_statements View local_blks_read int8 19 √ null
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)
suppliers Table deliverytime int2 5 √ null

Expected delivery time in days
extdatavalues Table field int4 10 null
prices Table minamount float8 17 0

Minimum amount (quantity)
users Table contact int4 10 √ null

Contact ID
ledgers Table ownergroup int4 10 √ null

Owner group ID (null=PUBLIC)
tokens Table application int4 10 √ null
tasks Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
numcounters Table identifier text 2147483647 null
mailservers Table description text 2147483647 ''::text

Detailed general description
payments Table description text 2147483647 ''::text

Detailed general description
items Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
events Table color varchar 6 ''::character varying

Color code (CSS-style hexadecimal without #) (Pattern: ^([A-F\d]{3}){0,2}$)
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)
stocktransactions Table storage int4 10 √ null

Storage ID
tagrels Table name int4 10 null
services Table identifier varchar 200 null

Unique service identifier (Pattern: ^[a-zA-Z\d][\w.-]*$)
davids Table vobject text 2147483647 ''::text
tickets Table ownergroup int4 10 √ null

Owner group ID (null=PUBLIC)
items Table ownergroup int4 10 √ null

Owner group ID (null=PUBLIC)
accounts Table currency varchar 3 null

Currency code (ISO 4217) (Pattern: ^[A-Z]{3}$)
objects Table assigneduser int4 10 √ null

Assigned user ID
contracts Table billingitems json 2147483647 √ null
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)
actionsteps Table duedate int8 19 √ null

Due date and time as a Unix time stamp
opportunities Table campaign int4 10 √ null

Campaign ID
feedservers Table username text 2147483647 ''::text

Username
contacts Table title text 2147483647 ''::text

Title or salutation (only for PERSON)
mailinglists Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
payments Table ID int8 19 √ null

Payment ID
campaigns Table dateto int8 19 √ null

End date as a Unix time stamp; must be greater than or equal to datefrom
couponcodes Table coupon int4 10 null

Coupon ID (**dependency**)
transactions Table transactionnum text 2147483647 null

Transaction number
contracts Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
resources Table ID int4 10 √ null

Resource ID
categories Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
transactions Table ID int4 10 √ null

Transaction ID
extdataempty Table field int4 10 null
ledgers Table ID int4 10 √ null

Ledger ID
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)
tickets Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
appointments Table assigneduser int4 10 √ null

Assigned user ID
accounts Table lastname text 2147483647 ''::text

Last name (surname or company name); is required if firstname is empty
notifications Table flag int2 5 0
users Table loginattempts int4 10 0
transactions Table netamount float8 17 0

Total net amount
items Table model int4 10 √ null

Model item ID (only for non-MODEL)
contacts Table address text 2147483647 ''::text

Address (street and building/suite number)
accounts Table ownergroup int4 10 √ null

Owner group ID (null=PUBLIC)
notifications Table user int4 10 null
contacts Table phone text 2147483647 ''::text

Primary phone number
weblets Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
opportunities Table worstcase float8 17 0

Worst-case monetary outcome
prices Table discount float8 17 0

Relative discount in percent (applied after rebate)
comments Table sender text 2147483647 ''::text

Sender
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)
applications Table settingsbinfile int4 10 √ null
opportunities Table description text 2147483647 ''::text

Detailed general description
suppliers Table minamount float8 17 0

Minimum order amount (quantity)
addresses 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
objects Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
contacts Table email text 2147483647 ''::text

Primary e-mail address
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)
mailinglists Table description text 2147483647 ''::text

Detailed general description
pg_stat_statements View dbid oid 10 √ null
feedservers Table ID int4 10 √ null

Feed server ID
tickets Table account int4 10 √ null

Account ID
tasks Table description text 2147483647 ''::text

Detailed general description
appointments Table interval int2 5 1

Recurrence interval in minutes
notes Table ID int4 10 √ null

Note ID
storages Table name text 2147483647 null

Name
transactions Table exchangerate float8 17 1

Exchange rate as a multiple of one monetary unit of the fixed system currency
coupons Table type int2 5 0

Coupon type (0=PROMOTION, 1=INDIVIDUAL)
actionsteps Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
mailservers Table name text 2147483647 null

Name
contacts Table phone2 text 2147483647 ''::text

Secondary phone number
couponcodes Table transaction int4 10 √ null

Transaction ID
items Table ID int4 10 √ null

Item ID
stocktransactions Table chargenum text 2147483647 ''::text

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

Last modification date and time as a Unix time stamp (auto-reset on modification)
appointments Table datefrom int8 19 null

Start date and time as a Unix time stamp; must be less than or equal to dateto
groups Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
feedservers Table recipientuser int4 10 √ null

Recipient user ID (PUBLIC if recipientuser=null and recipientgroup=null)
recent Table entity text 2147483647 null
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)
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)
mailservers Table passwordout text 2147483647 ''::text
resources Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
campaigns Table ID int4 10 √ null

Campaign ID
applications Table restricted int2 5 0
fields Table user int4 10 null
services Table type int2 5 √ null

Service type (0=TIMING, 1=REMOTECALL, 2=AFTERCREATION, 3=BEFOREMODIFICATION, 4=AFTERMODIFICATION, 5=AFTERCREATIONORMODIFICATION, 6=BEFOREDELETION, 7=AFTERDELETION)
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)
actionsteps Table name text 2147483647 null

Name
stocktransactions Table transfer int8 19 √ null

Transfer stock transaction ID; must be distinct from ID and null for RESERVED
extdataempty Table number numeric 131089 √ null
records Table flag int2 5 0

Flag (0=REGULAR, 1=ASSOCONLY, 2=MINDLOGONLY, 3=MONITOR); must be REGULAR if entity is null
mailinglists Table ID int4 10 √ null

Mailing list ID
contacts Table fax text 2147483647 ''::text

Fax number
contracts Table contractnum text 2147483647 ''::text

Contract number
pg_stat_statements View blk_read_time float8 17 √ null
tickets Table duedate int8 19 √ null

Due date and time as a Unix time stamp
weblets Table langaliases json 2147483647 √ null

Language-specific aliases; use language code as object key
services Table creator int4 10 √ null

Creator user ID (defaults to authenticated user 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)
pg_stat_statements View local_blks_hit int8 19 √ null
contacts Table email2 text 2147483647 ''::text

Secondary e-mail address
projects Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
objects Table data json 2147483647 √ null
invitations Table flag int2 5 0

Flag (0=UNANSWERED, 1=CONFIRMED, 2=REJECTED)
participants Table phone text 2147483647 ''::text

Phone number
pg_stat_statements View mean_time float8 17 √ null
mailservers Table signaturebinfile int4 10 √ null
projects Table assigneduser int4 10 √ null

Assigned user ID
weblets Table binfile int4 10 √ null
storages Table ID int4 10 √ null

Storage ID
coupons Table dateto int8 19 √ null

End date and time as a Unix time stamp; must be greater than or equal to datefrom
payments 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 city text 2147483647 ''::text

City or municipality
contracts Table name text 2147483647 null

Name
davids Table appointment int4 10 √ null
davservers Table recipientgroup int4 10 √ null

Recipient group ID (PUBLIC if recipientuser=null and recipientgroup=null)
appointments Table description text 2147483647 ''::text

Detailed general description
accounts Table firstname text 2147483647 ''::text

First name (given name); is required if lastname is empty
feedids Table record int8 19 √ null
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)
transactions Table billingcountry varchar 2 ''::character varying

Billing country code (ISO 3166-1 alpha-2) (Pattern: ^([A-Z]{2})?$)
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)
extdataregular Table value text 2147483647 null
pricelists2accounts Table ID int8 19 √ null

Pricelist-to-account ID
objects Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
campaigns Table ownergroup int4 10 √ null

Owner group ID (null=PUBLIC)
services Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
participants Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
coupons Table value float8 17 0

Default value
participants Table campaign int4 10 √ null

Campaign ID (**dependency**); is mutually exclusive to mailinglist (either one is required)
groups Table description text 2147483647 ''::text
users Table settings json 2147483647 √ null
extdatavalues Table value text 2147483647 null
tokens Table identifier text 2147483647 null
tickets 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 mostlikely float8 17 0

Most likely monetary outcome
messages Table opportunity int4 10 √ null

Opportunity ID; is mutually exclusive to ticket
opportunities Table opportunitynum text 2147483647 ''::text

Opportunity number
items Table purchaseprice float8 17 0

Default purchase price per unit
resources Table name text 2147483647 null

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

Last modification date and time as a Unix time stamp (auto-reset on modification)
files Table ID int8 19 √ null

File ID
weblets Table view text 2147483647 ''::text

Canonical view
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)
storages 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
items Table type int2 5 0

Item type (0=SIMPLE, 1=SERIALS, 2=CHARGES, 3=SERIALSANDCHARGES, 4=SET, 5=CONTAINER, 6=NOSTOCK, 7=MODEL)
likes Table record int8 19 null

Record ID (**dependency**)
objects Table owneruser int4 10 √ null

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
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)
tasks Table visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
accounts Table customernum text 2147483647 ''::text

Customer number (only for PROSPECT, CUSTOMERANDSUPPLIER, CUSTOMER or EMPLOYEE)
fields Table data text 2147483647 null
dunning Table account int4 10 √ null

Account ID
ledgers Table name text 2147483647 null

Name
groups Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
accounts Table locked int2 5 0

Deny booking of billing or procurement transactions
transactions Table shippingregion text 2147483647 ''::text

Shipping region or state
extdataempty Table index int8 19 null
users Table lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
applications Table settings json 2147483647 √ null
views Table user int4 10 null
fields Table view text 2147483647 null
extdata View entity text 2147483647 √ null
weblets Table application int4 10 √ null

Application ID (null=STANDALONE)
objects Table ID int4 10 √ null

Object ID
tagnames Table name text 2147483647 null
contacts2contacts Table contact1 int4 10 null

First contact ID (**dependency**)
users Table sessionid varchar 40 ''::character varying
links Table username text 2147483647 ''::text

Username
pg_stat_statements View local_blks_dirtied int8 19 √ null
coupons Table code text 2147483647 ''::text

Promotion code (only for PROMOTION)
imapids Table uid int4 10 null
projects Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
extdata View value text 2147483647 √ null
dunning Table assigneduser int4 10 √ null

Assigned user ID
davservers Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
payments Table autoadvance int2 5 0

Auto-advance to next transaction
files Table binfile int4 10 √ null
pg_stat_statements View blk_write_time float8 17 √ null
records Table meta json 2147483647 √ null
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)
messages Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
appointments Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
records Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
objects Table description text 2147483647 ''::text

Detailed general description
events Table ID int4 10 √ null

Event ID
participants Table email text 2147483647 ''::text

E-mail address
stocktransactions Table ID int8 19 √ null

Stock transaction ID
weblets Table color varchar 6 ''::character varying

Color code (CSS-style hexadecimal without #) (Pattern: ^([A-F\d]{3}){0,2}$)
coupons Table taxrate float8 17 √ null

Tax rate in percent
users Table activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
imapids Table mailserver 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)
couponcodes Table code text 2147483647 null

Coupon code
users Table name text 2147483647 null

Username (case-insensitively unique)
recent Table user int4 10 null
mailinglists Table ownergroup int4 10 √ null

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
mailservers Table ticketing json 2147483647 √ null
objects Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
events Table index int4 10 √ null

Entity ID; is required if entity is not null, otherwise must be null
resources Table application int4 10 √ null

Application ID (null=STANDALONE)
notes Table creator int4 10 √ null

Creator user ID (defaults to authenticated user on creation)
prices Table price float8 17 √ null

Price per unit (null=item.sellingprice for billing or null=item.purchaseprice for procurement)
transactions Table tax float8 17 0

Total tax amount
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)
feedservers Table recipientgroup int4 10 √ null

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