View Source

Binary References (binary_refs)

use binaries;
CREATE TABLE IF NOT EXISTS binary_refs (reference_id text, original_id text, context text, PRIMARY KEY(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

Originals (originals)

use binaries;
CREATE TABLE IF NOT EXISTS originals (original_id text, last_modified timestamp, e_tag text, mime text, checksum text, status text, PRIMARY KEY(original_id));

Column / Label	original_id	last_modified	e_tag	mime	checksum	status
Attribute	PRIMARY KEY, Partition Key
Data Type	text	timestamp	text	text	text	text
Description		Last Modified Datum aus dem Response Header des Servers	E-Tag aus dem Response Header des Servers	Mime-Type des Binaries	Aus den Daten errechnete Prüfsumme	Status des Download-Prozesses ( OK \| ERROR \| RETRY )

URLs (urls)

use binaries;
CREATE TABLE IF NOT EXISTS urls (url text, original_id text, PRIMARY KEY(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

Originals Data (originals_data)

use binaries;
CREATE TABLE IF NOT EXISTS originals_data (original_id text, part int, data blob, PRIMARY KEY(originals_id, part));

Column / Label	original_id	part	data
Attribute	PRIMARY KEY, Partition Key	PRIMARY KEY, Partition Key
Data Type	text	int	blob
Description	Verweis auf die Id in der Originals-Tabelle	Chunk des Binaries	Content des Binary-Chunks

Log (log)

use binaries;
CREATE TABLE IF NOT EXISTS log (reference_id text, timestamp timestamp, message text, PRIMARY KEY(reference_id, timestamp));

Column / Label	reference_id	timestamp	message
Attribute	PRIMARY KEY, Partition Key	PRIMARY KEY, Partition Key
Data Type	text	timestamp	text
Description	Verweis auf die Id in der References-Tabelle	Zeitstempel der Log-Meldung	Content des Binary-Chunks

Scaled images 800 (scaled_800x600)

use binaries;
CREATE TABLE IF NOT EXISTS scaled_800x600 (original_id text, data blob, PRIMARY KEY(originals_id));

Column / Label	original_id	data
Attribute	PRIMARY KEY, Partition Key
Data Type	text	blob
Description	Verweis auf die Id in der Originals-Tabelle	das skalierte Bild

Scaled images 140 (scaled_140x105)

use binaries;
CREATE TABLE IF NOT EXISTS scaled_140x105 (original_id text, data blob, PRIMARY KEY(originals_id));

Column / Label	original_id	data
Attribute	PRIMARY KEY, Partition Key
Data Type	text	blob
Description	Verweis auf die Id in der Originals-Tabelle	das skalierte Bild

Scaled images 116 (scaled_116x87)

use binaries;
CREATE TABLE IF NOT EXISTS scaled_116x87 (original_id text, data blob, PRIMARY KEY(originals_id));

Column / Label	original_id	data
Attribute	PRIMARY KEY, Partition Key
Data Type	text	blob
Description	Verweis auf die Id in der Originals-Tabelle	das skalierte Bild

Scaled images 440 (scaled_440x330)

use binaries;
CREATE TABLE IF NOT EXISTS scaled_440x330 (original_id text, data blob, PRIMARY KEY(originals_id));

Column / Label	original_id	data
Attribute	PRIMARY KEY, Partition Key
Data Type	text	blob
Description	Verweis auf die Id in der Originals-Tabelle	das skalierte Bild