Tables


SchemaSpy Analysis of zeyos.public

Generated on Thu Apr 05 13:51 CEST 2018

XML Representation
Insertion Order Deletion Order
TABLES 68
VIEWS 2
COLUMNS 775
Constraints 194

Database Properties

Database Type: PostgreSQL - 10.1

Tables

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