Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| idunit_device | bigserial | 19 | √ | nextval('unit_device_idunit_device_seq'::regclass) |
|
|
|||||
| idunit | int4 | 10 | null |
|
|
||||||
| iddevice | int4 | 10 | null |
|
|
||||||
| start_date | timestamptz | 35,6 | √ | null |
|
|
Vinculation start date |
||||
| end_date | timestamptz | 35,6 | √ | null |
|
|
Vinculation end date |
||||
| started_by_user | varchar | 30 | √ | null |
|
|
Database user session that started the vinculation |
||||
| started_by_app | varchar | 30 | √ | null |
|
|
Database app identifier that started the vinculation |
||||
| ended_by_user | varchar | 30 | √ | null |
|
|
Database user session that ended the vinculation |
||||
| ended_by_app | varchar | 30 | √ | null |
|
|
Database app identifier that ended the vinculation |
||||
| is_active | bool | 1 | null |
|
|
Whether the vinculation is current (active) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| unit_device_pkey | Primary key | Asc | idunit_device |
| idx_unit_device_active | Must be unique | Asc/Asc/Asc | idunit + iddevice + is_active |
| idx_unit_device_idunit | Performance | Asc | idunit |
Relationships
Close relationships within degrees of separation
