Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| sip_institution_id | INT | 10 | √ | null |
|
|
|||||
| name | VARCHAR | 80 | null |
|
|
Unique varchar identifier. Previously “id” in SIPconfig.xml |
|||||
| implementation | VARCHAR | 80 | 'ILS' |
|
|
||||||
| checkin | TINYINT | 3 | 1 |
|
|
Previously attribute of “policy” in SIPconfig.xml |
|||||
| checkout | TINYINT | 3 | 1 |
|
|
Previously attribute of “policy” in SIPconfig.xml |
|||||
| offline | TINYINT | 3 | √ | NULL |
|
|
Previously attribute of “policy” in SIPconfig.xml |
||||
| renewal | TINYINT | 3 | 0 |
|
|
Previously attribute of “policy” in SIPconfig.xml |
|||||
| retries | INT | 10 | 5 |
|
|
Previously attribute of “policy” in SIPconfig.xml |
|||||
| status_update | TINYINT | 3 | √ | NULL |
|
|
Previously attribute of “policy” in SIPconfig.xml |
||||
| timeout | INT | 10 | 100 |
|
|
Previously attribute of “policy” in SIPconfig.xml |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| sip_institutions_s_pk | Primary key | Asc | sip_institution_id |
| institution_name | Must be unique | Asc | name |
| PRIMARY | Must be unique | Asc | sip_institution_id |
Relationships
Close relationships within degrees of separation
