Changeset View
Changeset View
Standalone View
Standalone View
sql/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: It might be more useful if more explicit
id -> origin_id
*Note that with the… | |||||
id bigserial not null, -- PK origin_metadata identifier | id bigserial not null, -- PK origin_intrinsic_metadata identifier | ||||
Done Inline Actionsyou should delete all translation mentions moranegg: you should delete all `translation` mentions | |||||
Done Inline Actions
Already done vlorentz: > you should delete all translation mentions
Already done | |||||
result jsonb, | result jsonb, | ||||
Not Done Inline Actionssuggestion: result-> revision_metadata ? moranegg: suggestion: result-> revision_metadata ? | |||||
tool_id bigint | tool_id bigint | ||||
Not Done Inline Actionsthe long lasting question, is it a indexer_configuration_tool for origins or the one used on the revision? moranegg: the long lasting question, is it a indexer_configuration_tool for origins or the one used on… | |||||
); | ); | ||||
comment on table origin_metadata_translation is 'keeps translated for an origin_metadata entry'; | comment on table origin_intrinsic_metadata is 'keeps translated for an origin_intrinsic_metadata entry'; | ||||
Done Inline Actionsview comment in 130 moranegg: view comment in 130 | |||||
comment on column origin_metadata_translation.id is 'the entry id in origin_metadata'; | comment on column origin_intrinsic_metadata.id is 'the entry id in origin_intrinsic_metadata'; | ||||
Not Done Inline Actionsnot specific to origin_metadata copy of the most recent revision intrinsic_metadata found with tool moranegg: not specific to origin_metadata
suggestion :
copy of the most recent revision… | |||||
comment on column origin_metadata_translation.result is 'translated_metadata result after translation with tool'; | comment on column origin_intrinsic_metadata.result is 'translated_metadata result after translation with tool'; | ||||
Not Done Inline Actionsdepends on comment in 132 moranegg: depends on comment in 132
is it the tool used for translation or for the detection of the most… | |||||
comment on column origin_metadata_translation.tool_id is 'tool used for translation'; | comment on column origin_intrinsic_metadata.tool_id is 'tool used for translation'; |
It might be more useful if more explicit
id -> origin_id
*Note that with the origin_metadata_translation the id was the object_id of an origin_metadata entry