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 |