payments


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID bigserial 19 nextval('"payments_ID_seq"'::regclass)
ownergroup int4 10 null
groups.ID FK_payments_ownergroup C

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

creator int4 10 null
users.ID FK_payments_creator N

The object creator

assigneduser int4 10 null
users.ID FK_payments_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)

ledger int4 10 null
ledgers.ID FK_payments_ledger N
transaction int4 10 null
transactions.ID FK_payments_transaction N

Reference to the transaction

account int4 10 null
accounts.ID FK_payments_account N

Reference to the associated account

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

Unix timestamp in seconds

subject text 2147483647 ''::text

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

status int2 5 0

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

amount float8 17,17 null

Payment amount

description text 2147483647 ''::text

The general description field

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_payments_ID Primary key Asc ID
FK_payments_transaction Performance Asc transaction

Relationships