Gallery:
  columns:
    caption:
      type: string(255)
      notnull: true
    description:
      type: clob
      extra: tinymce
      notnull: true

Media:
  actAs:
    Timestampable:
  columns:
    caption:
      type: string(255)
      notnull: true
    is_displayed_on_home:
      type: boolean
      default: false

Video:
  inheritance:
    type:             column_aggregation
    extends:          Media
  columns:
    preview_id:
      type: integer
#      notnull: false
    video_id:
      type: integer
#      notnull: false
    gallery_id:
      type: integer
#      notnull: false
  relations:
    Preview:
      class:      DmMedia
      local:      preview_id
      onDelete:   RESTRICT # the file can not be deleted, unless if the LibraryEntry is deleted before
    Video:
      class:      DmMedia
      local:      video_id
      onDelete:   RESTRICT # the video can not be deleted, unless if the article is deleted before that
    Gallery:
      local:      gallery_id
      onDelete:   CASCADE


Photo:
  inheritance:
    type:             column_aggregation
    extends:          Media
  columns:
    image_id:
      type: integer
#      notnull: false
    gallery_id:
      type: integer
#      notnull: false
  relations:
    Image:
      class:      DmMedia
      local:      image_id
      onDelete:   RESTRICT # the file can not be deleted, unless if the LibraryEntry is deleted before
    Gallery:
      local:      gallery_id
      onDelete:   CASCADE