TABLE "public.carpool_tripoffer"
          Column          |     TYPE     |                           Modifiers
--------------------------+--------------+----------------------------------------------------------------
 id                       | INTEGER      | NOT NULL DEFAULT NEXTVAL('carpool_tripoffer_id_seq'::regclass)
 checkpoints              | text         | NOT NULL
 radius                   | INTEGER      | NOT NULL
 driver_km_price          | numeric(5,2) |
 driver_smokers_accepted  | BOOLEAN      |
 driver_pets_accepted     | BOOLEAN      |
 driver_place_for_luggage | BOOLEAN      |
 driver_car_type_id       | INTEGER      |
 driver_seats_available   | INTEGER      |
 route                    | geometry     | NOT NULL
 simple_route             | geometry     | NOT NULL
 direction_route          | geometry     | NOT NULL
 simple_route_proj        | geometry     | NOT NULL
 direction_route_proj     | geometry     | NOT NULL
Indexes:
    "carpool_tripoffer_pkey" PRIMARY KEY, btree (id)
    "carpool_tripoffer_direction_route_id" gist (direction_route)
    "carpool_tripoffer_direction_route_proj_id" gist (direction_route_proj)
    "carpool_tripoffer_driver_car_type_id" btree (driver_car_type_id)
    "carpool_tripoffer_route_id" gist (route)
    "carpool_tripoffer_simple_route_id" gist (simple_route)
    "carpool_tripoffer_simple_route_proj_id" gist (simple_route_proj)
CHECK constraints:
    "carpool_tripoffer_driver_seats_available_check" CHECK (driver_seats_available >= 0)
    "carpool_tripoffer_radius_check" CHECK (radius >= 0)
    "enforce_dims_direction_route" CHECK (st_ndims(direction_route) = 2)
    "enforce_dims_direction_route_proj" CHECK (st_ndims(direction_route_proj) = 2)
    "enforce_dims_route" CHECK (st_ndims(route) = 2)
    "enforce_dims_simple_route" CHECK (st_ndims(simple_route) = 2)
    "enforce_dims_simple_route_proj" CHECK (st_ndims(simple_route_proj) = 2)
    "enforce_geotype_direction_route" CHECK (geometrytype(direction_route) = 'LINESTRING'::text OR direction_route IS NULL)
    "enforce_geotype_direction_route_proj" CHECK (geometrytype(direction_route_proj) = 'LINESTRING'::text OR direction_route_proj IS NULL)
    "enforce_geotype_route" CHECK (geometrytype(route) = 'MULTILINESTRING'::text OR route IS NULL)
    "enforce_geotype_simple_route" CHECK (geometrytype(simple_route) = 'MULTILINESTRING'::text OR simple_route IS NULL)
    "enforce_geotype_simple_route_proj" CHECK (geometrytype(simple_route_proj) = 'MULTILINESTRING'::text OR simple_route_proj IS NULL)
    "enforce_srid_direction_route" CHECK (st_srid(direction_route) = 4326)
    "enforce_srid_direction_route_proj" CHECK (st_srid(direction_route_proj) = 27572)
    "enforce_srid_route" CHECK (st_srid(route) = 4326)
    "enforce_srid_simple_route" CHECK (st_srid(simple_route) = 4326)
    "enforce_srid_simple_route_proj" CHECK (st_srid(simple_route_proj) = 27572)
Foreign-key constraints:
    "carpool_tripoffer_driver_car_type_id_fkey" FOREIGN KEY (driver_car_type_id) REFERENCES carpool_cartype(id) DEFERRABLE INITIALLY DEFERRED
Referenced BY:
    TABLE "carpool_trip" CONSTRAINT "carpool_trip_offer_id_fkey" FOREIGN KEY (offer_id) REFERENCES carpool_tripoffer(id) DEFERRABLE INITIALLY DEFERRED
Triggers:
    proj_route BEFORE INSERT OR UPDATE ON carpool_tripoffer FOR EACH ROW EXECUTE PROCEDURE proj_route()