Changeset View
Changeset View
Standalone View
Standalone View
swh/storage/sql/30-swh-schema.sql
| Show First 20 Lines • Show All 232 Lines • ▼ Show 20 Lines | ( | ||||
| type revision_type not null, | type revision_type not null, | ||||
| directory sha1_git, -- source code 'root' directory | directory sha1_git, -- source code 'root' directory | ||||
| message bytea, | message bytea, | ||||
| author bigint, | author bigint, | ||||
| committer bigint, | committer bigint, | ||||
| synthetic boolean not null default false, -- true iff revision has been created by Software Heritage | synthetic boolean not null default false, -- true iff revision has been created by Software Heritage | ||||
| metadata jsonb, -- extra metadata (tarball checksums, extra commit information, etc...) | metadata jsonb, -- extra metadata (tarball checksums, extra commit information, etc...) | ||||
| object_id bigserial, | object_id bigserial, | ||||
| date_neg_utc_offset boolean, | date_neg_utc_offset boolean, -- not null, check 60-swh-indexes.sql | ||||
| committer_date_neg_utc_offset boolean, | committer_date_neg_utc_offset boolean, -- not null, check 60-swh-indexes.sql | ||||
| extra_headers bytea[][] not null -- extra headers (used in hash computation) | extra_headers bytea[][] -- not null, check 60-swh-indexes.sql (this is used in hash computation) | ||||
| ); | ); | ||||
| comment on table revision is 'A revision represents the state of a source code tree at a specific point in time'; | comment on table revision is 'A revision represents the state of a source code tree at a specific point in time'; | ||||
| comment on column revision.id is 'Git-style SHA1 commit identifier'; | comment on column revision.id is 'Git-style SHA1 commit identifier'; | ||||
| comment on column revision.date is 'Author timestamp as UNIX epoch'; | comment on column revision.date is 'Author timestamp as UNIX epoch'; | ||||
| comment on column revision.date_offset is 'Author timestamp timezone, as minute offsets from UTC'; | comment on column revision.date_offset is 'Author timestamp timezone, as minute offsets from UTC'; | ||||
| comment on column revision.date_neg_utc_offset is 'True indicates a -0 UTC offset on author timestamp'; | comment on column revision.date_neg_utc_offset is 'True indicates a -0 UTC offset on author timestamp'; | ||||
| comment on column revision.committer_date is 'Committer timestamp as UNIX epoch'; | comment on column revision.committer_date is 'Committer timestamp as UNIX epoch'; | ||||
| ▲ Show 20 Lines • Show All 248 Lines • Show Last 20 Lines | |||||