| INDEX | REVISIONS | OVERVIEW | FIELD SUMMARY | |
| DATATYPES | SQL SUMMARY | TRIGGERS |
| Table : reference_items |
Reference Items are citable content, and include both parts (articles) and monographs (books)
See Also:
reference_items
locators
identifiers
| Field Summary | ||
| Name | Type | Description |
|---|---|---|
| id | Serial | |
| reference_type_id | reference_types(id) | |
| title | Varchar-255 | |
| year | date | |
| locators_id | locators(id) | |
| description | text | |
| collection_id | collections(id) | |
| container_id | smallint | |
| abstract | text | |
| event_id | events(id) | |
| original_id | reference_items(id) | |
| Sql Summary | |||||||
| Name | Type | PrKey | Unq | NotN | MUnq | Def | Idx1 |
|---|---|---|---|---|---|---|---|
| id | int | |
|
|
|
|
|
| reference_type_id | int | |
|
|
|
|
|
| title | varchar(255) | |
|
|
|
|
|
| year | date | |
|
|
|
|
|
| locators_id | int | |
|
|
|
|
|
| description | varchar(32,000) | |
|
|
|
|
|
| collection_id | int | |
|
|
|
|
|
| container_id | smallint | |
|
|
|
|
|
| abstract | varchar(32,000) | |
|
|
|
|
|
| event_id | int | |
|
|
|
|
|
| original_id | int | |
|
|
|
|
|
| Foreign Keys | |||
| Field | Import | On Update | On Delete |
|---|---|---|---|
| reference_type_id | reference_types(id) | NO ACTION | NO ACTION |
| locators_id | locators(id) | NO ACTION | NO ACTION |
| collection_id | collections(id) | NO ACTION | NO ACTION |
| event_id | events(id) | NO ACTION | NO ACTION |
| original_id | reference_items(id) | NO ACTION | NO ACTION |
| INDEX | REVISIONS | OVERVIEW | FIELD SUMMARY | |
| DATATYPES | SQL SUMMARY | TRIGGERS |