Changeset View
Changeset View
Standalone View
Standalone View
swh/indexer/sql/30-swh-schema.sql
Show First 20 Lines • Show All 120 Lines • ▼ Show 20 Lines | create table revision_metadata( | ||||
indexer_configuration_id bigint not null | indexer_configuration_id bigint not null | ||||
); | ); | ||||
comment on table revision_metadata is 'metadata semantically detected and translated in a revision'; | comment on table revision_metadata is 'metadata semantically detected and translated in a revision'; | ||||
comment on column revision_metadata.id is 'sha1_git of revision'; | comment on column revision_metadata.id is 'sha1_git of revision'; | ||||
comment on column revision_metadata.translated_metadata is 'result of detection and translation with defined format'; | comment on column revision_metadata.translated_metadata is 'result of detection and translation with defined format'; | ||||
comment on column revision_metadata.indexer_configuration_id is 'tool used for detection'; | comment on column revision_metadata.indexer_configuration_id is 'tool used for detection'; | ||||
create table origin_metadata_translation( | create table origin_intrinsic_metadata( | ||||
moranegg: the comment here is not correct.
You should delete it or change it to the PK you are using.
In… | |||||
id bigserial not null, -- PK origin_metadata identifier | origin_id bigserial not null, | ||||
result jsonb, | metadata jsonb, | ||||
tool_id bigint | indexer_configuration_id bigint not null, | ||||
from_revision sha1_git not null | |||||
); | ); | ||||
comment on table origin_metadata_translation is 'keeps translated for an origin_metadata entry'; | comment on table origin_intrinsic_metadata is 'keeps intrinsic metadata for an origin'; | ||||
comment on column origin_metadata_translation.id is 'the entry id in origin_metadata'; | comment on column origin_intrinsic_metadata.origin_id is 'the entry id in origin'; | ||||
comment on column origin_metadata_translation.result is 'translated_metadata result after translation with tool'; | comment on column origin_intrinsic_metadata.metadata is 'metadata extracted from a revision'; | ||||
comment on column origin_metadata_translation.tool_id is 'tool used for translation'; | comment on column origin_intrinsic_metadata.indexer_configuration_id is 'tool used to generate this metadata'; | ||||
comment on column origin_intrinsic_metadata.from_revision is 'sha1 of the revision this metadata was copied from.'; | |||||
Done Inline Actionsthe grammar of this comment is weird, perhaps something is missing? Also, we don't care they are translated metadata, that notion should just disappear from the DB and its documentation :-)) zack: the grammar of this comment is weird, perhaps something is missing?
Also, we don't care they… |
the comment here is not correct.
You should delete it or change it to the PK you are using.
In this diff the PK is <origin_id, tool_id> if you are sticking with that