Changeset View
Changeset View
Standalone View
Standalone View
swh/storage/sql/30-swh-schema.sql
| Show First 20 Lines • Show All 414 Lines • ▼ Show 20 Lines | ( | ||||
| id serial not null, | id serial not null, | ||||
| type text not null, | type text not null, | ||||
| url text not null, | url text not null, | ||||
| metadata jsonb not null | metadata jsonb not null | ||||
| ); | ); | ||||
| comment on table metadata_authority is 'Metadata authority information'; | comment on table metadata_authority is 'Metadata authority information'; | ||||
| comment on column metadata_authority.id is 'Internal identifier of the authority'; | comment on column metadata_authority.id is 'Internal identifier of the authority'; | ||||
| comment on column metadata_authority.type is 'Type of authority (deposit/forge/registry)'; | comment on column metadata_authority.type is 'Type of authority (deposit_client/forge/registry)'; | ||||
| comment on column metadata_authority.url is 'Authority''s uri'; | comment on column metadata_authority.url is 'Authority''s uri'; | ||||
| comment on column metadata_authority.metadata is 'Other metadata about authority'; | comment on column metadata_authority.metadata is 'Other metadata about authority'; | ||||
| -- Extrinsic metadata on a DAG objects and origins. | -- Extrinsic metadata on a DAG objects and origins. | ||||
| create table object_metadata | create table object_metadata | ||||
| ( | ( | ||||
| type text not null, | type text not null, | ||||
| ▲ Show 20 Lines • Show All 68 Lines • Show Last 20 Lines | |||||