contracts


Details

Status codes

Status Activity ID Color
Draft DRAFT 0 green
Awaiting approval DRAFT 1 orange
Approved OPEN 2 green
Dismissed CANCELLED 3 red
Active OPEN 4 green
Inactive OPEN 5 orange
Expired CLOSED 6 black
Cancelled CANCELLED 7 red
Closed CLOSED 8 black

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"contracts_ID_seq"'::regclass)
ownergroup int4 10 null
groups.ID FK_contracts_ownergroup C

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

creator int4 10 null
users.ID FK_contracts_creator N

The object creator

assigneduser int4 10 null
users.ID FK_contracts_assigneduser N

The assigned user

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

Last modification date/time (Unix timestamp in seconds)

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

Last modification date/time (Unix timestamp in seconds)

account int4 10 null
accounts.ID FK_contracts_account N

Reference to the associated account

visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

name text 2147483647 null
contractnum text 2147483647 ''::text
datefrom int8 19 null

Unix timestamp in seconds

dateto int8 19 null

Unix timestamp in seconds

datecancel int8 19 null
status int2 5 0
description text 2147483647 ''::text

The general description field

items json 2147483647 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_contracts_ID Primary key Asc ID

Relationships