pggeodb.nancy.inrae.fr/db_arboretum

Table: edge_data

Schema

placeautopo

Owner

albenard

Tablespace

(default)

Descriptions

There is no description for table edge_data

Columns

Foreign Keys

Check Constraints

There are no check constraints for table edge_data

Indices

Triggers

There are no triggers for table edge_data

Rules

There are no rules for table edge_data

Policies

There are no policies for table edge_data

Referenced

Properties

Definition

CREATE TABLE placeautopo.edge_data (
 edge_id SERIAL,
 start_node INTEGER NOT NULL,
 end_node INTEGER NOT NULL,
 next_left_edge INTEGER NOT NULL,
 abs_next_left_edge INTEGER NOT NULL,
 next_right_edge INTEGER NOT NULL,
 abs_next_right_edge INTEGER NOT NULL,
 left_face INTEGER NOT NULL,
 right_face INTEGER NOT NULL,
 geom public.geometry,
 CONSTRAINT edge_data_pkey PRIMARY KEY(edge_id),
 CONSTRAINT end_node_exists FOREIGN KEY (end_node)
   REFERENCES placeautopo.node(node_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT left_face_exists FOREIGN KEY (left_face)
   REFERENCES placeautopo.face(face_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT next_left_edge_exists FOREIGN KEY (abs_next_left_edge)
   REFERENCES placeautopo.edge_data(edge_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   DEFERRABLE
   INITIALLY DEFERRED,
 CONSTRAINT next_right_edge_exists FOREIGN KEY (abs_next_right_edge)
   REFERENCES placeautopo.edge_data(edge_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   DEFERRABLE
   INITIALLY DEFERRED,
 CONSTRAINT right_face_exists FOREIGN KEY (right_face)
   REFERENCES placeautopo.face(face_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT start_node_exists FOREIGN KEY (start_node)
   REFERENCES placeautopo.node(node_id)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

CREATE INDEX edge_end_node_idx ON placeautopo.edge_data
 USING btree (end_node);

CREATE INDEX edge_gist ON placeautopo.edge_data
 USING gist (geom public.gist_geometry_ops_2d);

CREATE INDEX edge_left_face_idx ON placeautopo.edge_data
 USING btree (left_face);

CREATE INDEX edge_right_face_idx ON placeautopo.edge_data
 USING btree (right_face);

CREATE INDEX edge_start_node_idx ON placeautopo.edge_data
 USING btree (start_node);

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23