propel:
  sf_guard_user_profile:
    _attributes: { phpName: sfGuardUserProfile }
    id:
    user_id:     { type: integer, index: unique }
    corporate_id:
    first_name:  varchar(20)
    last_name:   varchar(20)
    email:       varchar(100)
    language:    { type: varchar(5), default: 'pt' }
    last_modifypwd: timestamp
  user_actionlog:
    _attributes: { phpName: UserActionlog }
    id:
    username:     varchar(50)
    module:       varchar(50)
    action:       varchar(50)
    details:      varchar(250)
    created_at:
  customer:
    _attributes:  { phpName: Customer }
    id:
    name:         { type: varchar(255), index: true }
    startdate:    date
    enddate:      date
    contract_type_id:
    idtype:       varchar(10)
    idnumber:     varchar(10)
    address:      longvarchar
    zip:          varchar(10)
    city:         varchar(100)
    phone:        varchar(20)
    mobile:       varchar(20)
    email:        varchar(150)
    homepage:     varchar(150)
    language:     { type: varchar(5), default: 'pt' }
    created_at:
    updated_at:
  contract:
    _attributes:  { phpName: Contract }
    id:
    customer_id:
    service_id:
    tariff_id:   
    contract_status_id:
    contract_type_id:
    center_payment_id:
    district_id:
    name:             { type: varchar(100), index: true }
    startdate:        date
    enddate:          { type: date }
    subscibeddemand:  varchar(10)
    supplypoint_1:    varchar(20)
    supplypoint_2:    varchar(20)
    supplypoint_3:    varchar(20)
    supply_address:   longvarchar
    supply_city:      varchar(100)
    supply_zip:       varchar(10)
    billing_address:  longvarchar
    billing_city:     varchar(100)
    billing_zip:      varchar(10)
    rounddown:         { type: decimal, size: 10, scale: 2, default: 0 }
    is_metered:       { type: boolean, default: 1 }
    created_at:
    updated_at:
  tariff:
    _attributes:  { phpName: Tariff }
    id:
    service_id:
    contract_type_id:
    name:         varchar(20)
    comment:      longvarchar
    is_metered:   { type: boolean, default: 1 }
    template:     varchar(50)
    created_at:
    updated_at:
  tariff_detail:
    _attributes:  { phpName: TariffDetail }
    id:
    tariff_id:
    name:         varchar(20)
    order:        integer
    units:        varchar(15)
    amount:       { type: decimal, size: 10, scale: 2 }
    applicablefield: varchar(50)
    startdate:    date
    enddate:      date
    comment:      longvarchar
    created_at:
    updated_at:
  contract_status:
    _attributes:  { phpName: ContractStatus }
    id:
    name:       varchar(15)
  contract_type:
    _attributes: { phpName: ContractType }
    id:
    name:       varchar(30)
  receipt:
    _attribute:   { phpName: Receipt }
    id:
    invoice_id:
    contract_id:
    receiptno:    varchar(20)
    paymentdate:   date
    amount:       { type: decimal, size: 10, scale: 2 }
    paymenttype:  varchar(10)
    comment:      longvarchar
    is_canceled:  boolean
    created_at:
    updated_at:
  invoice:
    _attributes:         { phpName: Invoice }
    id:
    contract_id:
    service_id:
    tariff_id:
    reading_cycle_id:
    tariffname:          varchar(20)
    billingdate:         date
    duedate:             date
    totalamount:         { type: decimal, size: 10, scale: 2 }
    is_fullypaid:        { type: boolean, default: 0 }
    datefullypaid:       date
    is_printed:          boolean
    is_canceled:         boolean
    created_at:
    updated_at:
  invoice_reading:
    _attributes: { phpName: InvoiceReading }
    id:
    invoice_id:
    reading_id:
    tariff_detail_id:
    meter_id:
    serialnb:     varchar(50)
    prvidx:       decimal
    prvdate:      date
    newidx:       decimal
    newdate:      date
    is_estimated: boolean
    multiplyfactor: decimal
    nbofdays:     integer
    tariff_detail_name: varchar(20)
    idxdiff:      decimal
    consumption:  decimal
    unitprice:    { type: decimal, size: 10, scale: 2 }
    amount:       { type: decimal, size: 10, scale: 2 }
    created_at:
    updated_at:
  invoice_contract:
    _attributes: { phpName: InvoiceContract }
    id:
    invoice_id:
    center_payment_id:
    name:           varchar(100)
    supply_address: longvarchar
    supply_zip:     varchar(10)
    supply_city:    varchar(100)
    billing_address:longvarchar
    billing_zip:    varchar(10)
    billing_city:   varchar(100)
    created_at:
    updated_at:
  invoice_customer:
    _attributes: { phpName: InvoiceCustomer }
    id:
    invoice_id:
    customer_id:
    name:         varchar(255)
    language:     { type: varchar(5), default: 'pt' }
    created_at:
    updated_at:
  invoice_detail:
    _attributes: { phpName: InvoiceDetail }
    id:
    invoice_id:
    tariff_detail_id:
    name:         varchar(20)
    unit:         { type: decimal, size: 10, scale: 2 }
    unitprice:    { type: decimal, size: 10, scale: 2 }
    amount:       { type: decimal, size: 10, scale: 2 }
    created_at:
    updated_at:
  meter:
    _attributes:    { phpName: Meter }
    id:
    serialnb:       { type: varchar(50), index: unique } 
    startdate:      date
    enddate:        date
    status:         tinyint
    capacity:       varchar(20)
    manufacturer:   varchar(20)
    model:          varchar(20)
    type:           varchar(10)
    multiplyfactor: { type: decimal, size: 5, default: 1 }
    digits:         integer
    initialidx:     { type: decimal, size: 5 }
    detail:         longvarchar
    created_at:
    updated_at:
  contract_meter:
    _attribute:     { phpName: ContractMeter }
    id:
    meter_id:
    contract_id:
    serialnb:       varchar(50)
    startdate:      date
    enddate:        { type: date }
    startinputdate: date
    endinputdate:   date
    initialidx:     decimal
    finalidx:       decimal
    # is_finalidxbill:boolean
    # finalcycle:     varchar(10)
    created_at:
    updated_at:
  reading:
    _attributes:    { phpName: Reading }
    id:
    contract_id:
    meter_id:
    reading_cycle_id:
    prv_cycle_id:   integer
    serialnb:       { type: varchar(50), index: true }
    prvidx:         decimal
    prvdate:        date
    newidx:         { type: decimal, default: null }
    newdate:        date
    idxdiff:        decimal
    nbofdays:       integer
    is_clocked:     boolean
    is_estimated:   boolean
    is_billed:      boolean
    donotbill:      boolean
    created_at:
    updated_at:
  center_payment:
    _attributes:  { phpName: CenterPayment }
    id:
    name:         varchar(50)
    created_at:
    updated_at:
  district:
    _attributes:   { phpName: District }
    id:
    district:       varchar(50)
    subdistrict:    varchar(50)
    correpondingdistrict: integer
  comment:
    _attributes:  { phpName: Comment }
    id:
    meter_id:
    contract_id:
    reading_id:
    invoice_id:
    comment_std_id:
    comment:    longvarchar
    created_at:
    updated_at:
  comment_std:
    _attributes: { phpName: CommentStd }
    id:
    type:   varchar(10)
    name:  varchar(100)
  reading_cycle:
    _attributes:  { phpName: ReadingCycle }
    id:
    service_id:
    name:         { type: varchar(10), index: unique }
    startdate:    date
    enddate:      date
    created_at:
    updated_at:
  reading_cycle_i18n:
    _attributes:  { phpName: ReadingCycleI18n }
    msg:          longvarchar
  corporate:
    _attributes: { phpName: Corporate }
    id:
    name:         varchar(50)
    description:  longvarchar
    startdate:    date
    enddate:      date
    created_at:
    updated_at:
  service:
    _attributes: { phpName: Service }
    id:
    corporate_id:
    name:         varchar(50)
    description:  longvarchar
    startdate:    date
    enddate:      date
    created_at:
    updated_at: