| INDEX | REVISIONS | OVERVIEW | FIELD SUMMARY | |
| DATATYPES | SQL SUMMARY | TRIGGERS |
| Table : collections |
Collections are non-citable related items such as periodicals and archival collections
See Also:
reference_items
| Field Summary | ||
| Name | Type | Description |
|---|---|---|
| id | Serial | |
| title | Varchar-255 | |
| short_title | Varchar-255 | |
| description | text | |
| collection_type-Id | collection_types(id) | |
| Sql Summary | |||||||
| Name | Type | PrKey | Unq | NotN | MUnq | Def | Idx1 |
|---|---|---|---|---|---|---|---|
| id | int | |
|
|
|
|
|
| title | varchar(255) | |
|
|
|
|
|
| short_title | varchar(255) | |
|
|
|
|
|
| description | varchar(32,000) | |
|
|
|
|
|
| collection_type-Id | int | |
|
|
|
|
|
| Foreign Keys | |||
| Field | Import | On Update | On Delete |
|---|---|---|---|
| collection_type-Id | collection_types(id) | NO ACTION | NO ACTION |
| INDEX | REVISIONS | OVERVIEW | FIELD SUMMARY | |
| DATATYPES | SQL SUMMARY | TRIGGERS |