columns:
|
|
date:
|
|
type: date
|
|
est_ouvert:
|
|
type: character(1)
|
|
default: "'1'::bpchar"
|
|
heberge_ambulatoires:
|
|
type: character(1)
|
|
default: "'1'::bpchar"
|
|
heberge_bebes:
|
|
type: character(1)
|
|
default: "'1'::bpchar"
|
|
heberge_externes:
|
|
type: character(1)
|
|
default: "'1'::bpchar"
|
|
heberge_hospitalises:
|
|
type: character(1)
|
|
default: "'1'::bpchar"
|
|
heberge_seances:
|
|
type: character(1)
|
|
default: "'0'::bpchar"
|
|
heberge_urgences:
|
|
type: character(1)
|
|
default: "'1'::bpchar"
|
|
is_weekend:
|
|
type: character(1)
|
|
jour_semaine:
|
|
type: numeric
|
|
nb_box_ambulatoires_ouverts:
|
|
type: numeric(5,0)
|
|
default: "0"
|
|
nb_box_ambulatoires_theoriques:
|
|
type: numeric(5,0)
|
|
default: "0"
|
|
nb_box_seances_ouverts:
|
|
type: numeric(5,0)
|
|
default: "0"
|
|
nb_box_seances_theoriques:
|
|
type: numeric(5,0)
|
|
default: "0"
|
|
nb_lits_cp_ouverts:
|
|
type: numeric(5,0)
|
|
default: "0"
|
|
nb_lits_cp_theoriques:
|
|
type: numeric(5,0)
|
|
default: "0"
|
|
nb_lits_ouverts:
|
|
type: numeric(5,0)
|
|
default: "0"
|
|
nb_lits_theoriques:
|
|
type: numeric(5,0)
|
|
default: "0"
|
|
parent_id:
|
|
type: bigint
|
|
not_null: NOT NULL
|
|
pole_id:
|
|
type: bigint
|
|
default: "0"
|
|
type_sejour_id:
|
|
type: bigint
|
|
indexes:
|
|
i_places_1:
|
|
column: parent_id
|
|
method: btree
|
|
i_places_2:
|
|
column: date
|
|
method: btree
|
|
i_places_3:
|
|
column: type_sejour_id
|
|
method: btree
|