Database Schema Diagram - serlo/documentation GitHub Wiki

classDiagram
direction BT

class ad {
    <<deprecated>>
   int instance_id
   bigint image_id
   bigint author_id
   varchar(255) title
   text content
   float frequency
   int clicks
   varchar(255) url
   tinyint(1) banner
   int id
}
class ad_page {
    <<deprecated>>
   int instance_id
   bigint page_repository_id
}
class attachment_container {
   int instance_id
   int type_id
   bigint id
}
class attachment_file {
   bigint attachment_id
   int size
   varchar(255) location
   varchar(255) name
   varchar(40) type
   timestamp timestamp
   int id
}
class blog_post {
   bigint author_id
   bigint category_id
   int instance_id
   varchar(255) title
   timestamp date
   longtext content
   timestamp publish
   bigint id
}
class comment {
   int instance_id
   bigint author_id
   timestamp date
   tinyint(1) archived
   bigint uuid_id
   bigint parent_id
   varchar(255) title
   longtext content
   bigint id
}
class comment_vote {
   bigint comment_id
   bigint user_id
   tinyint vote
   int id
}
class context {
    <<deprecated>>
   bigint uuid_id
   int type_id
   int instance_id
   varchar(255) title
   int id
}
class context_route {
    <<deprecated>>
   int context_id
   varchar(255) route_name
   int id
}
class context_route_parameter {
    <<deprecated>>
   int context_route_id
   varchar(255) key
   varchar(255) value
   int id
}
class entity {
   int type_id
   int instance_id
   int license_id
   timestamp date
   int current_revision_id
   bigint id
}
class entity_link {
   bigint parent_id
   bigint child_id
   int type_id
   int order
   bigint id
}
class entity_revision {
   bigint author_id
   bigint repository_id
   timestamp date
   bigint id
}
class entity_revision_field {
   bigint entity_revision_id
   longtext value
   int id
   varchar(255) field
}
class event {
   varchar(255) name
   text description
   int id
}
class event_log {
   bigint actor_id
   int event_id
   bigint uuid_id
   int instance_id
   timestamp date
   bigint id
}
class event_parameter {
   bigint log_id
   int name_id
   int id
}
class event_parameter_name {
   varchar(255) name
   int id
}
class event_parameter_string {
   int event_parameter_id
   text value
   int id
}
class event_parameter_uuid {
   bigint uuid_id
   int event_parameter_id
   int id
}
class flag {
    <<deprecated>>
   bigint uuid_id
   int type_id
   bigint reporter_id
   int instance_id
   text content
   timestamp timestamp
   int id
}
class instance {
   int language_id
   varchar(255) name
   varchar(10) subdomain
   int id
}
class instance_permission {
    <<deprecated>>
   int permission_id
   int instance_id
   int id
}
class language {
   varchar(2) code
   varchar(255) name
   varchar(5) locale
   int id
}
class license {
   int instance_id
   tinyint(1) default
   varchar(255) title
   varchar(255) url
   text content
   text agreement
   varchar(255) icon_href
   int id
}
class metadata {
    <<deprecated>>
   bigint uuid_id
   int key_id
   varchar(255) value
   int id
}
class metadata_key {
    <<deprecated>>
   varchar(255) name
   int id
}
class migrations {
   varchar(255) name
   datetime run_on
   int id
}
class navigation_container {
   int instance_id
   int type_id
   int id
}
class navigation_page {
   int container_id
   int parent_id
   int position
   int id
}
class navigation_parameter {
   int page_id
   int key_id
   int parent_id
   varchar(255) value
   int id
}
class navigation_parameter_key {
   varchar(255) name
   int id
}
class notification {
   bigint user_id
   tinyint(1) seen
   timestamp date
   tinyint(1) email
   tinyint(1) email_sent
   int id
}
class notification_event {
   int notification_id
   bigint event_log_id
   int id
}
class page_repository {
   int instance_id
   int license_id
   bigint forum_id
   int current_revision_id
   tinyint(1) discussions_enabled
   bigint id
}
class page_repository_role {
    <<deprecated>>
   bigint page_repository_id
   int role_id
}
class page_revision {
   bigint author_id
   bigint page_repository_id
   varchar(255) title
   longtext content
   timestamp date
   tinyint(1) trashed
   bigint id
}
class permission {
    <<deprecated>>
   varchar(255) name
   int id
}
class related_content {
    <<deprecated>>
   bigint container_id
   int position
   int id
}
class related_content_category {
    <<deprecated>>
   varchar(255) name
   int id
}
class related_content_container {
    <<deprecated>>
   int instance_id
   bigint id
}
class related_content_external {
    <<deprecated>>
   varchar(255) url
   varchar(255) title
   int id
}
class related_content_internal {
    <<deprecated>>
   bigint reference_id
   varchar(255) title
   int id
}
class render {
    <<deprecated>>
   varchar(255) hash
   longtext source
   longtext output
   varchar(255) type
   int id
}
class role {
   varchar(32) name
   varchar(255) description
   int id
}
class role_inheritance {
    <<deprecated>>
   int role_id
   int child_id
}
class role_permission {
    <<deprecated>>
   int role_id
   int permission_id
}
class role_user {
   bigint user_id
   int role_id
}
class schema_migrations {
   tinyint(1) dirty
   bigint version
}
class session {
    <<deprecated>>
   int modified
   int lifetime
   text data
   varchar(35) id
   varchar(35) name
}
class subscription {
   bigint uuid_id
   bigint user_id
   tinyint(1) notify_mailman
   timestamp date
   int id
}
class taxonomy {
   int type_id
   int instance_id
   int id
}
class term {
   int instance_id
   varchar(255) name
   bigint id
}
class term_taxonomy {
   int taxonomy_id
   bigint term_id
   bigint parent_id
   text description
   int weight
   bigint id
}
class term_taxonomy_comment {
    <<deprecated>>
   bigint comment_id
   bigint term_taxonomy_id
   bigint id
}
class term_taxonomy_entity {
   bigint entity_id
   bigint term_taxonomy_id
   smallint position
   bigint id
}
class type {
   varchar(255) name
   int id
}
class url_alias {
   int instance_id
   bigint uuid_id
   timestamp timestamp
   varchar(255) source
   varchar(255) alias
   int id
}
class user {
   varchar(127) email
   varchar(32) username
   char(50) password
   int logins
   timestamp date
   varchar(32) token
   timestamp last_login
   text description
   bigint id
}
class user_field {
    <<deprecated>>
   bigint user_id
   longtext value
   int id
   varchar(255) field
}
class uuid {
   tinyint(1) trashed
   varchar(45) discriminator
   bigint id
}

ad  -->  attachment_container : image_id&#58id
ad  -->  instance : instance_id&#58id
ad  -->  user : author_id&#58id
ad_page  -->  instance : instance_id&#58id
ad_page  -->  page_repository : page_repository_id&#58id
attachment_container  -->  instance : instance_id&#58id
attachment_container  -->  type : type_id&#58id
attachment_container  -->  uuid : id
attachment_file  -->  attachment_container : attachment_id&#58id
blog_post  -->  instance : instance_id&#58id
blog_post  -->  term_taxonomy : category_id&#58id
blog_post  -->  user : author_id&#58id
blog_post  -->  uuid : id
comment  -->  comment : parent_id&#58id
comment  -->  instance : instance_id&#58id
comment  -->  user : author_id&#58id
comment  -->  uuid : id
comment  -->  uuid : uuid_id&#58id
comment_vote  -->  comment : comment_id&#58id
comment_vote  -->  user : user_id&#58id
context  -->  instance : instance_id&#58id
context  -->  type : type_id&#58id
context  -->  uuid : uuid_id&#58id
context_route  -->  context : context_id&#58id
context_route_parameter  -->  context_route : context_route_id&#58id
entity  -->  instance : instance_id&#58id
entity  -->  license : license_id&#58id
entity  -->  type : type_id&#58id
entity  -->  uuid : id
entity_link  -->  entity : child_id&#58id
entity_link  -->  entity : parent_id&#58id
entity_link  -->  type : type_id&#58id
entity_revision  -->  entity : repository_id&#58id
entity_revision  -->  user : author_id&#58id
entity_revision  -->  uuid : id
entity_revision_field  -->  entity_revision : entity_revision_id&#58id
event_log  -->  event : event_id&#58id
event_log  -->  instance : instance_id&#58id
event_log  -->  user : actor_id&#58id
event_log  -->  uuid : uuid_id&#58id
event_parameter  -->  event_log : log_id&#58id
event_parameter  -->  event_parameter_name : name_id&#58id
event_parameter_string  -->  event_parameter : event_parameter_id&#58id
event_parameter_uuid  -->  event_parameter : event_parameter_id&#58id
event_parameter_uuid  -->  uuid : uuid_id&#58id
flag  -->  instance : instance_id&#58id
flag  -->  type : type_id&#58id
flag  -->  user : reporter_id&#58id
flag  -->  uuid : uuid_id&#58id
instance  -->  language : language_id&#58id
instance_permission  -->  instance : instance_id&#58id
instance_permission  -->  permission : permission_id&#58id
license  -->  instance : instance_id&#58id
metadata  -->  metadata_key : key_id&#58id
metadata  -->  uuid : uuid_id&#58id
navigation_container  -->  instance : instance_id&#58id
navigation_container  -->  type : type_id&#58id
navigation_page  -->  navigation_container : container_id&#58id
navigation_page  -->  navigation_page : parent_id&#58id
navigation_parameter  -->  navigation_page : page_id&#58id
navigation_parameter  -->  navigation_parameter : parent_id&#58id
navigation_parameter  -->  navigation_parameter_key : key_id&#58id
notification  -->  user : user_id&#58id
notification_event  -->  event_log : event_log_id&#58id
notification_event  -->  notification : notification_id&#58id
page_repository  -->  instance : instance_id&#58id
page_repository  -->  license : license_id&#58id
page_repository  -->  term_taxonomy : forum_id&#58id
page_repository  -->  uuid : id
page_repository_role  -->  page_repository : page_repository_id&#58id
page_repository_role  -->  role : role_id&#58id
page_revision  -->  page_repository : page_repository_id&#58id
page_revision  -->  user : author_id&#58id
page_revision  -->  uuid : id
related_content  -->  related_content_container : container_id&#58id
related_content_category  -->  related_content : id
related_content_container  -->  instance : instance_id&#58id
related_content_container  -->  uuid : id
related_content_external  -->  related_content : id
related_content_internal  -->  related_content : id
related_content_internal  -->  uuid : reference_id&#58id
role_inheritance  -->  role : child_id&#58id
role_inheritance  -->  role : role_id&#58id
role_permission  -->  instance_permission : permission_id&#58id
role_permission  -->  permission : permission_id&#58id
role_permission  -->  role : role_id&#58id
role_user  -->  role : role_id&#58id
role_user  -->  user : user_id&#58id
subscription  -->  user : user_id&#58id
subscription  -->  uuid : uuid_id&#58id
taxonomy  -->  instance : instance_id&#58id
taxonomy  -->  type : type_id&#58id
term  -->  instance : instance_id&#58id
term_taxonomy  -->  taxonomy : taxonomy_id&#58id
term_taxonomy  -->  term : term_id&#58id
term_taxonomy  -->  term_taxonomy : parent_id&#58id
term_taxonomy  -->  uuid : id
term_taxonomy_comment  -->  comment : comment_id&#58id
term_taxonomy_comment  -->  term_taxonomy : term_taxonomy_id&#58id
term_taxonomy_entity  -->  entity : entity_id&#58id
term_taxonomy_entity  -->  term_taxonomy : term_taxonomy_id&#58id
url_alias  -->  instance : instance_id&#58id
url_alias  -->  uuid : uuid_id&#58id
user  -->  uuid : id
user_field  -->  user : user_id&#58id