Changeset View
Changeset View
Standalone View
Standalone View
swh/provenance/sql/30-schema.sql
| Show First 20 Lines • Show All 41 Lines • ▼ Show 20 Lines | |||||
| comment on column directory.id is 'Directory internal identifier'; | comment on column directory.id is 'Directory internal identifier'; | ||||
| comment on column directory.sha1 is 'Directory intrinsic identifier'; | comment on column directory.sha1 is 'Directory intrinsic identifier'; | ||||
| comment on column directory.date is 'Latest timestamp for the content in the directory'; | comment on column directory.date is 'Latest timestamp for the content in the directory'; | ||||
| create table revision | create table revision | ||||
| ( | ( | ||||
| id bigserial primary key, -- internal identifier of the revision | id bigserial primary key, -- internal identifier of the revision | ||||
| sha1 sha1_git unique not null, -- intrinsic identifier of the revision | sha1 sha1_git unique not null, -- intrinsic identifier of the revision | ||||
| date timestamptz not null, -- timestamp of the revision | date timestamptz, -- timestamp of the revision | ||||
| origin bigint -- id of the preferred origin | origin bigint -- id of the preferred origin | ||||
| -- foreign key (org) references origin (id) | -- foreign key (org) references origin (id) | ||||
| ); | ); | ||||
| comment on column revision.id is 'Revision internal identifier'; | comment on column revision.id is 'Revision internal identifier'; | ||||
| comment on column revision.sha1 is 'Revision intrinsic identifier'; | comment on column revision.sha1 is 'Revision intrinsic identifier'; | ||||
| comment on column revision.date is 'Revision timestamp'; | comment on column revision.date is 'Revision timestamp'; | ||||
| comment on column revision.origin is 'preferred origin for the revision'; | comment on column revision.origin is 'preferred origin for the revision'; | ||||
| ▲ Show 20 Lines • Show All 77 Lines • Show Last 20 Lines | |||||