Changeset View
Changeset View
Standalone View
Standalone View
swh/storage/sql/30-swh-schema.sql
| Show First 20 Lines • Show All 430 Lines • ▼ Show 20 Lines | ( | ||||
| -- metadata source | -- metadata source | ||||
| authority_id bigint not null, | authority_id bigint not null, | ||||
| fetcher_id bigint not null, | fetcher_id bigint not null, | ||||
| discovery_date timestamptz not null, | discovery_date timestamptz not null, | ||||
| -- metadata itself | -- metadata itself | ||||
| format text not null, | format text not null, | ||||
| metadata bytea not null | metadata bytea not null, | ||||
| -- context | |||||
| origin text, | |||||
| visit bigint, | |||||
| snapshot swhid, | |||||
| release swhid, | |||||
| revision swhid, | |||||
| path bytea, | |||||
| directory swhid | |||||
| ); | ); | ||||
| comment on table object_metadata is 'keeps all metadata found concerning an object'; | comment on table object_metadata is 'keeps all metadata found concerning an object'; | ||||
| comment on column object_metadata.type is 'the type of object (content/directory/revision/release/snapshot/origin) the metadata is on'; | comment on column object_metadata.type is 'the type of object (content/directory/revision/release/snapshot/origin) the metadata is on'; | ||||
| comment on column object_metadata.id is 'the SWHID or origin URL for which the metadata was found'; | comment on column object_metadata.id is 'the SWHID or origin URL for which the metadata was found'; | ||||
| comment on column object_metadata.discovery_date is 'the date of retrieval'; | comment on column object_metadata.discovery_date is 'the date of retrieval'; | ||||
| comment on column object_metadata.authority_id is 'the metadata provider: github, openhub, deposit, etc.'; | comment on column object_metadata.authority_id is 'the metadata provider: github, openhub, deposit, etc.'; | ||||
| comment on column object_metadata.fetcher_id is 'the tool used for extracting metadata: loaders, crawlers, etc.'; | comment on column object_metadata.fetcher_id is 'the tool used for extracting metadata: loaders, crawlers, etc.'; | ||||
| ▲ Show 20 Lines • Show All 41 Lines • Show Last 20 Lines | |||||