schema_propel_alternative.yml

classes:

  Region:
    columns:
      id:          ~
      name:        { type: varchar, required: true, primaryString: true }
    indexes:       { region_name: [ name ] }

  Province:
    columns:
      id:          { type: char, size: 2, required: true, primaryKey: true }
      name:        { type: varchar, required: true, primaryString: true }
      region_id:   { type: integer, foreignClass: Region, foreignReference: id, onDelete: CASCADE, onUpdate: CASCADE }
    indexes:       { province_name: [ name ] }

  City:
    columns:
      id:          { type: char, size: 4, required: true, primaryKey: true }
      name:        { type: varchar, required: true, primaryString: true }
      province_id: { type: char, size: 2, required: true, foreignClass: Province, foreignReference: id, onUpdate: CASCADE, onDelete: CASCADE }
      latitude:    { type: decimal, scale: 6, size: 8, required: true }
      longitude:   { type: decimal, scale: 6, size: 8, required: true }
    indexes:       { city_name: [ name ] }