columns:
  date_comptable:
    type: date
  facture_id:
    type: bigint
    default: "0"
  finess:
    type: character(9)
    default: "''::bpchar"
  medecin_comptabilise_id:
    type: bigint
    default: "0"
  montant_comptabilise:
    type: numeric(13,2)
    default: "0"
  montant_comptabilise_0:
    type: numeric(13,2)
    default: "0"
  montant_comptabilise_1:
    type: numeric(13,2)
    default: "0"
  montant_comptabilise_2:
    type: numeric(13,2)
    default: "0"
  montant_comptabilise_22:
    type: numeric(13,2)
    default: "0"
  montant_regle:
    type: numeric(13,2)
    default: "0"
  montant_regle_0:
    type: numeric(13,2)
    default: "0"
  montant_regle_1:
    type: numeric(13,2)
    default: "0"
  montant_regle_2:
    type: numeric(13,2)
    default: "0"
  montant_regle_22:
    type: numeric(13,2)
    default: "0"
  montant_solde:
    type: numeric(13,2)
    default: "0"
  montant_solde_0:
    type: numeric(13,2)
    default: "0"
  montant_solde_1:
    type: numeric(13,2)
    default: "0"
  montant_solde_2:
    type: numeric(13,2)
    default: "0"
  montant_solde_22:
    type: numeric(13,2)
    default: "0"
  no_facture:
    type: text
    not_null: NOT NULL
  od_avoir:
    type: character(1)
    default: "'0'::character varying"
  od_non_comptabilise:
    type: text
    default: "'0'::text"
  prestation_id:
    type: bigint
    default: "0"
  rubrique_comptabilisee_id:
    type: bigint
    default: "0"
indexes:
  i_factures_soldes_h_1:
    column: no_facture
    method: btree
  i_factures_soldes_h_3:
    column: medecin_comptabilise_id
    method: btree
  i_factures_soldes_h_4:
    column: date_comptable
    method: btree
  i_factures_soldes_h_8:
    column: facture_id
    method: btree