Tables


SchemaSpy Analysis of chapter.public

Generated on Thu Jun 08 14:47 GMT 2023

XML Representation
Insertion Order Deletion Order
TABLES 27
VIEWS 0
COLUMNS 160
Constraints 29
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 13.11 (Debian 13.11-1.pgdg110+1)

Tables

Table / View Children Parents Columns Rows Type Comments
_prisma_migrations 0 0 8 0 Table
venue_tags 0 2 4 0 Table
events 3 2 17 0 Table
event_role_permissions 0 2 4 0 Table
chapter_users 0 3 7 0 Table
event_permissions 1 0 4 0 Table
venues 2 1 12 0 Table
instance_permissions 1 0 4 0 Table
chapter_roles 2 0 4 0 Table
event_tags 0 2 4 0 Table
event_reminders 0 2 6 0 Table
attendance 1 0 4 0 Table
sponsors 1 0 7 0 Table
chapters 5 0 14 0 Table
event_sponsors 0 2 4 0 Table
chapter_tags 0 2 4 0 Table
chapter_permissions 1 0 4 0 Table
event_roles 2 0 4 0 Table
user_bans 0 2 4 0 Table
sessions 0 1 2 0 Table
event_users 2 4 9 0 Table
chapter_role_permissions 0 2 4 0 Table
users 4 1 8 0 Table
instance_role_permissions 0 2 4 0 Table
instance_roles 2 0 4 0 Table
tags 3 0 4 0 Table
google_tokens 0 0 6 0 Table