GPKG_METADATA_REFERENCE top-level constant
String
const GPKG_METADATA_REFERENCE
Implementation
const GPKG_METADATA_REFERENCE = """
CREATE TABLE IF NOT EXISTS $TABLE_METADATA_REFERENCE (
reference_scope TEXT NOT NULL,
table_name TEXT,
column_name TEXT,
row_id_value INTEGER,
timestamp DATETIME NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
md_file_id INTEGER NOT NULL,
md_parent_id INTEGER,
CONSTRAINT crmr_mfi_fk FOREIGN KEY (md_file_id) REFERENCES $TABLE_METADATA(id),
CONSTRAINT crmr_mpi_fk FOREIGN KEY (md_parent_id) REFERENCES $TABLE_METADATA(id)
);
""";