...
| Code Block |
|---|
use binaries;
CREATE TABLE IF NOT EXISTS originals (original_id text, last_modified timestamp, e_tag text, mime text, created timestamp, checksum text, status text, PRIMARY KEY(original_id)); |
| Column / Label | original_id | last_modified | e_tag | mime | created | checksum | status |
|---|---|---|---|---|---|---|---|
| Attribute | PRIMARY KEY, Partition Key | ||||||
| Data Type | text | timestamp | text | text | timestamp | text | text |
| Description | Last Modified Datum aus dem Response Header des Servers | E-Tag aus dem Response Header des Servers | Mime-Type des Binaries | Zeitstempel der den Zeitpunkt des Speicherns der Daten angibt. | Aus den Daten errechnete Prüfsumme | Status des Download-Prozesses ( OK | ERROR | RETRY ) |
URLs (urls)
| 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); |
...