Tables


SchemaSpy Analysis of biigle

Generated on Thu Aug 06 07:52 UTC 2026

XML Representation
Insertion Order Deletion Order
TABLES 66
VIEWS 0
COLUMNS 366
Constraints 86
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 14.4

Schema public

standard public schema

Tables

Table / View Children Parents Columns Type Comments
helmholtz_ids 0 1 4 Table
events 0 0 3 Table
announcements 0 0 6 Table
annotation_sessions 1 1 10 Table
volumes 7 2 11 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
kpis_citations 0 0 2 Table
kpis_unique_users 0 0 2 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 7 Table
labels 8 3 8 Table
maia_training_proposal_feature_vectors 0 1 3 Table
lslogin_ids 0 1 4 Table
user_disks 0 1 8 Table
migrations 0 0 3 Table
kpis_storage_usage 0 0 2 Table
report_types 1 0 2 Table
pending_volumes 0 4 16 Table
maia_annotation_candidate_feature_vectors 0 1 3 Table
newsletters 0 0 6 Table
label_tree_user 0 3 3 Table
image_annotation_labels 1 3 7 Table
kpis_visits 0 0 2 Table
kpis_actions 0 0 2 Table
project_user 0 3 4 Table
newsletter_subscribers 0 0 5 Table
video_annotations 2 2 7 Table
roles 4 0 2 Table
label_tree_project 0 2 2 Table
maia_jobs 4 3 7 Table
users 21 1 13 Table
videos 2 1 9 Table
project_invitations 0 2 10 Table
color_sort_sequences 0 1 4 Table
shapes 4 0 2 Table
label_sources 1 0 3 Table
image_annotations 4 2 6 Table
kpis_users 0 0 2 Table
label_tree_versions 1 1 4 Table
password_resets 0 0 3 Table
video_labels 0 3 6 Table
media_types 2 0 2 Table
federated_search_instances 1 0 8 Table
video_annotation_label_feature_vectors 0 4 6 Table
image_annotation_label_feature_vectors 0 4 6 Table
label_trees 7 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
nfdi_login_ids 0 1 4 Table
projects 6 1 6 Table
video_annotation_labels 1 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