Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| renewal_id | INT | 10 | √ | null |
|
|
|||||
| checkout_id | INT | 10 | √ | null |
|
|
the id of the checkout this renewal pertains to |
||||
| renewer_id | INT | 10 | √ | null |
|
|
the id of the user who processed the renewal |
||||
| seen | BIT | 0 | √ | 0 |
|
|
boolean denoting whether the item was present or not |
||||
| interface | VARCHAR | 16 | null |
|
|
the interface this renewal took place on |
|||||
| timestamp | TIMESTAMP | 19 | current_timestamp() |
|
|
the date and time the renewal took place |
|||||
| renewal_type | enum('Automatic', 'Manual') | 10 | Manual |
|
|
whether the renewal was an automatic or manual renewal |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | renewal_id |
| renewer_id | Performance | Asc | renewer_id |
Relationships
Close relationships within degrees of separation
