AFFILIATION:
  connection: doctrine
  tableName: AFFILIATION
  columns:
    aff_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    aff_typ:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    aff_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    aff_adr1:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    aff_adr2:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    aff_adr3:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    aff_cp:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    aff_ville:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    aff_tel:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    aff_caisse:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
AGENCE:
  connection: doctrine
  tableName: AGENCE
  columns:
    age_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    age_adr1:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_adr2:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_adr3:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_cp:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_ville:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_tel:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_fax:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_num_convention:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_siret:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_ape:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_site_web:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_login:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_mot_passe:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_photo:
      type: blob()
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    COMMANDE:
      local: age_cod
      foreign: age_cod
      type: many
    EMPLACEMENT:
      local: age_cod
      foreign: age_cod
      type: many
    FOURNISSEUR:
      local: age_cod
      foreign: age_cod
      type: many
    RECEPTION:
      local: age_cod
      foreign: age_cod
      type: many
    RENTABILITE:
      local: age_cod
      foreign: age_cod
      type: many
    TECHNICIEN:
      local: age_cod
      foreign: age_cod
      type: many
    UTILISATEUR:
      local: age_cod
      foreign: age_cod
      type: many
ARTICLE:
  connection: doctrine
  tableName: ARTICLE
  columns:
    art_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    ref_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tyf_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rec_num:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    emp_cod:
      type: string(13)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    art_num_serie:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    art_prix_achat:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    art_lot:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    art_peremption:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    art_qte:
      type: float(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    art_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    art_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    art_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    art_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    REFERENCE:
      local: ref_cod
      foreign: ref_cod
      type: one
    TYPE_FACTURATION:
      local: tyf_cod
      foreign: tyf_cod
      type: one
    RECEPTION:
      local: rec_num
      foreign: rec_num
      type: one
    EMPLACEMENT:
      local: emp_cod
      foreign: emp_cod
      type: one
    DISPOSITIF_MEDICAL:
      local: art_cod
      foreign: art_cod
      type: many
    REGLAGE:
      local: art_cod
      foreign: art_cod
      type: many
AffiliationMut:
  connection: doctrine
  tableName: affiliation_mut
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    numéro:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    nom:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    c.postal:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ville:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    téléphone:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'taux remboursement':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'caisse gestionnaire':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'n° préfectoral':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'n°contrat santé-pharma':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
AffiliationSecu:
  connection: doctrine
  tableName: affiliation_secu
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    col001:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    col002:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    col003:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    col004:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    col005:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    col006:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    col007:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    col008:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    col009:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
CENTRE:
  connection: doctrine
  tableName: CENTRE
  columns:
    cen_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    cen_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_adr1:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_adr2:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_adr3:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_cp:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_ville:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_tel_std:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_tel_service:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_fax:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_login:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_mot_passe:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    RENTABILITE:
      local: cen_cod
      foreign: cen_cod
      type: many
CENTRE_MEDECIN:
  connection: doctrine
  tableName: CENTRE_MEDECIN
  columns:
    cem_cod:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    cen_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cem_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cem_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cem_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cem_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
COMMANDE:
  connection: doctrine
  tableName: COMMANDE
  columns:
    cde_num:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    age_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cde_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_typ:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    emp_typ_stock:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    emp_typ:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_cod_liv:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cde_nom_fact:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cde_adr1_fact:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cde_adr2_fact:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cde_adr3_fact:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cde_cp_fact:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cde_ville_fact:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cde_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cde_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cde_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cde_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cde_etat:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    AGENCE:
      local: age_cod
      foreign: age_cod
      type: one
    FOURNISSEUR:
      local: fou_cod
      foreign: fou_cod
      type: one
    COMMANDE_LIGNE:
      local: cde_num
      foreign: cde_num
      type: many
COMMANDE_LIGNE:
  connection: doctrine
  tableName: COMMANDE_LIGNE
  columns:
    cli_num:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    cde_num:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cli_qte_a_cder:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cli_qte_cde:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cli_pu:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    COMMANDE:
      local: cde_num
      foreign: cde_num
      type: one
    REFERENCE:
      local: ref_cod
      foreign: ref_cod
      type: one
COMMENTAIRES:
  connection: doctrine
  tableName: COMMENTAIRES
  columns:
    com_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    med_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    com_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    com_comment:
      type: string(2000)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    com_traite:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    MEDECIN:
      local: med_cod
      foreign: med_cod
      type: one
    PATIENT:
      local: pat_cod
      foreign: pat_cod
      type: one
COMPTEUR:
  connection: doctrine
  tableName: COMPTEUR
  columns:
    cpt_table:
      type: string(35)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    cpt_compteur:
      type: float(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
DEP:
  connection: doctrine
  tableName: DEP
  columns:
    dep_num:
      type: string(13)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_typ_demande:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_a_compter_du:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_situation_assure:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_dat_cession_activite:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_situation_assure_autre:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_accident:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_dat_accident:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_pension_guerre:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_malade_nom:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_malade_prenom:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_malade_lien_assure:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_malade_activite:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_sur_liste:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_hors_liste:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_1_1:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_1_2:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_1_3:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_1_4:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_2_1:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_2_2:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_2_3:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_2_4:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_3_1:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_3_2:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_3_3:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_3_4:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_4_3:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_4_4:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_5_3:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_5_4:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_6_3:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_6_4:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_7_3:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_7_4:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_8_3:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_8_4:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_9_3:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_9_4:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_10_3:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_traitement_10_4:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_acte:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_assoc_nom:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_assoc_ad1:
      type: string(100)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_assoc_ad2:
      type: string(100)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_forfait:
      type: string(5)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_1_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_1_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_2_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_2_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_3_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_3_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_4_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_4_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_5_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_5_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_6_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_6_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_7_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_7_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_8_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_8_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_9_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_9_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_10_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_10_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_11_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_11_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_12_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_12_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_13_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_13_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_14_1:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_14_2:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etiologie_autre:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_tabac:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etat_clinique:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_spirographie_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_spirographie_poids:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_spirographie_capacite_vitale:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_spirographie_vems:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_spirographie_taille:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_spirographie_capacite_totale:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_1_1:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_1_3:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_1_4:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_1_5:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_1_6:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_2_1:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_2_3:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_2_4:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_2_5:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_2_6:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_3_1:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_3_3:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_3_4:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_3_5:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_3_6:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_4_1:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_4_3:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_4_4:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_4_5:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_gaz_sang_4_6:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_hematocrite:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_cas_particuliers_1:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_cas_particuliers_2:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_etat:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_dat_med:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    PATIENT:
      local: pat_cod
      foreign: pat_cod
      type: one
DISPOSITIF_ETAPE:
  connection: doctrine
  tableName: DISPOSITIF_ETAPE
  columns:
    dml_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    dme_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    emp_cod:
      type: string(13)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dml_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    uti_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dml_typ:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dml_resultat:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dml_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    EMPLACEMENT:
      local: emp_cod
      foreign: emp_cod
      type: one
DISPOSITIF_MEDICAL:
  connection: doctrine
  tableName: DISPOSITIF_MEDICAL
  columns:
    dme_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    art_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_num:
      type: float(8)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dme_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dme_num_serie:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dme_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dme_etat:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dme_motif:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    ARTICLE:
      local: art_cod
      foreign: art_cod
      type: one
    INTERVENTION:
      local: int_num
      foreign: int_num
      type: one
    DISPOSITIF_REGLAGE:
      local: dme_cod
      foreign: dme_cod
      type: many
DISPOSITIF_REGLAGE:
  connection: doctrine
  tableName: DISPOSITIF_REGLAGE
  columns:
    dmr_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    dme_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dmr_mod_ventil:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dmr_param:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dmr_unit:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dmr_val:
      type: string(13)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    DISPOSITIF_MEDICAL:
      local: dme_cod
      foreign: dme_cod
      type: one
DROIT:
  connection: doctrine
  tableName: DROIT
  columns:
    dro_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    fct_num:
      type: float(8)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    grp_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
ECRAN:
  connection: doctrine
  tableName: ECRAN
  columns:
    ecr_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    ecr_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    FONCTION_ECRAN:
      local: ecr_cod
      foreign: ecr_cod
      type: many
EDITION:
  connection: doctrine
  tableName: EDITION
  columns:
    edi_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    edi_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    edi_fiche:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    edi_proc:
      type: string(200)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    edi_comment:
      type: string(2000)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    EDITION_MEDECIN:
      local: edi_cod
      foreign: edi_cod
      type: many
EDITION_MEDECIN:
  connection: doctrine
  tableName: EDITION_MEDECIN
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    edi_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    edm_comment:
      type: string(2000)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    EDITION:
      local: edi_cod
      foreign: edi_cod
      type: one
    MEDECIN:
      local: med_cod
      foreign: med_cod
      type: one
EMPLACEMENT:
  connection: doctrine
  tableName: EMPLACEMENT
  columns:
    emp_cod:
      type: string(13)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    age_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    emp_typ:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    emp_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    emp_typ_stock:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    AGENCE:
      local: age_cod
      foreign: age_cod
      type: one
    ARTICLE:
      local: emp_cod
      foreign: emp_cod
      type: many
    DISPOSITIF_ETAPE:
      local: emp_cod
      foreign: emp_cod
      type: many
    RECEPTION:
      local: emp_cod
      foreign: emp_cod
      type: many
    RECEPTION_LIGNE:
      local: emp_cod
      foreign: emp_cod
      type: many
    TECHNICIEN:
      local: emp_cod
      foreign: emp_cod
      type: many
EMP_ART:
  connection: doctrine
  tableName: EMP_ART
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    art_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    emp_cod:
      type: string(13)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ear_num_serie:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rec_num:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tyf_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ear_prix_achat:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ear_lot:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ear_peremption:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ear_qte:
      type: float(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ear_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ear_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ear_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ear_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
ENT_TYPE_ETAT:
  connection: doctrine
  tableName: ENT_TYPE_ETAT
  columns:
    ety_cod:
      type: string(20)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    ety_lg:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ety_modif:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
FAMILLE_FORFAIT:
  connection: doctrine
  tableName: FAMILLE_FORFAIT
  columns:
    far_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    fam_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_cod:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    FAMILLE_REF:
      local: fam_cod
      foreign: fam_cod
      type: one
    FORFAIT:
      local: for_cod
      foreign: for_cod
      type: one
FAMILLE_REF:
  connection: doctrine
  tableName: FAMILLE_REF
  columns:
    fam_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    fam_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fam_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fam_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fam_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fam_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    FAMILLE_FORFAIT:
      local: fam_cod
      foreign: fam_cod
      type: many
    REFERENCE:
      local: fam_cod
      foreign: fam_cod
      type: many
FICHE:
  connection: doctrine
  tableName: FICHE
  columns:
    fic_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    mes_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
      autoincrement: false
    fic_intervenanttel:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_lieuintervention:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_dateintervention:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_ppc:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_autopilotee:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_codtypematerielppcautopilotee:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_typematerielppcautopilotee:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_pmini:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_pmaxi:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_constante:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_pressionconstante:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_codtypematerielppcconstante:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_typematerielppcconstante:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_iah:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_microeveil:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_humidificateurppc:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_oxygene:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_concentrateur:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_dureeconcentrateur:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_debitconcentrateur:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_codtypematerieloxygeneconcentrateur:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_typematerieloxygeneconcentrateur:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_liquide:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_dureeliquide:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_debitliquide:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_codtypematerieloxygeneliquide:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_typematerieloxygeneliquide:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_gazeux:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_bouteillesecours:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_deambulation:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_codtypematerieloxygenegazeux:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_typematerieloxygenegazeux:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_humidificateuroxygene:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_respirateur:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_codtypematerielrespirateur:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_typematerielrespirateur:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_parametreventilation:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_humidificateurrespirateur:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_aerosol:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_pneumatique:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_codtypematerielaerosolpneumatique:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_typematerielaerosolpneumatique:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_ultrasonique:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_codtypematerielultrasonique:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_typematerielaerosolultrasonique:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_observationaerosol:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_aspirateurmucosite:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_codtypematerielaspirateurmucosite:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_typematerielaspirateurmucosite:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_observationaspirateurmucosite:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_typemasque:
      type: string(200)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_observation:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_dateedition:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_codtypefiche:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_codraisonretrait:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_datedeces:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_oxymetrie:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_codtypeoxymetrie:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_polygraphie:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_codtypepolygraphie:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_polysomnographie:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_codtypepolysomnographie:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fic_autreexamencomplementaire:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fic_codautreexamencomplementaire:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    MESSAGE:
      local: mes_cod
      foreign: mes_cod
      type: one
    FICHEFORFAIT:
      local: fic_num
      foreign: fic_num
      type: many
    FICHEREFERENCE:
      local: fic_num
      foreign: fic_num
      type: many
    FICHEREGLAGE:
      local: fic_num
      foreign: fic_num
      type: many
FICHEFORFAIT:
  connection: doctrine
  tableName: FICHEFORFAIT
  columns:
    fic_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    for_cod:
      type: string(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    ffo_ancien:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    ffo_nouveau:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
  relations:
    FICHE:
      local: fic_num
      foreign: fic_num
      type: one
    FORFAIT:
      local: for_cod
      foreign: for_cod
      type: one
FICHEREFERENCE:
  connection: doctrine
  tableName: FICHEREFERENCE
  columns:
    fic_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    ref_cod:
      type: string(20)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    fre_ancien:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fre_nouveau:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
  relations:
    FICHE:
      local: fic_num
      foreign: fic_num
      type: one
    REFERENCE:
      local: ref_cod
      foreign: ref_cod
      type: one
FICHEREGLAGE:
  connection: doctrine
  tableName: FICHEREGLAGE
  columns:
    fic_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    reg_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    fre_val:
      type: string(13)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    FICHE:
      local: fic_num
      foreign: fic_num
      type: one
    REGLAGE:
      local: reg_num
      foreign: reg_num
      type: one
FICHERENSEIGNEMENT:
  connection: doctrine
  tableName: FICHERENSEIGNEMENT
  columns:
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    fir_prescriptioninitiale:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fir_somnolencediurne:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fir_ronflement:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fir_cephaleematinale:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fir_vigilancereduite:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fir_troublelibido:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fir_hta:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fir_nycturie:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fir_renouvellement:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fir_observancesupegal3h:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fir_traitementefficace:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    fir_dateedition:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    PATIENT:
      local: pat_cod
      foreign: pat_cod
      type: one
FONCTION_ECRAN:
  connection: doctrine
  tableName: FONCTION_ECRAN
  columns:
    fct_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    ecr_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fct_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    ECRAN:
      local: ecr_cod
      foreign: ecr_cod
      type: one
FORFAIT:
  connection: doctrine
  tableName: FORFAIT
  columns:
    for_cod:
      type: string(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    for_nom:
      type: string(200)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_tarif:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_tarif_edf:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_comment:
      type: string(2000)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_bouteille:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_cod_fact1:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_lien_forfait1:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_cod_fact2:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_lien_forfait2:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_cod_fact3:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_lien_forfait3:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_secondaire:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    FAMILLE_FORFAIT:
      local: for_cod
      foreign: for_cod
      type: many
    FICHEFORFAIT:
      local: for_cod
      foreign: for_cod
      type: many
FOURNISSEUR:
  connection: doctrine
  tableName: FOURNISSEUR
  columns:
    fou_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    age_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tyf_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_cod_client:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_adr1:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_adr2:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_adr3:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_cp:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_ville:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_tel:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_fax:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_com_nom:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_com_tel:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_com_portable:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_sav_adr1:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_sav_adr2:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_sav_adr3:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_sav_cp:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_sav_ville:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_sav_tel:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_sav_fax:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_sav_contact:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_delai_liv:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_delai_paiement:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_escompte:
      type: float(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    AGENCE:
      local: age_cod
      foreign: age_cod
      type: one
    TYPE_FACTURATION:
      local: tyf_cod
      foreign: tyf_cod
      type: one
    COMMANDE:
      local: fou_cod
      foreign: fou_cod
      type: many
    RECEPTION:
      local: fou_cod
      foreign: fou_cod
      type: many
    REFERENCE:
      local: fou_cod
      foreign: fou_cod
      type: many
GROUPE:
  connection: doctrine
  tableName: GROUPE
  columns:
    grp_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    grp_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    UTILISATEUR:
      local: grp_cod
      foreign: grp_cod
      type: many
INTERVENTION:
  connection: doctrine
  tableName: INTERVENTION
  columns:
    int_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    tec_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_num:
      type: float(8)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tyi_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat_prev:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat_visite:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat_real:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_heur_arrivee:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_heur_depart:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_renouv:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dep_patient:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat_rdv_prescripteur:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment_pour_tech:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment_tech:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment_cr:
      type: string(1000)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment_cr_valid:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment_prochaine_intervention:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment_ide:
      type: string(2000)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_etat:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_observ_ventil:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_observ_o2:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_sat_avec_o2:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_sat_sans_o2:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_heur_deb_visite:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_heur_fin_visite:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_a_controler:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_controle:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_pds:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_iah_init:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_iah_residuel:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_score_epworth:
      type: float(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    TECHNICIEN:
      local: tec_cod
      foreign: tec_cod
      type: one
    PRESCRIPTION:
      local: pre_num
      foreign: pre_num
      type: one
    TYPE_INTERVENTION:
      local: tyi_cod
      foreign: tyi_cod
      type: one
    PATIENT:
      local: pat_cod
      foreign: pat_cod
      type: one
    DISPOSITIF_MEDICAL:
      local: int_num
      foreign: int_num
      type: many
    MESSAGE:
      local: int_num
      foreign: int_num
      type: many
INTERVENTION_DETAIL:
  connection: doctrine
  tableName: INTERVENTION_DETAIL
  columns:
    ide_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    art_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_num:
      type: float(8)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ide_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ide_typ:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ide_num_serie:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ide_lot:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ide_peremption:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ide_qte:
      type: float(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ide_motif:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ide_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ide_etat:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tyf_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rec_num:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ide_prix_achat:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
INTERVENTION_MESURE:
  connection: doctrine
  tableName: INTERVENTION_MESURE
  columns:
    ime_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    int_num:
      type: float(8)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ime_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ime_typ:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ime_val:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
INTERVENTION_TRACE:
  connection: doctrine
  tableName: INTERVENTION_TRACE
  columns:
    int_cle:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    int_num:
      type: float(8)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tyi_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_num:
      type: float(8)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat_prev:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat_visite:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_heur_deb_visite:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_heur_fin_visite:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat_real:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_heur_arrivee:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_heur_depart:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_renouv:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dep_patient:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat_rdv_prescripteur:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_observ_ventil:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_observ_o2:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_sat_avec_o2:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_sat_sans_o2:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment_pour_tech:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment_tech:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment_cr:
      type: string(1000)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment_cr_valid:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment_prochaine_intervention:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment_ide:
      type: string(2000)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_etat:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
MEDECIN:
  connection: doctrine
  tableName: MEDECIN
  columns:
    med_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    med_ident:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_typ:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_nom_marital:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_prenom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_adr1:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_adr2:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_adr3:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cp:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_ville:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_courriel:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_tel1:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_tel2:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_fax:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_bip:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_portable:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_commercial:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_login:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_mot_passe:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_envoi_cr:
      type: float(3)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_civilite:
      type: string(15)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_consigne_appareil:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_consigne_visite:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_dep_envoi:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_dep_delai:
      type: float(5)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    COMMENTAIRES:
      local: med_cod
      foreign: med_cod
      type: many
    EDITION_MEDECIN:
      local: med_cod
      foreign: med_cod
      type: many
    MESSAGE:
      local: med_cod
      foreign: med_cod
      type: many
    RENTABILITE:
      local: med_cod
      foreign: med_cod
      type: many    
MESSAGE:
  connection: doctrine
  tableName: MESSAGE
  columns:
    mes_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    uti_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
      autoincrement: false
    mes_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_codtechnicien:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_codautredestinataire:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tyi_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_consigne_appareil:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_consigne_visite:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_codraisonappel:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_dateappel:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_detail:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_concernetechnicien:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    mes_mailtechnicien:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    mes_datetranstechnicien:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_recutechnicien:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    mes_concernelivreurliquide:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    mes_maillivreurliquide:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    mes_datetranslivreurliquide:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_reculivreurliquide:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    mes_mailautredestinataire:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    mes_datetransautredestinataire:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_recuautredestinataire:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    mes_prevenir_infirmiere:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    mes_prevenir_pharmacien:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    mes_intervention:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    mes_dat_rdv_prescripteur:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_datedernierevisiterealisee:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_dateprochainevisiteprevue:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_dateprochainevisiteplanifiee:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_nom_marital:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_prenom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_civilite:
      type: string(15)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_naissance:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_sortie:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_etat:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_adr1:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_adr2:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_adr3:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_cp:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_ville:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_zoneg:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_tel:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_tel1:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_portable:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod_prescripteur:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cem_cod_prescripteur:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod_prescripteur2:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_agence_sysmed:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_protocole:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_cod_orthop:
      type: string(5)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_pire_etat_dep:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_forfait:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_num:
      type: float(8)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_dateintervention:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_copie:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_mailcopie:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    mes_datetranscopie:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_recucopie:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
  relations:
    UTILISATEUR:
      local: uti_cod
      foreign: uti_cod
      type: one
    UTILISATEUR_2:
      class: UTILISATEUR
      local: mes_qui_crea
      foreign: uti_cod
      type: one
    UTILISATEUR_3:
      class: UTILISATEUR
      local: mes_qui_maj
      foreign: uti_cod
      type: one
    PATIENT:
      local: pat_cod
      foreign: pat_cod
      type: one
    MEDECIN:
      local: med_cod
      foreign: med_cod
      type: one
    TECHNICIEN:
      local: tec_cod
      foreign: tec_cod
      type: one
    TECHNICIEN_7:
      class: TECHNICIEN
      local: tec_codtechnicien
      foreign: tec_cod
      type: one
    TECHNICIEN_8:
      class: TECHNICIEN
      local: tec_codautredestinataire
      foreign: tec_cod
      type: one
    TYPE_INTERVENTION:
      local: tyi_cod
      foreign: tyi_cod
      type: one
    INTERVENTION:
      local: int_num
      foreign: int_num
      type: one
    FICHE:
      local: mes_cod
      foreign: mes_cod
      type: many
MESSAGE_REJET:
  connection: doctrine
  tableName: MESSAGE_REJET
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    'n° patient':
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_nom_marital:
      type: string(100)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    prenom:
      type: string(100)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'heure appel':
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'raison appel':
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'initiale traité':
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'zone geographique':
      type: string(100)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'transmis serv oxy':
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    n°:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'médecin prescripteur':
      type: string(100)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    date_appel:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    uti_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    date_creation:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_detail2:
      type: string(1000)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'transmis au responsable technique':
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_cod:
      type: string(1252)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mes_detail2_ansi:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_nom_marital_ansi:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_codansi:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    prenom_ansi:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    zone_geographique_ansi:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    datetechnicien:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    datelivreurliquide:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    errorcode:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    errorcolumn:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
MESURE_CLINIQUE:
  connection: doctrine
  tableName: MESURE_CLINIQUE
  columns:
    mec_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mec_typ:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mec_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mec_val:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
MOUVEMENT:
  connection: doctrine
  tableName: MOUVEMENT
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    mvt_typ:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    art_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    emp_cod:
      type: string(13)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mvt_num_serie:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rec_num:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tyf_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mvt_prix_achat:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mvt_lot:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mvt_peremption:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mvt_qte:
      type: float(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mvt_motif:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mvt_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mvt_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mvt_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    mvt_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
PARAMETRE:
  connection: doctrine
  tableName: PARAMETRE
  columns:
    par_nom:
      type: string(50)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    par_adr1:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    par_adr2:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    par_adr3:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    par_cp:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    par_ville:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    par_identifiant:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
PATIENT:
  connection: doctrine
  tableName: PATIENT
  columns:
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    pat_typ:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_civilite:
      type: string(15)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_nom_marital:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_prenom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_naissance:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_adr1:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_adr2:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_adr3:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_cp:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_ville:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_zoneg:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_adm_adr1:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_adm_adr2:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_adm_adr3:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_adm_cp:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_adm_ville:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_adm_zoneg:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_tel:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_portable:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_fax:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_courriel:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod_traitant:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod_prescripteur:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cem_cod_prescripteur:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_agence_sysmed:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_protocole:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_pire_etat_dep:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_forfait:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_rib_recu:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_num:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    aff_ss_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_rg_naissance:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_rg_beneficiaire:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_tx:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_mut_num:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    aff_mut_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_mut_tiers_payant:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_mut_tx:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_mut_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_sortie:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_rembt_edf:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_etat:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_comment:
      type: string(2000)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_rdv_prescripteur:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_sexe:
      type: string(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_cod_orthop:
      type: string(5)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_tel1:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod_prescripteur2:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_prenom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_aff_sur_liste:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_aff_hors_liste:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_prevenir_infirmiere:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    pat_prevenir_pharmacien:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    pat_adm_adr_avi_passag:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
    pat_dat_instal:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    COMMENTAIRES:
      local: pat_cod
      foreign: pat_cod
      type: many        
    MEDECIN:
      local: med_cod_prescripteur
      foreign: med_cod
      type: many       
    DEP:
      local: pat_cod
      foreign: pat_cod
      type: many
    FICHERENSEIGNEMENT:
      local: pat_cod
      foreign: pat_cod
      type: many
    INTERVENTION:
      local: pat_cod
      foreign: pat_cod
      type: many
    MESSAGE:
      local: pat_cod
      foreign: pat_cod
      type: many
    PATIENT_HISTO:
      local: pat_cod
      foreign: pat_cod
      type: many
    REGLAGE:
      local: pat_cod
      foreign: pat_cod
      type: many
    REMBOURSEMENT_EDF:
      local: pat_cod
      foreign: pat_cod
      type: many
    RENTABILITE:
      local: pat_cod
      foreign: pat_cod
      type: many
    MEDECIN:
      local: med_cod
      foreign: med_cod_prescripteur
      type: many
PATIENT_HISTO:
  connection: doctrine
  tableName: PATIENT_HISTO
  columns:
    pah_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pah_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pah_qui:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pah_comment:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    PATIENT:
      local: pat_cod
      foreign: pat_cod
      type: one
PATIENT_TRACE:
  connection: doctrine
  tableName: PATIENT_TRACE
  columns:
    pat_cle:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_typ:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_civilite:
      type: string(15)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_nom_marital:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_prenom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_naissance:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_sexe:
      type: string(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_adr1:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_adr2:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_adr3:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_cp:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_ville:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_geo_zoneg:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_adm_adr1:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_adm_adr2:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_adm_adr3:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_adm_cp:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_adm_ville:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_adm_zoneg:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_tel:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_tel1:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_portable:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_fax:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_courriel:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_cod_orthop:
      type: string(5)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod_traitant:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod_prescripteur:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cem_cod_prescripteur:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod_prescripteur2:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_agence_sysmed:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_protocole:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_pire_etat_dep:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_forfait:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_rib_recu:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_num:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    aff_ss_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_rg_naissance:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_rg_beneficiaire:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_tx:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_ss_prenom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_aff_sur_liste:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_aff_hors_liste:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_mut_num:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    aff_mut_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_mut_tiers_payant:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_mut_tx:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_mut_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_sortie:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_rembt_edf:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_rdv_prescripteur:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_etat:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_comment:
      type: string(2000)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
PRESCRIPTION:
  connection: doctrine
  tableName: PRESCRIPTION
  columns:
    pre_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    for_cod:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cem_cod:
      type: float(8)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dat_deb:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dat_instal:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dat_fin:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_aero_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_aero_etat:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_o2_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_o2_etat:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dep_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dep_etat:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dep_lien:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_int_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_plan_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_num:
      type: string(13)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_rejet_etat:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_rejet_comment:
      type: string(2147483647)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    INTERVENTION:
      local: pre_num
      foreign: pre_num
      type: many
    PRESCRIPTION_DOCUMENT:
      local: pre_num
      foreign: pre_num
      type: many
PRESCRIPTION_DOCUMENT:
  connection: doctrine
  tableName: PRESCRIPTION_DOCUMENT
  columns:
    prd_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    pre_num:
      type: float(8)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    prd_lien:
      type: string(200)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    PRESCRIPTION:
      local: pre_num
      foreign: pre_num
      type: one
PRESCRIPTION_TRACE:
  connection: doctrine
  tableName: PRESCRIPTION_TRACE
  columns:
    pre_cle:
      type: integer(4)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    pre_num:
      type: float(8)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dep_num:
      type: string(13)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_cod:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cem_cod:
      type: float(8)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dat_deb:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dat_instal:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dat_fin:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_aero_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_aero_etat:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_o2_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_o2_etat:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dep_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dep_etat:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dep_lien:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_int_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_plan_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pre_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
RECEPTION:
  connection: doctrine
  tableName: RECEPTION
  columns:
    rec_num:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    age_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    emp_cod:
      type: string(13)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rec_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rec_etat:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rec_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rec_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rec_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rec_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    AGENCE:
      local: age_cod
      foreign: age_cod
      type: one
    EMPLACEMENT:
      local: emp_cod
      foreign: emp_cod
      type: one
    FOURNISSEUR:
      local: fou_cod
      foreign: fou_cod
      type: one
    ARTICLE:
      local: rec_num
      foreign: rec_num
      type: many
    RECEPTION_LIGNE:
      local: rec_num
      foreign: rec_num
      type: many
RECEPTION_DETAIL:
  connection: doctrine
  tableName: RECEPTION_DETAIL
  columns:
    rde_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    rli_num:
      type: float(8)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    art_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rde_num_serie:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rde_lot:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rde_peremption:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
RECEPTION_LIGNE:
  connection: doctrine
  tableName: RECEPTION_LIGNE
  columns:
    rli_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    rec_num:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    emp_cod:
      type: string(13)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tyf_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rli_qte:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rli_prix_achat:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    RECEPTION:
      local: rec_num
      foreign: rec_num
      type: one
    REFERENCE:
      local: ref_cod
      foreign: ref_cod
      type: one
    EMPLACEMENT:
      local: emp_cod
      foreign: emp_cod
      type: one
    TYPE_FACTURATION:
      local: tyf_cod
      foreign: tyf_cod
      type: one
REFERENCE:
  connection: doctrine
  tableName: REFERENCE
  columns:
    ref_cod:
      type: string(20)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    tyf_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fam_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    fou_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_designation:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_description:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_typ:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_ss_typ:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_typ_suivi:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_typ_lot:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_conditionnement:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_seuil_reappro:
      type: float(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_prix_moyen:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_prix_achat:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_capacite:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_kit:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_lien_descriptif:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_lien_reglage:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_lien_photo:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_qte_a_cder:
      type: float(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_actif:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_comptable:
      type: string(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    TYPE_FACTURATION:
      local: tyf_cod
      foreign: tyf_cod
      type: one
    FAMILLE_REF:
      local: fam_cod
      foreign: fam_cod
      type: one
    FOURNISSEUR:
      local: fou_cod
      foreign: fou_cod
      type: one
    ARTICLE:
      local: ref_cod
      foreign: ref_cod
      type: many
    COMMANDE_LIGNE:
      local: ref_cod
      foreign: ref_cod
      type: many
    FICHEREFERENCE:
      local: ref_cod
      foreign: ref_cod
      type: many
    RECEPTION_LIGNE:
      local: ref_cod
      foreign: ref_cod
      type: many
    REGLAGE:
      local: ref_cod
      foreign: ref_cod
      type: many
    REGLAGE_PARAM:
      local: ref_cod
      foreign: ref_cod
      type: many
REGLAGE:
  connection: doctrine
  tableName: REGLAGE
  columns:
    reg_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    ref_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    art_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    reg_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    reg_consigne:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    reg_mod_ventil:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    reg_param:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    reg_unit:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    reg_val:
      type: string(13)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    REFERENCE:
      local: ref_cod
      foreign: ref_cod
      type: one
    ARTICLE:
      local: art_cod
      foreign: art_cod
      type: one
    PATIENT:
      local: pat_cod
      foreign: pat_cod
      type: one
    FICHEREGLAGE:
      local: reg_num
      foreign: reg_num
      type: many
REGLAGE_PARAM:
  connection: doctrine
  tableName: REGLAGE_PARAM
  columns:
    rep_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    ref_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rep_mod_ventil:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rep_param:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rep_unit:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rep_principal:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    REFERENCE:
      local: ref_cod
      foreign: ref_cod
      type: one
REGLAGE_PATIENT:
  connection: doctrine
  tableName: REGLAGE_PATIENT
  columns:
    art_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    rep_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    reg_val:
      type: string(13)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    rep_param:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
      autoincrement: false
    art_num_serie:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    emp_cod:
      type: string(13)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
      autoincrement: false
    ear_lot:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_designation:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_typ:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ref_ss_typ:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    reg_mod_ventil:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    rep_unit:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
REMBOURSEMENT_EDF:
  connection: doctrine
  tableName: REMBOURSEMENT_EDF
  columns:
    edf_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    edf_dat_dem:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    edf_dat_deb:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    edf_dat_fin:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    edf_mnt:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    PATIENT:
      local: pat_cod
      foreign: pat_cod
      type: one
RENTABILITE:
  connection: doctrine
  tableName: RENTABILITE
  columns:
    ren_num:
      type: float(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    pat_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    med_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cen_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ren_typ:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ren_dat_deb:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ren_dat_fin:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ren_ca:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ren_conso:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ren_mat:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ren_int:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ren_nb_sem:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ren_rentabilite:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ren_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ren_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    PATIENT:
      local: pat_cod
      foreign: pat_cod
      type: one
    AGENCE:
      local: age_cod
      foreign: age_cod
      type: one
    MEDECIN:
      local: med_cod
      foreign: med_cod
      type: one
    CENTRE:
      local: cen_cod
      foreign: cen_cod
      type: one
RENTABILITE_PARAMETRE:
  connection: doctrine
  tableName: RENTABILITE_PARAMETRE
  columns:
    ren_prm_age_cod:
      type: string(50)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    ren_prm_dat_deb:
      type: timestamp(16)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    ren_prm_dat_fin:
      type: timestamp(16)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    ren_prm_qui_maj:
      type: string(50)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
RepArticle:
  connection: doctrine
  tableName: rep_article
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    num_parc:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    num_serie:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cod_art:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    typ_fact:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dat_achat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    prix_achat:
      type: decimal(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    etab:
      type: string(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
RepBouteille:
  connection: doctrine
  tableName: rep_bouteille
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    ref_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    lot:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    peremption:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dat_liv:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
RepFournisseur:
  connection: doctrine
  tableName: rep_fournisseur
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    fou_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: true
      primary: false
      autoincrement: false
    fou_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
RepIntervention:
  connection: doctrine
  tableName: rep_intervention
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    pat_cod:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_typ:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
RepIntervention2:
  connection: doctrine
  tableName: rep_intervention2
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    pat_cod:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_typ:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
RepMedecin:
  connection: doctrine
  tableName: rep_medecin
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    numéro:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    nom:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    code:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ville:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'code postal':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    téléphone:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'adresse 1':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'adresse 2':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
RepObservance:
  connection: doctrine
  tableName: rep_observance
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    pat_cod:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_observ_ventil:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_observ_o2:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
RepPatient:
  connection: doctrine
  tableName: rep_patient
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    code:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    nom:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    prénom:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'code tiers':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    réf.:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'c. post':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    ville:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'no immatriculation':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    adresse1:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    adresse2:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'n° téléphone':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'n° fax':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    email:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    naissance:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'type client':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    activité:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    etablissement:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dépot:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    commercial:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'niveau com.':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'code apporteur':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'nom apporteur':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'centre app.':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'mode règl.':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    echéance:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tarif:
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'mode livraison':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    'date fin de droit':
      type: string(255)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
RepPrescription:
  connection: doctrine
  tableName: rep_prescription
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    pat_cod:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dat_deb:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    dat_fin:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    etat_dep:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
RepReference:
  connection: doctrine
  tableName: rep_reference
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    designation:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cod_art:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    nom_fou:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    typ_ref:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    styp_ref:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    typ_suivi:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    typ_lot:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    kit:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    cod_ref:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
RepSaturation:
  connection: doctrine
  tableName: rep_saturation
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    pat_cod:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    pat_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_dat:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_sat_sans_o2:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    int_sat_avec_o2:
      type: decimal(7)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
SSTYPE_REFERENCE:
  connection: doctrine
  tableName: SSTYPE_REFERENCE
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    tyr_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    sty_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    TYPE_REFERENCE:
      local: tyr_cod
      foreign: tyr_cod
      type: one
TECHNICIEN:
  connection: doctrine
  tableName: TECHNICIEN
  columns:
    tec_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    emp_cod:
      type: string(13)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_prenom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_typ:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_carte_carburant:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_carte_sim:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_tel:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_portable:
      type: string(24)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_pc_portable:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_dat_crea:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_qui_crea:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_dat_maj:
      type: timestamp(16)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_qui_maj:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_courriel:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_init:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((0))
      primary: false
      autoincrement: false
  relations:
    EMPLACEMENT:
      local: emp_cod
      foreign: emp_cod
      type: one
    AGENCE:
      local: age_cod
      foreign: age_cod
      type: one
    INTERVENTION:
      local: tec_cod
      foreign: tec_cod
      type: many
    MESSAGE:
      local: tec_cod
      foreign: tec_cod
      type: many
    MESSAGE_7:
      class: MESSAGE
      local: tec_cod
      foreign: tec_codtechnicien
      type: many
    MESSAGE_8:
      class: MESSAGE
      local: tec_cod
      foreign: tec_codautredestinataire
      type: many
TECHNICIEN_ZONE:
  connection: doctrine
  tableName: TECHNICIEN_ZONE
  columns:
    tez_num:
      type: float(8)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: true
    tec_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tez_zoneg:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
TYPE_ETAT:
  connection: doctrine
  tableName: TYPE_ETAT
  columns:
    id:
      type: integer(8)
      autoincrement: true
      primary: true
    typ_cod:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    typ_lib20:
      type: string(50)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    typ_lg:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    typ_defaut:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    typ_modif:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    typ_actif:
      type: boolean(1)
      fixed: false
      unsigned: false
      notnull: true
      default: ((1))
      primary: false
      autoincrement: false
TYPE_FACTURATION:
  connection: doctrine
  tableName: TYPE_FACTURATION
  columns:
    tyf_cod:
      type: string(20)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    tyf_methode:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    typ_amortissement:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    ARTICLE:
      local: tyf_cod
      foreign: tyf_cod
      type: many
    FOURNISSEUR:
      local: tyf_cod
      foreign: tyf_cod
      type: many
    RECEPTION_LIGNE:
      local: tyf_cod
      foreign: tyf_cod
      type: many
    REFERENCE:
      local: tyf_cod
      foreign: tyf_cod
      type: many
TYPE_INTERVENTION:
  connection: doctrine
  tableName: TYPE_INTERVENTION
  columns:
    tyi_cod:
      type: string(20)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    tyi_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tyi_cod_suivant:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tyi_delai:
      type: float(12)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tyi_comment:
      type: string(500)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tec_typ:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    for_cod:
      type: string(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    INTERVENTION:
      local: tyi_cod
      foreign: tyi_cod
      type: many
    MESSAGE:
      local: tyi_cod
      foreign: tyi_cod
      type: many
TYPE_REFERENCE:
  connection: doctrine
  tableName: TYPE_REFERENCE
  columns:
    tyr_cod:
      type: string(20)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    tyr_prefixe:
      type: string(3)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    tyr_compteur:
      type: integer(4)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    SSTYPE_REFERENCE:
      local: tyr_cod
      foreign: tyr_cod
      type: many
UTILISATEUR:
  connection: doctrine
  tableName: UTILISATEUR
  columns:
    uti_cod:
      type: string(10)
      fixed: false
      unsigned: false
      primary: true
      autoincrement: false
    grp_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    age_cod:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    uti_nom:
      type: string(35)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    uti_login:
      type: string(20)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
    uti_mot_passe:
      type: string(10)
      fixed: false
      unsigned: false
      notnull: false
      primary: false
      autoincrement: false
  relations:
    GROUPE:
      local: grp_cod
      foreign: grp_cod
      type: one
    AGENCE:
      local: age_cod
      foreign: age_cod
      type: one
    MESSAGE:
      local: uti_cod
      foreign: uti_cod
      type: many
    MESSAGE_2:
      class: MESSAGE
      local: uti_cod
      foreign: mes_qui_crea
      type: many
    MESSAGE_3:
      class: MESSAGE
      local: uti_cod
      foreign: mes_qui_maj
      type: many