Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| package_id | varchar | 2147483647 | null |
|
|
|||||||||
| version | varchar | 2147483647 | null |
|
|
|||||||||
| revision | int4 | 10 | null |
|
|
|||||||||
| checksum | varchar | 2147483647 | null |
|
|
|||||||||
| index | int4 | 10 | 0 |
|
|
|||||||||
| file_id | varchar | 2147483647 | null |
|
|
|||||||||
| path | varchar | 2147483647 | √ | null |
|
|
||||||||
| slug | varchar | 2147483647 | null |
|
|
|||||||||
| data_type | varchar | 2147483647 | null |
|
|
OpenAPI / Swagger / MD |
||||||||
| name | varchar | 2147483647 | null |
|
|
|||||||||
| metadata | jsonb | 2147483647 | √ | null |
|
|
||||||||
| title | varchar | 2147483647 | √ | null |
|
|
||||||||
| format | varchar | 2147483647 | √ | null |
|
|
||||||||
| operation_ids | _varchar | 2147483647 | √ | null |
|
|
||||||||
| filename | varchar | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| published_version_revision_content_pk | Primary key | Asc/Asc/Asc/Asc | package_id + version + revision + file_id |
| pvrc_checksum_idx | Performance | Asc | checksum |