Entity Functions

Data license: MIT · Data source: jebboone/deitydb

47 rows where function_name = "freshwater"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: confidence, source_id, review_status

CREATE TABLE "entity_functions" (
   [entity_id] TEXT REFERENCES [entities]([entity_id]),
   [function_name] TEXT REFERENCES [functions]([function_name]),
   [confidence] TEXT,
   [rationale] TEXT,
   [source_id] TEXT,
   [review_status] TEXT,
   PRIMARY KEY ([entity_id], [function_name])
);
CREATE INDEX [idx_entity_functions_function_name]
    ON [entity_functions] ([function_name]);
CREATE INDEX [idx_entity_functions_entity_id]
    ON [entity_functions] ([entity_id]);