Piece:
  columns:
    id:               { type: integer(4), unsigned: true, notnull: true, autoincrement: true, primary: true }
    title:            { type: string(255), notnull: true }
    year:             { type: integer(4), range: [1900,2100] }
    instrumentation:  { type: string(255), notnull: false }
    composer_id:      { type: integer(4), unsigned: true, notnull: true }
    notes:            { type: clob, notnull: false }
    sound_url:        { type: string(255), notnull: false }
  actAs:
    Timestampable: ~
    Sluggable:
      unique:   true
      fields:   [ title ]
      canUpdate: true
  indexes:
    composer_idx:
      fields:   [ composer_id ]
  relations:
    Composer:
      class: Person
      local: composer_id
      foreign: id
      foreignAlias: Pieces
    Flags:
      class: Flag
      local: piece_id
      foreign: flag_id
      refClass: PieceFlag


Flag:
  columns:
    id:         { type: integer(4), unsigned: true, notnull: true, autoincrement: true, primary: true }
    longname:   { type: string(255), notnull: true }
    shortname:  { type: string(255), notnull: true }
  relations:
    Pieces:
      class: Piece
      local: flag_id
      foreign: piece_id
      refClass: PieceFlag


PieceFlag:
  columns:
    piece_id:   { type: integer(4), unsigned: true, notnull: true, primary: true }
    flag_id:    { type: integer(4), unsigned: true, notnull: true, primary: true }