Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| item_list_id | INT | 10 | null |
|
|
the item list being shared |
|||||
| borrowernumber | INT | 10 | null |
|
|
the patron that the item list is being shared with |
|||||
| permission | enum('view', 'edit') | 4 | 'view' |
|
|
what level of permission is being granted |
|||||
| created_on | TIMESTAMP | 19 | current_timestamp() |
|
|
when the share was created |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| item_list_shares_s_pk | Primary key | Asc/Asc | item_list_id + borrowernumber |
| ils_patron | Performance | Asc | borrowernumber |
| PRIMARY | Must be unique | Asc/Asc | item_list_id + borrowernumber |
Relationships
Close relationships within degrees of separation
