1--#############################################################################
2-- This SQL script generates the space time vector dataset metadata table.
3--
4-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
5--#############################################################################
6
7CREATE TABLE  stvds_metadata (
8  id VARCHAR NOT NULL,    -- Name of the space-time vector dataset, this is the primary key
9  vector_register VARCHAR,-- The id of the table in which the vector maps are registered for this dataset
10  number_of_maps INTEGER, -- The number of registered vector maps
11  title VARCHAR,          -- Title of the space-time vector dataset
12  description VARCHAR,    -- Detailed description of the space-time vector dataset
13  command VARCHAR,        -- The command that was used to create the space time vector dataset
14  points INTEGER,         -- The number of points accumulated from all registered maps
15  lines INTEGER,          -- The number of lines accumulated from all registered maps
16  boundaries INTEGER,     -- The number of boundaries accumulated from all registered maps
17  centroids INTEGER,      -- The number of centroids accumulated from all registered maps
18  faces INTEGER,          -- The number of faces accumulated from all registered maps
19  kernels INTEGER,        -- The number of kernels accumulated from all registered maps
20  primitives INTEGER,     -- All primitives accumulated (points, lines,boundaries,centroids,faces,kernels)
21  nodes INTEGER,          -- Number of nodes accumulated from all registered maps (topological information)
22  areas INTEGER,          -- The number of areas accumulated from all registered maps (topological information)
23  islands INTEGER,        -- The number of islands accumulated from all registered maps (topological information)
24  holes INTEGER,          -- The number of holes accumulated from all registered maps (topological information)
25  volumes INTEGER,        -- The number of volumes accumulated from all registered maps (topological information)           -- The command that was used to create the space time raster dataset
26  PRIMARY KEY (id)
27);
28
29