Welcome - ZeyOS Schema Documentation

TABLES 72

COLUMNS 832

Constraints 195

Database Type: PostgreSQL - 11.18 (Ubuntu 11.18-1.pgdg18.04+1)

Table / View	Children	Parents	Columns	Type
accounts	10	4	17	Table
actionsteps	0	8	18	Table
addresses	0	3	8	Table
applications	3	1	15	Table
appointments	2	4	17	Table
associations	0	0	9	Table
binfiles	0	0	4	Table
campaigns	3	3	12	Table
categories	0	3	7	Table
comments	1	2	6	Table
components	0	3	8	Table
contacts	9	4	30	Table
contacts2contacts	0	3	5	Table
contracts	1	4	22	Table
couponcodes	0	3	12	Table
coupons	1	2	14	Table
davids	0	4	7	Table
davservers	1	5	17	Table
dunning	1	4	18	Table
dunning2transactions	0	3	6	Table
events	0	3	13	Table
extdata	0	0	5	View
extdataempty	0	0	4	Table
extdatafields	0	0	3	Table
extdataregular	0	0	4	Table
extdatavalues	0	0	4	Table
feedids	0	2	3	Table
feedservers	1	5	16	Table
fields	0	0	4	Table
files	0	3	9	Table
filters	0	0	4	Table
follows	0	1	5	Table
groups	34	2	8	Table
groups2users	0	3	7	Table
imapids	0	2	6	Table
imports	0	0	5	Table
invitations	0	3	9	Table
items	7	3	20	Table
ledgers	1	2	8	Table
likes	0	2	4	Table
links	0	4	14	Table
mailinglists	2	5	12	Table
mailservers	2	5	22	Table
messagereads	0	2	4	Table
messages	3	8	29	Table
notes	0	4	15	Table
notifications	0	0	4	Table
numcounters	2	0	2	Table
objects	0	4	13	Table
opportunities	1	6	20	Table
participants	0	4	10	Table
payments	0	6	15	Table
permissions	0	3	7	Table
pg_stat_statements	0	0	23	View
pricelists	2	2	13	Table
pricelists2accounts	0	3	5	Table
prices	0	3	10	Table
projects	2	4	12	Table
recent	0	0	4	Table
records	4	4	15	Table
resources	0	2	11	Table
services	0	2	16	Table
stocktransactions	1	5	18	Table
storages	1	2	8	Table
suppliers	0	3	11	Table
tagnames	0	0	3	Table
tagrels	0	0	2	Table
tags	0	0	3	View
tasks	2	6	18	Table
tickets	3	5	18	Table
tokens	0	1	5	Table
transactions	5	6	35	Table
users	92	2	21	Table
views	0	0	3	Table
weblets	0	2	18	Table