...
- SELECT original_id FROM originals
- SELECT reference_id FROM binary_refs WHERE original_id = ''
- DELETE FROM url WHERE original_id = ''
- DELETE FROM originals WHERE original_id = ''
- DELETE FROM originals_data WHERE original_id = ''
- DLETE DELETE FROM scaled_... WHERE original_id = ''
...
| Code Block |
|---|
use binaries; CREATE TABLE IF NOT EXISTS binary_refs (reference_id text, original_id text, context text, PRIMARY KEY(reference_id)); CREATE MATERIALIZED VIEW binaryrefs_context AS SELECT context FROM binary_refs WHERE reference_id IS NOT NULL AND context IS NOT NULL PRIMARY KEY(context, reference_id); CREATE MATERIALIZED VIEW binaryrefs_original AS SELECT original_id FROM binary_refs WHERE reference_id IS NOT NULL AND original_id IS NOT NULL PRIMARY KEY(original_id, reference_id); |
| Column / Label | reference_id | original_id | context |
|---|---|---|---|
| Attribute | PRIMARY KEY, Partition Key | ||
| Data Type | text | text | text |
| Description | Die Referenz die benutzt wird um auf die Binaries zuzugreifen | Verweis auf die Id in der Originals-Tabelle | generiert aus dataset-id und revision-id |
...
| Code Block |
|---|
use binaries;
CREATE TABLE IF NOT EXISTS urls (url text, original_id text, PRIMARY KEY(url));
CREATE MATERIALIZED VIEW urls_original AS SELECT original_id FROM urls WHERE url IS NOT NULL AND original_id IS NOT NULL PRIMARY KEY(original_id, url); |
| Column / Label | url | original_id |
|---|---|---|
| Attribute | PRIMARY KEY, Partition Key | |
| Data Type | text | text |
| Description | die URL von der ein Binary geladen wurde | Verweis auf die Id in der Originals-Tabelle |
...