qzBannerPlugin - schema.yml

options:
  collate: utf8_unicode_ci
  charset: utf8

qzBanner:
  tableName:    qz_banner
  actAs:
    timestampable: ~
  columns:
    location_id:
      type:     integer
    description:
      type:     string(256)
    link:
      type:     string(256)
    image_path:
      type:     string(128)
      notnull:  true
    width:
      type:     integer
    height:
      type:     integer
    is_active:
      type:     boolean
      default:  false
  relations:
    qzBannerLocation:
      onDelete:     CASCADE
      local:        location_id
      foreign:      id
      foreignAlias: Banners

qzBannerLocation:
  tableName:    qz_banner_location
  columns:
    location:
      type:     string(64)
      notnull:  true
      unique:   true