columns:
  code:
    type: text
  medecin_reference_code:
    type: text
  medecin_reference_id:
    type: bigint
  medecin_reference_no_adeli:
    type: character varying(30)
  medecin_reference_nom:
    type: character varying(255)
  medecin_reference_nom_prenom:
    type: text
  medecin_reference_prenom:
    type: character varying(255)
  no_adeli:
    type: text
  nom:
    type: text
  nom_prenom:
    type: text
  oid:
    type: bigint
    not_null: NOT NULL
  prenom:
    type: text
  section_code:
    type: 'character varying(40)[]'
  section_id:
    type: 'bigint[]'
  section_texte:
    type: 'character varying(255)[]'
  specialite_id:
    type: bigint
  specialite_interne_id:
    type: bigint
  specialite_interne_medecin_code:
    type: character varying(10)
  specialite_interne_medecin_reference_code:
    type: character varying(10)
  specialite_interne_medecin_reference_id:
    type: bigint
  specialite_interne_medecin_reference_texte:
    type: character varying(255)
  specialite_interne_medecin_texte:
    type: character varying(255)
  specialite_medecin_code:
    type: character varying(10)
  specialite_medecin_reference_code:
    type: character varying(10)
  specialite_medecin_reference_id:
    type: bigint
  specialite_medecin_reference_texte:
    type: character varying(255)
  specialite_medecin_texte:
    type: character varying(255)
constraints:
  t_medecins_c_pkey:
    type: PRIMARY KEY
    column: oid
  t_medecins_c_ukey1:
    type: UNIQUE
    column: code
indexes:
  i_medecins_c_1:
    column: specialite_id
    method: btree
  i_medecins_c_2:
    column: specialite_interne_id
    method: btree
  i_medecins_c_3:
    column: medecin_reference_id
    method: btree
  i_medecins_c_4:
    column: specialite_medecin_reference_id
    method: btree
  i_medecins_c_5:
    column: specialite_interne_medecin_reference_id
    method: btree