Tables


SchemaSpy Analysis of ierfpdgl.public

Generated on Thu Dec 15 15:01 CET 2022

XML Representation
Insertion Order Deletion Order
TABLES 72
VIEWS 3
COLUMNS 832
Constraints 195

Database Properties

Database Type: PostgreSQL - 11.18 (Ubuntu 11.18-1.pgdg18.04+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 1 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 1 4 22 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
extdataempty 0 0 4 0 Table
extdatafields 0 0 3 0 Table
extdataregular 0 0 4 0 Table
extdatavalues 0 0 4 0 Table
feedids 0 2 3 0 Table
feedservers 1 5 16 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
imports 0 0 5 0 Table
invitations 0 3 9 0 Table
items 7 3 20 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 4 0 Table
numcounters 2 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 15 0 Table
permissions 0 3 7 0 Table
pg_stat_statements 0 0 23 0 View
pricelists 2 2 13 0 Table
pricelists2accounts 0 3 5 0 Table
prices 0 3 10 0 Table
projects 2 4 12 0 Table
recent 0 0 4 0 Table
records 4 4 15 0 Table
resources 0 2 11 0 Table
services 0 2 16 0 Table
stocktransactions 1 5 18 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 18 0 Table
tokens 0 1 5 0 Table
transactions 5 6 35 0 Table
users 92 2 21 0 Table
views 0 0 3 0 Table
weblets 0 2 18 0 Table