CORGI ERD

This section describes the data model used by CORGI. For more information about how to read this diagram, see Crow’s foot notation.

erDiagram ApprovedBook { int book_id datetime created_at datetime updated_at int consumer_id int code_version_id } Book { int id str slug str uuid str style int edition int commit_id } BookJob { int job_id int book_id opt artifact_url } CodeVersion { int id str version datetime created_at datetime updated_at } Commit { int id str sha datetime timestamp int repository_id } Consumer { int id str name datetime created_at datetime updated_at } JobTypes { int id str name datetime created_at datetime updated_at str display_name } Jobs { int id str git_ref int user_id int status_id datetime created_at datetime updated_at int job_type_id opt error_message str worker_version } Repository { int id str name str owner } RepositoryPermission { int id str name } Status { int id str name datetime created_at datetime updated_at } User { int id str name str avatar_url } UserRepository { int user_id int permission_id int repository_id } Book ||--|{ ApprovedBook : "" CodeVersion ||--|{ ApprovedBook : "" Consumer ||--|{ ApprovedBook : "" Commit ||--|{ Book : "" Book ||--|{ BookJob : "" Jobs ||--|{ BookJob : "" Repository ||--|{ Commit : "" JobTypes ||--|{ Jobs : "" Status ||--|{ Jobs : "" User ||--|{ Jobs : "" Repository ||--|{ UserRepository : "" RepositoryPermission ||--|{ UserRepository : "" User ||--|{ UserRepository : ""