Tables


SchemaSpy Analysis of biigle

Generated on Tue Jan 31 13:24 UTC 2023

XML Representation
Insertion Order Deletion Order
TABLES 50
VIEWS 0
COLUMNS 293
Constraints 68
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 14.6

Schema public

standard public schema

Tables

Table / View Children Parents Columns Type Comments
annotation_sessions 1 1 10 Table
announcements 0 0 6 Table
volumes 6 2 9 Table
storage_requests 1 1 6 Table
annotation_session_user 0 2 2 Table
maia_job_states 1 0 2 Table
annotation_assistance_requests 0 3 12 Table
label_tree_authorized_project 0 2 2 Table
image_labels 0 3 6 Table
images 4 1 9 Table
maia_annotation_candidates 0 5 8 Table
reports 0 2 10 Table
failed_jobs 0 0 7 Table
storage_request_files 0 1 6 Table
labels 6 3 8 Table
migrations 0 0 3 Table
report_types 1 0 2 Table
newsletters 0 0 6 Table
label_tree_user 0 3 3 Table
image_annotation_labels 0 3 7 Table
project_user 0 3 4 Table
newsletter_subscribers 0 0 5 Table
video_annotations 1 2 7 Table
roles 4 0 2 Table
maia_jobs 2 3 7 Table
label_tree_project 0 2 2 Table
users 16 1 13 Table
videos 2 1 9 Table
project_invitations 0 2 9 Table
color_sort_sequences 0 1 4 Table
shapes 4 0 2 Table
label_sources 1 0 3 Table
image_annotations 3 2 6 Table
label_tree_versions 1 1 4 Table
password_resets 0 0 3 Table
video_labels 0 3 6 Table
media_types 1 0 2 Table
federated_search_instances 1 0 8 Table
label_trees 5 2 8 Table
job_batches 0 0 10 Table
project_volume 0 2 2 Table
federated_search_models 1 1 9 Table
notifications 0 0 8 Table
projects 5 1 6 Table
video_annotation_labels 0 3 6 Table
maia_training_proposals 0 3 7 Table
federated_search_model_user 0 2 2 Table
jobs 0 0 7 Table
visibilities 1 0 2 Table
api_tokens 0 1 6 Table