Tables


SchemaSpy Analysis of biigle

Generated on Fri Sep 25 07:06 UTC 2020

XML Representation
Insertion Order Deletion Order
TABLES 46
VIEWS 0
COLUMNS 256
Constraints 66
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 10.14

Schema public

standard public schema

Tables

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