| Table | Description |
|---|---|
| Vertices | Each row represents a vertex of the graph. |
| Edges | Each row represents an edge of the graph. For undirected graph, this table might have duplicate rows. Remove them, using code in Deleting Duplicate Edges Table Rows. |
| Sources | [Required for directed graph, optional for undirected graph.] Vertices to use as sources. By default, all vertices are both sources and targets (that is, the graph is undirected). |
| Targets | [Required for directed graph, optional for undirected graph.] Vertices to use as targets. |
Vertices Schema
| Column | Data Type | Description |
|---|---|---|
| vertex_key_column | Any allowed in PARTITION BY clause | [Column appears once for each specified vertex_key_column.] All or part of unique vertex key. Cannot be NULL. |
Edges Schema
| Column | Data Type | Description |
|---|---|---|
| source_vertex_key_column | Any allowed in PARTITION BY clause | Column appears once for each specified source_vertex_key_column.] All or part of key that identifies source vertex of edge. Must be a vertex_key_column in Vertices table. Cannot be NULL. |
| target_vertex_key_column | Same as source_vertex_key_column | Column appears once for each specified target_vertex_key_column.] All or part of key that identifies target vertex of edge. Must be a vertex_key_column in Vertices table. Cannot be NULL. |
| edge_weight | SMALLINT, INTEGER, or NUMERIC | [Required only for weighted graph.] Edge weight, a positive value. Can be NULL. |
Sources Schema
| Column | Data Type | Description |
|---|---|---|
| source_vertex_key_column | Same as corresponding vertex_key_column in Vertices table | Column appears once for each specified source_vertex_key_column.] All or part of key that identifies source vertex of edge. Must be a vertex_key_column in Vertices table. Cannot be NULL. |
Targets Schema
| Column | Data Type | Description |
|---|---|---|
| target_vertex_key_column | Same as corresponding vertex_key_column in Vertices table | Column appears once for each specified target_vertex_key_column.] All or part of key that identifies target vertex of edge. Must be a vertex_key_column in Vertices table. Cannot be NULL. |