Constraints

11 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
address_populations_address_code_fkey
address_populations.address_code
addresses.code
Restrict delete
railway_stations_address_code_fkey
railway_stations.address_code
addresses.code
Restrict delete
schools_address_code_fkey
schools.address_code
addresses.code
Restrict delete
address_households_address_code_fkey
address_households.address_code
addresses.code
Restrict delete
address_ranks_address_code_fkey
address_ranks.address_code
addresses.code
Restrict delete
address_land_prices_address_code_fkey
address_land_prices.address_code
addresses.code
Restrict delete
bus_stops_address_code_fkey
bus_stops.address_code
addresses.code
Restrict delete
geo_addresses_address_code_fkey
geo_addresses.address_code
addresses.code
Restrict delete
bus_line_stops_bus_stop_code_fkey
bus_line_stops.bus_stop_code
bus_stops.code
Restrict delete
bus_line_stops_bus_line_code_fkey
bus_line_stops.bus_line_code
bus_lines.code
Restrict delete
bus_lines_company_code_fkey
bus_lines.company_code
bus_companies.code
Restrict delete

Check Constraints

Table Constraint Name Constraint
spatial_ref_sys spatial_ref_sys_srid_check (((srid > 0) AND (srid <= 998999)))
address_ranks address_ranks_metric_check (((metric)::text = ANY ((ARRAY['population'::character varying, 'household'::character varying, 'area'::character varying, 'population_density'::character varying])::text[])))
address_ranks address_ranks_scope_check (((scope)::text = ANY ((ARRAY['national'::character varying, 'prefecture'::character varying, 'city'::character varying, 'town'::character varying])::text[])))