account

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
account_credit.account_oid fkacct_cred_acctC
account_debit.account_oid fkacct_deb_acctC
allocation.account_oid fkcaccount_oidR
invoice.account_oid fkcaccount_oidR
department_oid int8 19 √ null
department.obj_oid fkcdepartment_oidC
person_oid int8 19 √ null
person.obj_oid fkperson_oidC
code varchar 2147483647 null
note varchar 2147483647 √ null
taxable bool 1 √ null
deleted bool 1 √ false
origin varchar 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
account_pkey Primary key Asc obj_oid
account_person_oid_key Must be unique Asc person_oid
account_unique_code Must be unique Asc code

Relationships

Close relationships within degrees of separation