comment: Générée par base.cti_reorganize_codes_postaux_c(''pmsi'')
columns:
  code:
    type: text
  code_geographique_pmsi:
    type: text
    default: "''::text"
  code_geographique_pmsi_code:
    type: text
    default: "''::text"
  code_geographique_pmsi_id:
    type: bigint
    default: "0"
  code_geographique_pmsi_population:
    type: numeric(7,0)
    default: "0"
  code_geographique_pmsi_texte:
    type: text
    default: "''::text"
  code_postal_rattache_code:
    type: text
    default: "''::text"
  code_postal_rattache_id:
    type: bigint
    default: "0"
  code_postal_rattache_texte:
    type: text
    default: "''::text"
  departement_code:
    type: text
    default: "''::text"
  departement_id:
    type: bigint
    default: "0"
  departement_texte:
    type: text
    default: "''::text"
  latitude:
    type: double precision
    default: "0"
  longitude:
    type: double precision
    default: "0"
  oid:
    type: bigint
    not_null: NOT NULL
  population:
    type: numeric(7,0)
    default: "0"
  region_code:
    type: text
    default: "''::text"
  region_id:
    type: bigint
    default: "0"
  region_texte:
    type: text
    default: "''::text"
  secteur_geographique_id:
    type: bigint
    default: "0"
  section_code:
    type: 'text[]'
  section_id:
    type: 'bigint[]'
  section_texte:
    type: 'text[]'
  territoire_sante_code:
    type: text
    default: "''::text"
  territoire_sante_id:
    type: bigint
    default: "0"
  territoire_sante_texte:
    type: text
    default: "''::text"
  texte:
    type: text
  texte_court:
    type: text
constraints:
  t_codes_postaux__c_pkey:
    type: PRIMARY KEY
    column: oid
  t_codes_postaux_c_ukey:
    type: UNIQUE
    column: code
indexes:
  i_codes_postaux_c_0:
    column: oid
    method: btree
  i_codes_postaux_c_1:
    column: code
    method: btree
  i_codes_postaux_c_2:
    column: departement_id
    method: btree
  i_codes_postaux_c_3:
    column: code_geographique_pmsi_id
    method: btree
  i_codes_postaux_c_4:
    column: territoire_sante_id
    method: btree