| Table: citations_sites |
Legend:
Primary key columns
Indexed columns
| Column | Type | Size | Nulls | Auto | Default | References | Comments |
|---|---|---|---|---|---|---|---|
| citation_id | int8 | 19 | χ | χ | |||
| site_id | int8 | 19 | χ | χ | sites.id | ||
| created_at | timestamp | 29,6 | √ | χ | utc_now() | ||
| updated_at | timestamp | 29,6 | √ | χ | utc_now() | ||
| id | bigserial | 19 | χ | √ | nextval('citations_sites_id_seq'::regclass) |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| citation_id + site_id | Must be unique | Asc/Asc | index_citations_sites_on_citation_id_and_site_id |
|
