Data dictionary index

public.amenagementcyclable Table
Name Data type PK FK UQ Not null Default value Description
id_amenagementcyclable integer ✓ ✓
id_osm character varying(255)
id_local character varying(255)
num_iti character varying(100)
reseau_loc smallint ✓
nom_loc character varying(255)
ame_d smallint ✓
regime_d smallint ✓
sens_d smallint ✓
largeur_d double precision
local_d smallint ✓
ame_g smallint ✓
regime_g smallint ✓
sens_g smallint ✓
largeur_g double precision
local_g smallint ✓
acces_ame smallint ✓
date_maj date
trafic_vit integer
lumiere character varying(4) ✓
d_service character varying(100)
comm text
author character varying(100)
create_date date
modifier character varying(100)
update_date date
source character varying(50)
project_c character varying(50)
ref_geo character varying(50)
geom public.geometry
code_com_d character varying(5) ✓
code_com_g character varying(5) ✓
statut_g smallint ✓
statut_d smallint ✓
revet_d smallint ✓
revet_g smallint ✓
Constraints
Name Type Column(s) References Description
amenagementcyclable_pk PRIMARY KEY id_amenagementcyclable
fk_code_com_d FOREIGN KEY code_com_d public.tr_commune
fk_code_com_g FOREIGN KEY code_com_g public.tr_commune
fk_reseau_loc FOREIGN KEY reseau_loc public.tr_reseau_loc
fk_statut_d FOREIGN KEY statut_d public.tr_statut
fk_statut_g FOREIGN KEY statut_g public.tr_statut
fk_ame_d FOREIGN KEY ame_d public.tr_amenagement
fk_ame_g FOREIGN KEY ame_g public.tr_amenagement
fk_regime_d FOREIGN KEY regime_d public.tr_regime
fk_regime_g FOREIGN KEY regime_g public.tr_regime
fk_sens_d FOREIGN KEY sens_d public.tr_sens
fk_sens_g FOREIGN KEY sens_g public.tr_sens
fk_local_d FOREIGN KEY local_d public.tr_local
fk_local_g FOREIGN KEY local_g public.tr_local
fk_acces_ame FOREIGN KEY acces_ame public.tr_acces_ame
fk_lumiere FOREIGN KEY lumiere public.tr_booleen
fk_revet_d FOREIGN KEY revet_d public.tr_revet
fk_revet_g FOREIGN KEY revet_g public.tr_revet
↑ Index
public.tr_acces_ame Table
Name Data type PK FK UQ Not null Default value Description
id_acces_ame smallint ✓ ✓
label character varying(255)
Constraints
Name Type Column(s) References Description
tr_acces_ame_pk PRIMARY KEY id_acces_ame
↑ Index
public.tr_amenagement Table
Name Data type PK FK UQ Not null Default value Description
id_ame smallint ✓ ✓
label character varying(255)
Constraints
Name Type Column(s) References Description
tr_amenagement_pk PRIMARY KEY id_ame
↑ Index
public.tr_booleen Table
Name Data type PK FK UQ Not null Default value Description
id_booleen character varying(4) ✓ ✓
booleen character varying(36)
Constraints
Name Type Column(s) References Description
tr_booleen_pkey PRIMARY KEY id_booleen
↑ Index
public.tr_commune Table
Name Data type PK FK UQ Not null Default value Description
code_commune character varying(5) ✓ ✓
commune character varying(100) ✓
code_epci character varying(9) ✓
code_dep character varying(3) ✓
code_reg character varying(2) ✓
Constraints
Name Type Column(s) References Description
tr_commune_pkey PRIMARY KEY code_commune
↑ Index
public.tr_local Table
Name Data type PK FK UQ Not null Default value Description
id_local smallint ✓ ✓
label character varying(255)
Constraints
Name Type Column(s) References Description
tr_local_pk PRIMARY KEY id_local
↑ Index
public.tr_regime Table
Name Data type PK FK UQ Not null Default value Description
id_regime smallint ✓ ✓
label character varying(255)
Constraints
Name Type Column(s) References Description
tr_regime_pk PRIMARY KEY id_regime
↑ Index
public.tr_reseau_loc Table
Name Data type PK FK UQ Not null Default value Description
id_reseau_loc smallint ✓ ✓
label character varying(255)
Constraints
Name Type Column(s) References Description
tr_reseau_pk PRIMARY KEY id_reseau_loc
↑ Index
public.tr_revet Table
Name Data type PK FK UQ Not null Default value Description
id_revet smallint ✓ ✓
label character varying(255)
Constraints
Name Type Column(s) References Description
tr_revet_pk PRIMARY KEY id_revet
↑ Index
public.tr_sens Table
Name Data type PK FK UQ Not null Default value Description
id_sens smallint ✓ ✓
label character varying(255)
Constraints
Name Type Column(s) References Description
tr_sens_pk PRIMARY KEY id_sens
↑ Index
public.tr_statut Table
Name Data type PK FK UQ Not null Default value Description
id_statut smallint ✓ ✓
label character varying(255)
Constraints
Name Type Column(s) References Description
tr_statut_pk PRIMARY KEY id_statut
↑ Index