columns:
  code_original:
    type: text
  date:
    type: date
    not_null: NOT NULL
  date_programmation:
    type: date
    default: "'2099-12-31'::date"
  duree_debordement:
    type: numeric
    default: "0"
  duree_disponible:
    type: numeric
    default: "0"
  duree_occupation:
    type: numeric
    default: "0"
  duree_remise_en_etat:
    type: numeric
    default: "0"
  duree_salle:
    type: numeric
    default: "0"
  duree_total:
    type: numeric
    default: "0"
  finess_id:
    type: bigint
    default: "0"
  heure_debut_occupation:
    type: timestamp without time zone
    default: "'2099-12-31 00:00:00'::timestamp without time zone"
  heure_debut_remise_en_etat:
    type: timestamp without time zone
    default: "'2099-12-31 00:00:00'::timestamp without time zone"
  heure_entree_salle:
    type: timestamp without time zone
    default: "'2099-12-31 00:00:00'::timestamp without time zone"
  heure_fin_occupation:
    type: timestamp without time zone
    default: "'2099-12-31 00:00:00'::timestamp without time zone"
  heure_fin_remise_en_etat:
    type: timestamp without time zone
    default: "'2099-12-31 00:00:00'::timestamp without time zone"
  heure_sortie_salle:
    type: timestamp without time zone
    default: "'2099-12-31 00:00:00'::timestamp without time zone"
  medecin_chirurgien_id:
    type: bigint
    default: "0"
  motif_intervention_id:
    type: bigint
    default: "0"
  no_sejour:
    type: text
    not_null: NOT NULL
  oid:
    type: bigint
    default: "nextval('s_bloc_occupation'::regclass)"
  salle_id:
    type: bigint
  sejour_id:
    type: bigint
  type_mouvement:
    type: text
    default: "''::text"
  type_programmation:
    type: text
    default: "''::text"
  valide:
    type: text
    default: "''::text"
indexes:
  i_bloc_occupation_date_key:
    column: date
    method: btree
  i_bloc_occupation_medecin_chirurgien_id_key:
    column: medecin_chirurgien_id
    method: btree
  i_bloc_occupation_motif_intervention_id_key:
    column: motif_intervention_id
    method: btree
  i_bloc_occupation_no_sejour_id_key:
    column: no_sejour
    method: btree
  i_bloc_occupation_salle_id_key:
    column: salle_id
    method: btree
  i_bloc_occupation_sejour_id_key:
    column: sejour_id
    method: btree