# config/schema.yml
propel:
  user:
    id: ~
    name: { type: varchar(30), required: true }
    surname: { type: varchar(30), required: true }
    direction: { type: varchar(60), required: true }
    telephone: { type: integer, required: true }
    email: { type: varchar(40), required: true,  index: unique }
    username: { type: varchar(30), required: true }
    password: { type: varchar(40), required: true }
    account_id: { type: integer, foreignTable: account, foreignReference: id, required: true }
  account:
    id: ~
    number: { type: integer }
  movements:
    id: ~
    updated_at: ~
    amount: { type: integer }
    description: { type: longvarchar }
    account_id: { type: integer, foreignTable: account, foreignReference: id, required: true }