columns:
  code:
    type: text
  liste_cma:
    type: character(1)
  niveau:
    type: numeric(1,0)
  oid:
    type: bigint
    not_null: NOT NULL
    default: "nextval('s_diagnostics'::regclass)"
  racine_code:
    type: character varying(10)
    default: "''::character varying"
  racine_id:
    type: bigint
    default: "0"
  racine_texte:
    type: character varying(255)
  section_code:
    type: 'text[]'
  section_id:
    type: 'bigint[]'
  section_texte:
    type: 'text[]'
  severite_fg11_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg11_simulation_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg12_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg1311d_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg1311e_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg1311f_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg1311g_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg13_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg2016_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg2017_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg2018_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg2019_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg2020_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg2021_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg2022_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg2023_code:
    type: character(1)
    default: "'0'::bpchar"
  severite_fg2024_code:
    type: character(1)
    default: "'0'::bpchar"
  texte:
    type: character varying(255)
constraints:
  t_diagnostics_pkey:
    type: PRIMARY KEY
    column: oid
  t_diagnostics_ukey1:
    type: UNIQUE
    column: code
indexes:
  i_diagnostics_1:
    column: code
    method: btree
  i_diagnostics_2:
    column: racine_id
    method: btree