Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
pricelists Table applytoall int2 5 0

Apply to all accounts regardless of association via pricelists2accounts

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)

actionsteps Table ticket int4 10 null

Ticket ID; is mutually exclusive to task and account

users Table expdate int8 19 null

Expiry date and time as a Unix time stamp

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)

dunning 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 creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

messages Table to_name text 2147483647 ''::text

First regular recipient name

stocktransactions Table location text 2147483647 ''::text

Physical location (e.g. shelf identification)

accounts Table ID int4 10 null

Account ID

suppliers Table itemnum text 2147483647 ''::text

Supplier item number (SKU)

davservers Table name text 2147483647 null

Name

campaigns Table visibility int2 5 0

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

stocktransactions Table serials _text 2147483647 null

Serial numbers

transactions Table shippingpostalcode text 2147483647 ''::text

Shipping postal or ZIP code

categories Table owneruser int4 10 null

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

likes Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

davservers Table url text 2147483647 null

Endpoint URL

notes Table assigneduser int4 10 null

Assigned user ID

feedservers Table ownergroup int4 10 null

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

fields Table user int4 10 null
mailservers Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

objects Table owneruser int4 10 null

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

applications Table secret varchar 40 ''::character varying
notes Table contenttype text 2147483647 ''::text

Content MIME type (RFC 2045)

contacts Table postalcode text 2147483647 ''::text

Postal or ZIP code

categories Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

users Table sessionid varchar 40 ''::character varying
tickets Table ID int4 10 null

Ticket ID

services Table binfile int4 10 null
payments Table subject text 2147483647 ''::text

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

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
ledgers Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

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)

davservers Table activity int2 5 0

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

tagrels Table index int8 19 null
participants Table contact int4 10 null

Contact ID

users Table email text 2147483647 null

System e-mail address (case-insensitively unique)

extdataempty Table value text 2147483647 null
prices Table price float8 17 null

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

tasks Table ownergroup int4 10 null

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

tasks Table ticket int4 10 null

Ticket ID; is mutually exclusive to project

coupons Table code text 2147483647 ''::text

Promotion code (only for PROMOTION)

items Table barcode text 2147483647 ''::text

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

campaigns Table creator int4 10 null

Creator user ID (defaults to authenticated user 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)

payments Table account int4 10 null

Account ID; is mutually exclusive to transaction

participants Table name text 2147483647 null

Name

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 blk_read_time float8 17 null
comments Table sender text 2147483647 ''::text

Sender

transactions Table shippingaddress text 2147483647 ''::text

Shipping address (street and building/suite number)

contracts 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 storage int4 10 null

Storage ID

feedservers 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 lastmodified int8 19 date_part('epoch'::text, now())

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

applications Table identifier varchar 200 null

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

projects Table ownergroup int4 10 null

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

transactions Table ID int4 10 null

Transaction ID

binfiles Table hash varchar 32 null
users Table contact int4 10 null

Contact ID

appointments Table visibility int2 5 0

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

tasks Table datefrom int8 19 null

Start date and time as a Unix time stamp

actionsteps Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

contacts2contacts Table ID int8 19 null

Contact-to-contact ID

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)

records Table ID int8 19 null

Record ID

links 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)

mailservers Table name text 2147483647 null

Name

couponcodes Table ID int8 19 null

Coupon code ID

links Table description text 2147483647 ''::text

Detailed general description

storages Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

groups2users Table user int4 10 null

User ID

imports Table entity text 2147483647 null
transactions Table billingrecipient text 2147483647 ''::text

Billing recipient

davservers Table ownergroup int4 10 null

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

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)

feedids Table feedserver int4 10 null
weblets Table ID int4 10 null

Weblet ID

payments Table amount float8 17 null

Amount (monetary); must not be zero

accounts Table description text 2147483647 ''::text

Detailed general description

contracts Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

services Table url text 2147483647 ''::text
coupons Table description text 2147483647 ''::text

Detailed general description

actionsteps Table status int2 5 0

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

groups 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 ownergroup int4 10 null

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

fields Table data text 2147483647 null
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)

payments Table ledger int4 10 null

Ledger ID

mailservers Table ticketing json 2147483647 null
davids Table davserver int4 10 null
messages Table cc text 2147483647 ''::text

All carbon copy recipient names and e-mail addresses

users Table lastlogin int8 19 null

Last login date and time as a Unix time stamp

mailinglists Table campaign int4 10 null

Campaign ID

invitations Table contact int4 10 null

Contact ID

prices Table creator int4 10 null

Creator user ID (defaults to authenticated user 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)

couponcodes Table datefrom int8 19 null

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

pricelists2accounts Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

participants Table mailinglist int4 10 null

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

feedservers Table activity int2 5 0

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

tickets Table account int4 10 null

Account ID

services Table activity int2 5 0

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

categories Table entity text 2147483647 null

Canonical entity

contacts Table description text 2147483647 ''::text

Detailed general description

events Table dateto int8 19 null

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

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)

pricelists2accounts Table account int4 10 null

Account ID (**dependency**)

groups Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

pricelists Table name text 2147483647 null

Name

prices Table discount float8 17 0

Relative discount in percent (applied after rebate)

components Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

mailservers Table folders json 2147483647 null
pg_stat_statements View max_time float8 17 null
contracts Table account int4 10 null

Account ID

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)

pg_stat_statements View shared_blks_read int8 19 null
suppliers Table stock float8 17 null

Expected stock/inventory amount (quantity)

users Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

feedservers Table recipientuser int4 10 null

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

applications Table version int4 10 10000

Version number (formatted as 1.00-00)

links Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

items Table sellingprice float8 17 0

Default selling price per unit

mailservers Table owneruser int4 10 null

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

accounts Table excludetax int2 5 0

Exclude from taxation

notes Table binfile int4 10 null
accounts Table suppliernum text 2147483647 ''::text

Supplier number (only for SUPPLIER or CUSTOMERANDSUPPLIER)

groups2users Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

events Table meta json 2147483647 null
files Table binfile int4 10 null
stocktransactions Table chargenum text 2147483647 ''::text

Charge (lot) number

pricelists Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

stocktransactions Table ID int8 19 null

Stock transaction ID

accounts Table contact int4 10 null

Contact ID

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)

records 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 ID int8 19 null

Payment ID

appointments Table name text 2147483647 null

Name

messagereads Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

davservers Table password text 2147483647 ''::text
pg_stat_statements View shared_blks_written int8 19 null
tasks Table assigneduser int4 10 null

Assigned user ID

tickets 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 url text 2147483647 ''::text

URL

extdataempty Table index int8 19 null
links Table ID int4 10 null

Link ID

items Table ID int4 10 null

Item ID

dunning Table ID int4 10 null

Dunning notice ID

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

MIME type (RFC 2045)

pg_stat_statements View dbid oid 10 null
associations Table entity1 text 2147483647 null

First canonical entity

pg_stat_statements View local_blks_dirtied int8 19 null
users Table settings json 2147483647 null
tickets Table project int4 10 null

Project ID

contacts Table ID int4 10 null

Contact ID

follows Table entity text 2147483647 null

Canonical entity

users Table description text 2147483647 ''::text
associations Table index2 int4 10 null

Second entity ID

tasks Table projectedeffort int4 10 0

Projected effort in minutes

files Table size int4 10 0

Size in bytes

messages Table sender_email text 2147483647 ''::text

Sender e-mail address

components Table amount float8 17 0

Amount (quantity)

campaigns Table name text 2147483647 null

Name

transactions Table weight float8 17 0

Total shipping weight in kilogram

transactions Table items json 2147483647 null
davservers Table description text 2147483647 ''::text

Detailed general description

contacts Table cell text 2147483647 ''::text

Cell phone number

actionsteps 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 creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

messages Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

campaigns Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

appointments Table datefrom int8 19 null

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

objects Table description text 2147483647 ''::text

Detailed general description

items Table weight float8 17 0

Shipping weight per unit in kilogram

mailinglists Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

events Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

stocktransactions Table transaction int4 10 null

Transaction ID

tickets Table assigneduser int4 10 null

Assigned user ID

pricelists 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

projects Table assigneduser int4 10 null

Assigned user ID

coupons Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

feedservers Table url text 2147483647 null

Feed URL

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)

components 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 application int4 10 null
views Table view text 2147483647 null
services Table accesskey text 2147483647 ''::text
coupons Table value float8 17 0

Default value

services Table identifier varchar 200 null

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

actionsteps Table task int4 10 null

Task ID; is mutually exclusive to ticket and account

fields Table name text 2147483647 null
dunning2transactions Table transaction int4 10 null

Transaction ID (**dependency**)

feedservers Table owneruser int4 10 null

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

groups Table ID int4 10 null

Group ID

tickets Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

opportunities Table duedate int8 19 null

Due date as a Unix time stamp

addresses Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

couponcodes Table code text 2147483647 null

Coupon code

dunning Table level int2 5 0

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

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)

payments Table status int2 5 0

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

users Table resetlogintoken varchar 40 ''::character varying
opportunities Table campaign int4 10 null

Campaign ID

davservers Table recipientgroup int4 10 null

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

groups Table description text 2147483647 ''::text
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 creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

dunning Table postalcode text 2147483647 ''::text

Postal or ZIP code

participants Table email text 2147483647 ''::text

E-mail address

messages Table owneruser int4 10 null

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

pricelists Table activity int2 5 0

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

transactions Table assigneduser int4 10 null

Assigned user ID

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)

stocktransactions Table item int4 10 null

Item ID (**dependency**)

weblets Table binfile int4 10 null
items Table picbinfile int4 10 null
suppliers Table account int4 10 null

Account ID (**dependency**)

resources Table activity int2 5 0

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

links Table password text 2147483647 ''::text

Password

records Table index int4 10 null

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

records Table sender text 2147483647 ''::text

Sender

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)

contracts Table datefrom int8 19 null

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

tagnames Table ID int4 10 null
mailservers Table usernameout text 2147483647 ''::text

Username (Outbound)

storages Table visibility int2 5 0

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

items Table model int4 10 null

Model item ID (only for non-MODEL)

applications Table usersettingsbinfile int4 10 null
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)

invitations Table name text 2147483647 null

Name

appointments Table ID int4 10 null

Appointment ID

suppliers Table deliverytime int2 5 null

Expected delivery time in days

couponcodes Table transaction int4 10 null

Transaction ID

items Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

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)

pg_stat_statements View temp_blks_written int8 19 null
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)

pricelists Table ID int4 10 null

Price list ID

dunning Table region text 2147483647 ''::text

Region or state

resources Table name text 2147483647 null

Name

records Table meta json 2147483647 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)

contacts Table address text 2147483647 ''::text

Address (street and building/suite number)

contacts2contacts 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)

actionsteps Table assigneduser int4 10 null

Assigned user ID

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)

appointments Table location text 2147483647 ''::text

Location

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)

contacts Table type int2 5 0

Contact type (0=COMPANY, 1=PERSON)

projects Table visibility int2 5 0

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

applications Table vendor text 2147483647 ''::text

Vendor (developer or company name)

items Table itemnum text 2147483647 ''::text

Item number (SKU)

extdatavalues Table number numeric 131089 null
dunning Table status int2 5 0

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

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)

messages Table mailserver int4 10 null

Mail server ID

transactions Table shippingregion text 2147483647 ''::text

Shipping region or state

prices Table pricelist int4 10 null

Price list ID (**dependency**)

projects Table projectnum text 2147483647 ''::text

Project number

objects Table entity text 2147483647 null

Custom entity

events Table color varchar 6 ''::character varying

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

payments Table autoadvance int2 5 0

Auto-advance to next transaction

mailservers Table sender text 2147483647 ''::text

Sender name and e-mail address

categories Table name text 2147483647 null

Name

contracts Table description text 2147483647 ''::text

Detailed general description

mailinglists Table owneruser int4 10 null

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

mailservers Table passwordin text 2147483647 ''::text
coupons Table type int2 5 0

Coupon type (0=PROMOTION, 1=INDIVIDUAL)

pricelists Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

groups Table leader int4 10 null

Leader user ID

items Table name text 2147483647 null

Product name

tasks Table tasknum text 2147483647 ''::text

Task number

items Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

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)

extdataempty Table number numeric 131089 null
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)

dunning2transactions Table dunning int4 10 null

Dunning notice ID (**dependency**)

users 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 lastmodified int8 19 date_part('epoch'::text, now())

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

notes 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 billingregion text 2147483647 ''::text

Billing region or state

messages Table sender_name text 2147483647 ''::text

Sender name

notes Table owneruser int4 10 null

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

tasks Table owneruser int4 10 null

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

tasks Table ID int4 10 null

Task ID

links Table visits int4 10 0

Number of visits

groups Table name text 2147483647 null

Name (case-insensitively unique)

davservers Table recipientuser int4 10 null

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

items Table unit varchar 3 ''::character varying

Unit code (UN/CEFACT Recommendation 20)

comments Table ID int8 19 null

Comment ID

transactions Table billingaddress text 2147483647 ''::text

Billing address (street and building/suite number)

coupons 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

dunning2transactions Table fee float8 17 0

Transaction-specific dunning fee

imapids Table mailserver int4 10 null
actionsteps Table name text 2147483647 null

Name

contracts Table billingitems json 2147483647 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)

messages Table contenttype text 2147483647 ''::text

Content MIME type (RFC 2045)

weblets Table svgpath text 2147483647 ''::text

SVG path for icon (square)

dunning2transactions Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

extdataregular Table value text 2147483647 null
payments Table lastmodified int8 19 date_part('epoch'::text, now())

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

storages Table description text 2147483647 ''::text

Detailed general description

actionsteps Table account int4 10 null

Account ID; is mutually exclusive to task and ticket

mailinglists Table assigneduser int4 10 null

Assigned user ID

contracts Table procurementitems json 2147483647 null
opportunities Table opportunitynum text 2147483647 ''::text

Opportunity number

invitations Table appointment int4 10 null

Appointment ID (**dependency**)

contracts Table autobilling json 2147483647 null
extdata View entity text 2147483647 null
contracts Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

dunning Table recipient text 2147483647 ''::text

Recipient

couponcodes Table flag int2 5 0

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

extdataempty Table field int4 10 null
associations Table relation text 2147483647 ''::text
extdata View value text 2147483647 null
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)

associations Table meta json 2147483647 null
couponcodes Table dateto int8 19 null

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

appointments Table ownergroup int4 10 null

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

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)

components Table price float8 17 null

Imputed price per unit

items Table purchaseprice float8 17 0

Default purchase price per unit

accounts Table customernum text 2147483647 ''::text

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

participants 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 item int4 10 null

Item ID (**dependency**)

davservers Table synctoken text 2147483647 ''::text

Synchronization token (RFC 6578)

mailinglists Table ID int4 10 null

Mailing list ID

pg_stat_statements View rows int8 19 null
extdatavalues Table field int4 10 null
actionsteps Table effort int4 10 0

Effort in minutes

ledgers 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 dateto int8 19 null

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

contracts Table ID int4 10 null

Contract ID

follows Table index int8 19 null

Entity ID

contacts Table title text 2147483647 ''::text

Title or salutation (only for PERSON)

tasks 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)

groups2users Table ID int8 19 null

Group-to-user ID

transactions Table exchangerate float8 17 1

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

notes Table ownergroup int4 10 null

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

mailservers Table serverout text 2147483647 ''::text

Server (Outbound)

objects Table ownergroup int4 10 null

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

views Table data text 2147483647 null
messages Table ticket int4 10 null

Ticket ID; is mutually exclusive to opportunity

stocktransactions Table transfer int8 19 null

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

contracts Table name text 2147483647 null

Name

comments Table text text 2147483647 ''::text

Comment text (Markdown for rich text representation)

contracts Table assigneduser int4 10 null

Assigned user ID

events Table name text 2147483647 null

Name

components Table ID int8 19 null

Component ID

opportunities Table status int2 5 0

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

services 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 text text 2147483647 ''::text

Plain text version of content

contacts Table ownergroup int4 10 null

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

applications Table ID int4 10 null

Application ID

groups Table activity int2 5 0

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

events 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 activity int2 5 0

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

objects Table visibility int2 5 0

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

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)

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)

recent Table entity text 2147483647 null
davids Table contact int4 10 null
users Table persistentlogintoken varchar 40 ''::character varying
messages Table ID int4 10 null

Message ID

tasks Table priority int2 5 2

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

numcounters Table identifier text 2147483647 null
applications Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

couponcodes Table value float8 17 0

Value

projects Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

permissions Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

coupons Table taxrate float8 17 null

Tax rate in percent

feedservers Table name text 2147483647 null

Name

recent Table date int8 19 null
tasks Table description text 2147483647 ''::text

Detailed general description

addresses Table type int2 5 0

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

permissions Table writable int2 5 0

Allow writing of permission-specific data by group members

appointments Table recurrence int2 5 null

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

contracts Table exchangerate float8 17 1

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

prices Table minamount float8 17 0

Minimum amount (quantity)

transactions Table productionfactor int4 10 null

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

dunning Table country varchar 2 ''::character varying

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

davservers Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

appointments Table daterecurrence int8 19 null

Recurrence end date as a Unix time stamp

contacts Table region text 2147483647 ''::text

Region or state

contacts2contacts Table contact1 int4 10 null

First contact ID (**dependency**)

applications Table settings json 2147483647 null
links Table owneruser int4 10 null

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

tags View entity text 2147483647 null
transactions Table billingcountry varchar 2 ''::character varying

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

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)

mailservers Table serverin text 2147483647 ''::text

Server (Inbound)

contacts Table visibility int2 5 0

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

prices 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 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 name text 2147483647 null

Name

imports Table name text 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)

associations Table index1 int4 10 null

First entity ID

davservers 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 description text 2147483647 ''::text

Detailed general description

couponcodes Table coupon int4 10 null

Coupon ID (**dependency**)

tokens Table expdate int8 19 null
pg_stat_statements View queryid int8 19 null
projects 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 ID int4 10 null

Event ID

extdatafields Table name text 2147483647 null
pricelists Table datefrom int8 19 null

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

users Table signature varchar 32 null
opportunities Table lastmodified int8 19 date_part('epoch'::text, now())

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

storages Table name text 2147483647 null

Name

applications Table restricted int2 5 0
comments Table record int8 19 null

Record ID (**dependency**)

resources Table public int2 5 0

Publicly accessible

resources Table ID int4 10 null

Resource ID

campaigns Table ID int4 10 null

Campaign ID

stocktransactions Table reference text 2147483647 ''::text

Reference identification

dunning2transactions Table ID int8 19 null

Dunning-to-transaction ID

appointments Table assigneduser int4 10 null

Assigned user ID

davservers Table ID int4 10 null

DAV server ID

messages Table senddate int8 19 null

Scheduled send date and time as a Unix time stamp

couponcodes Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

binfiles Table ID int4 10 null
coupons Table ID int4 10 null

Coupon ID

prices Table item int4 10 null

Item ID (**dependency**)

feedids Table record int8 19 null
items Table type int2 5 0

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

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

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

addresses Table ID int8 19 null

Address ID

accounts Table lastname text 2147483647 ''::text

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

pg_stat_statements View temp_blks_read int8 19 null
dunning Table dunningnum text 2147483647 null

Dunning number

transactions Table shippingcity text 2147483647 ''::text

Shipping city or municipality

opportunities Table name text 2147483647 null

Name

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

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

events Table index int4 10 null

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

participants Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

tasks Table visibility int2 5 0

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

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)

likes Table record int8 19 null

Record ID (**dependency**)

contacts Table email text 2147483647 ''::text

Primary e-mail address

tasks Table project int4 10 null

Project ID; is mutually exclusive to ticket

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

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

binfiles Table date int8 19 date_part('epoch'::text, now())
davids Table etag text 2147483647 ''::text
weblets Table url text 2147483647 ''::text
accounts Table firstname text 2147483647 ''::text

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

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)

addresses Table default int2 5 0

Default for this address type

feedservers Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

transactions Table currency varchar 3 null

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

payments Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

actionsteps Table owneruser int4 10 null

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

messages Table to_email text 2147483647 ''::text

First regular recipient e-mail address

users Table lastloginattempt int8 19 null
extdatavalues Table index int8 19 null
contacts Table assigneduser int4 10 null

Assigned user ID

projects Table description text 2147483647 ''::text

Detailed general description

davservers Table username text 2147483647 ''::text

Username

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

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

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)

tags View name text 2147483647 null
messages Table opportunity int4 10 null

Opportunity ID; is mutually exclusive to ticket

associations Table ID int8 19 null

Association ID

opportunities Table upside float8 17 0

Upside monetary outcome

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)

pg_stat_statements View shared_blks_hit int8 19 null
weblets Table view text 2147483647 ''::text

Canonical view

records Table stickydate int8 19 null
objects Table binfile int4 10 null
contacts Table owneruser int4 10 null

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

mailinglists Table ownergroup int4 10 null

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

feedservers Table ID int4 10 null

Feed server ID

messages Table senderror text 2147483647 ''::text

Last error message from failure to send

messages Table size int4 10 0

Size in bytes

notes Table size int4 10 0

Size in bytes

imports Table date int8 19 null
messages Table sender text 2147483647 ''::text

Sender name and e-mail address

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 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 picbinfile int4 10 null
tasks Table duedate int8 19 null

Due date and time as a Unix time stamp

messagereads Table ID int8 19 null

Message-read ID

projects Table name text 2147483647 null

Name

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)

tags View index int8 19 null
coupons Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

tokens Table token varchar 40 null
imapids Table mailbox text 2147483647 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)

notes Table text text 2147483647 ''::text

Plain text version of content

items Table forcestock int2 5 null

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

storages Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

mailservers Table passwordout text 2147483647 ''::text
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)

notifications Table date int8 19 null
feedservers Table etag text 2147483647 ''::text

Entity tag (ETag) (RFC 7232)

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 height int2 5 0

Height in pixels (0=100%)

messages Table bcc text 2147483647 ''::text

All blind carbon copy recipient names and e-mail addresses

messages Table reference int4 10 null

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

events Table ownergroup int4 10 null

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

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

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

recent Table index int4 10 null
users Table password text 2147483647 ''::text
mailinglists Table visibility int2 5 0

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

messages Table ownergroup int4 10 null

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

opportunities Table probability int2 5 0

Probability of success in percent; must be 100 for ACCEPTED

transactions Table item int4 10 null

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

feedservers Table password text 2147483647 ''::text
feedservers Table description text 2147483647 ''::text

Detailed general description

resources 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 entity2 text 2147483647 null

Second canonical entity

accounts Table type int2 5 0

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

participants Table ID int8 19 null

Particpants ID

actionsteps Table actionnum text 2147483647 ''::text

Action number

events Table entity text 2147483647 null

Canonical entity

projects Table ID int4 10 null

Project ID

users Table name text 2147483647 null

Username (case-insensitively unique)

stocktransactions Table amount float8 17 null

Amount (quantity); must not be zero (greater than zero if transfer is not 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)

pricelists2accounts Table ID int8 19 null

Pricelist-to-account ID

opportunities Table contact int4 10 null

Contact ID

transactions Table billingcity text 2147483647 ''::text

Billing city or municipality

actionsteps Table transaction int4 10 null

Transaction ID

notes Table ID int4 10 null

Note ID

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)

transactions Table shippingrecipient text 2147483647 ''::text

Shipping recipient

suppliers Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

pricelists2accounts Table pricelist int4 10 null

Price list ID (**dependency**)

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)

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

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

views Table user int4 10 null
opportunities Table worstcase float8 17 0

Worst-case monetary outcome

addresses Table contact int4 10 null

Contact ID

notes Table status int2 5 0
appointments Table dateto int8 19 null

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

contracts Table contractnum text 2147483647 ''::text

Contract number

coupons Table activity int2 5 0

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

davids Table task int4 10 null
appointments Table description text 2147483647 ''::text

Detailed general description

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

MIME type (RFC 2045)

tickets Table name text 2147483647 null

Name

records Table text text 2147483647 ''::text

Record text (Markdown for rich text representation)

coupons Table datefrom int8 19 null

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

davservers Table owneruser int4 10 null

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

weblets Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

contracts Table visibility int2 5 0

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

items Table manufacturer text 2147483647 ''::text

Manufacturer (brand or company name)

davids Table href text 2147483647 null
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)

invitations Table ID int8 19 null

Invitation ID

imports Table user int4 10 null
mailservers Table signaturebinfile int4 10 null
ledgers Table name text 2147483647 null

Name

transactions Table billingpostalcode text 2147483647 ''::text

Billing postal or ZIP code

feedservers Table notify int2 5 0

Notify about new records

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)

invitations Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

feedservers Table username text 2147483647 ''::text

Username

mailinglists Table description text 2147483647 ''::text

Detailed general description

messages Table mailinglist int4 10 null

Mailing list ID

files Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

accounts Table currency varchar 3 null

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

permissions Table group int4 10 null

Group ID

tickets Table procurementitems json 2147483647 null
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)

components Table item int4 10 null

Item ID (**dependency**)

notifications Table user int4 10 null
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)

opportunities Table priority int2 5 2

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

dunning Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

prices Table rebate float8 17 0

Absolute rebate per unit (applied before discount)

resources Table identifier varchar 200 null

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

dunning Table assigneduser int4 10 null

Assigned user ID

objects Table assigneduser int4 10 null

Assigned user ID

tickets Table ticketnum text 2147483647 ''::text

Ticket number

resources Table application int4 10 null

Application ID (null=STANDALONE)

transactions Table tax float8 17 0

Total tax amount

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)

storages 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 transactionnum text 2147483647 null

Transaction number

actionsteps Table ID int4 10 null

Action step ID

imapids Table hash varchar 32 null
binfiles Table size int4 10 null
resources Table binfile int4 10 null
accounts Table locked int2 5 0

Deny booking of billing or procurement transactions

weblets Table langaliases json 2147483647 null

Language-specific aliases; use language code as object key

filters Table name text 2147483647 null
tickets Table priority int2 5 2

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

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)

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)

couponcodes 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 billingcycle int2 5 null

Billing cycle in months

dunning Table account int4 10 null

Account ID

transactions Table margin float8 17 0

Total absolute margin

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)

tickets Table duedate int8 19 null

Due date and time as a Unix time stamp

mailservers Table autoreplybinfile int4 10 null
pricelists Table currency varchar 3 null

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

events Table datefrom int8 19 null

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

campaigns Table dateto int8 19 null

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

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)

extdatafields Table entity text 2147483647 null
pg_stat_statements View query text 2147483647 null
invitations Table flag int2 5 0

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

weblets Table width int2 5 0

Width in pixels (0=100%)

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)

pg_stat_statements View mean_time float8 17 null
stocktransactions Table sellingprice float8 17 0

Selling price per unit

pg_stat_statements View local_blks_written int8 19 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)

actionsteps Table duedate int8 19 null

Due date and time as a Unix time stamp

groups2users Table group int4 10 null

Group ID

suppliers Table minamount float8 17 0

Minimum order amount (quantity)

transactions Table contract int4 10 null

Contract ID

links Table ownergroup int4 10 null

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

weblets Table application int4 10 null

Application ID (null=STANDALONE)

tickets Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

permissions Table identifier text 2147483647 null

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

notes Table description text 2147483647 ''::text

Detailed general description

pricelists Table description text 2147483647 ''::text

Detailed general description

ledgers Table visibility int2 5 0

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

weblets Table color varchar 6 ''::character varying

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

accounts 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 subtransactions _int8 19 null

Sub-transaction IDs

tasks Table name text 2147483647 null

Name

tokens Table identifier text 2147483647 null
contacts Table website text 2147483647 ''::text

Website URL

transactions Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

ledgers Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

contracts Table currency varchar 3 null

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

opportunities Table assigneduser int4 10 null

Assigned user ID

tickets Table billingitems json 2147483647 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)

dunning Table duedate int8 19 null

Due date as a Unix time stamp

participants Table campaign int4 10 null

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

links Table username text 2147483647 ''::text

Username

messages Table to text 2147483647 ''::text

All regular recipient names and e-mail addresses

notes Table visibility int2 5 0

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

permissions Table ID int8 19 null

Permission ID

contracts Table dateto int8 19 null

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

follows Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

imapids Table uid int4 10 null
items Table visibility int2 5 0

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

services Table ID int4 10 null

Service ID

comments Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

users Table ID int4 10 null

User ID

extdataregular Table field int4 10 null
likes Table ID int8 19 null

Like ID

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)

transactions Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

campaigns Table assigneduser int4 10 null

Assigned user ID

contacts Table lastname text 2147483647 ''::text

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

records Table flag int2 5 0

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

messages Table mailbox int2 5 0

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

users Table nopublic int2 5 0

Deny access to public data

extdata View name text 2147483647 null
dunning Table address text 2147483647 ''::text

Address (street and building/suite number)

actionsteps Table ownergroup int4 10 null

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

recent Table user int4 10 null
participants Table phone text 2147483647 ''::text

Phone number

objects Table data json 2147483647 null
groups2users Table writable int2 5 0

Allow writing of group-owned data by user

transactions Table discount float8 17 0

Total absolute discount

mailinglists Table sender text 2147483647 ''::text

Sender name and e-mail address

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)

pg_stat_statements View shared_blks_dirtied int8 19 null
payments Table description text 2147483647 ''::text

Detailed general description

opportunities Table mostlikely float8 17 0

Most likely monetary outcome

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 assigneduser int4 10 null

Assigned user ID

opportunities Table visibility int2 5 0

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

invitations Table email text 2147483647 ''::text

E-mail address

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)

mailservers Table description text 2147483647 ''::text

Detailed general description

applications Table defaultsettings json 2147483647 null
files Table ID int8 19 null

File ID

transactions Table account int4 10 null

Account ID; must be null for PRODUCTION

tickets Table description text 2147483647 ''::text

Detailed general description

services Table interval int2 5 1

Interval in minutes (only for TIMING)

objects Table ID int4 10 null

Object ID

tagnames Table name text 2147483647 null
appointments Table interval int2 5 1

Recurrence interval in minutes

davservers Table type int2 5 0

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

appointments Table owneruser int4 10 null

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

notes Table name text 2147483647 null

Name

contacts Table position text 2147483647 ''::text

Position or job title (only for PERSON)

payments Table transaction int4 10 null

Transaction ID; is mutually exclusive to account

ledgers Table ID int4 10 null

Ledger ID

contacts Table city text 2147483647 ''::text

City or municipality

links 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 datefrom int8 19 null

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

groups2users 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 recipientuser int4 10 null

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

tagnames Table entity text 2147483647 null
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)

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)

contacts Table phone text 2147483647 ''::text

Primary phone number

services Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

categories Table ID int4 10 null

Category ID

services Table schedule int4 10 0

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

filters Table user int4 10 null
pg_stat_statements View userid oid 10 null
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)

applications Table name text 2147483647 null

Name

services Table type int2 5 null

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

extdataregular Table number numeric 131089 null
stocktransactions Table flag int2 5 0

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

mailservers Table ID int4 10 null

Mail server ID

files Table filename text 2147483647 ''::text

Filename

davservers Table ctag text 2147483647 ''::text

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

pg_stat_statements View blk_write_time float8 17 null
transactions Table duedate int8 19 null

Due date as a Unix time stamp

contracts Table lastbilling int8 19 null

Last billing date and time as a Unix time stamp

stocktransactions Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

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)

pg_stat_statements View local_blks_read int8 19 null
services Table entity text 2147483647 ''::text

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

records Table owneruser int4 10 null

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

contracts Table datecancel int8 19 null

Cancellation date as a Unix time stamp

notifications Table flag int2 5 0
contacts Table phone2 text 2147483647 ''::text

Secondary phone number

imapids Table message int4 10 null
pg_stat_statements View stddev_time float8 17 null
records Table assigneduser int4 10 null

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

contacts Table birthdate int8 19 null

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

suppliers Table ID int8 19 null

Supplier ID

pricelists Table dateto int8 19 null

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

permissions 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 city text 2147483647 ''::text

City or municipality

coupons Table name text 2147483647 null

Name

accounts Table assigneduser int4 10 null

Assigned user ID

feedservers Table recipientgroup int4 10 null

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

campaigns Table description text 2147483647 ''::text

Detailed general description

contacts Table firstname text 2147483647 ''::text

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

files Table record int8 19 null

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

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)

appointments Table color varchar 6 ''::character varying

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

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)

extdatavalues Table value text 2147483647 null
prices Table ID int8 19 null

Price ID

opportunities Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

categories Table ownergroup int4 10 null

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

users Table activity int2 5 0

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

payments Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

accounts Table visibility int2 5 0

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

files Table comment int8 19 null

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

items Table description text 2147483647 ''::text

Detailed general description

applications Table settingsbinfile int4 10 null
fields Table view text 2147483647 null
weblets Table identifier varchar 200 null

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

transactions 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 netamount float8 17 0

Total net amount

accounts Table ownergroup int4 10 null

Owner group ID (null=PUBLIC)

users Table otpsecret text 2147483647 ''::text
stocktransactions Table purchaseprice float8 17 0

Purchase price per unit

services Table name text 2147483647 null

Name

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

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

follows Table ID int8 19 null

Follow ID

davids Table vobject text 2147483647 ''::text
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)

suppliers 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 name text 2147483647 null

Name

pricelists Table type int2 5 0

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

notifications Table record int8 19 null
projects Table owneruser int4 10 null

Owner user ID (PUBLIC if owneruser=null and ownergroup=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)

tickets Table visibility int2 5 0

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

contacts Table department text 2147483647 ''::text

Department (only for PERSON)

filters Table data text 2147483647 null
opportunities Table account int4 10 null

Account ID

links Table name text 2147483647 null

Name

mailservers Table activity int2 5 0

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

users Table loginattempts int4 10 0
messages Table subject text 2147483647 ''::text

Subject

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

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

imports Table settings json 2147483647 null
feedids Table uuid text 2147483647 null
filters Table view text 2147483647 null
records Table entity text 2147483647 null

Canonical entity

davids Table appointment int4 10 null
opportunities Table ID int4 10 null

Opportunity ID

tagrels Table name int4 10 null
contacts2contacts Table contact2 int4 10 null

Second contact ID (**dependency**)

transactions Table shippingcountry varchar 2 ''::character varying

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

mailservers Table usernamein text 2147483647 ''::text

Username (Inbound)

pg_stat_statements View local_blks_hit int8 19 null
contacts Table company text 2147483647 ''::text

Company name (only for PERSON)

imapids Table uidvalidity int4 10 null
records Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

addresses Table account int4 10 null

Account ID (**dependency**)

links Table assigneduser int4 10 null

Assigned user ID

dunning Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

numcounters Table counter int4 10 0
messages Table binfile int4 10 null
pg_stat_statements View calls int8 19 null
pg_stat_statements View min_time float8 17 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)

notes Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

associations Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

resources Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

opportunities Table description text 2147483647 ''::text

Detailed general description

extdatafields Table ID int4 10 null
contacts Table email2 text 2147483647 ''::text

Secondary e-mail address

storages Table ID int4 10 null

Storage ID

contacts Table country varchar 2 ''::character varying

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

items Table taxrate float8 17 null

Tax rate in percent

weblets Table activity int2 5 0

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

messagereads Table message int4 10 null

Message ID (**dependency**)

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)

components Table component int4 10 null

Component item ID; must be distinct from item

weblets Table name text 2147483647 null

Name

tokens Table user int4 10 null
mailservers Table ownergroup int4 10 null

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

pg_stat_statements View total_time float8 17 null
opportunities Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

extdata View index int8 19 null
services Table application int4 10 null

Application ID (null=STANDALONE)

objects Table creator int4 10 null

Creator user ID (defaults to authenticated user on creation)

suppliers Table price float8 17 null

Supplier price per unit

messages Table to_count int4 10 0

Number of regular recipients

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)

mailservers Table recipientgroup int4 10 null

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