Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cycler_id | serial | 10 | √ | nextval('cyclers_cycler_id_seq'::regclass) |
|
|
Unique identifier for the cycler instance. Auto-incremented upon insertion. |
|||||||||||||||||||
| cycler_type_id | int4 | 10 | null |
|
|
Refers to the make of the cycler defined in cyclers_meta table. |
||||||||||||||||||||
| sn | text | 2147483647 | √ | null |
|
|
Serial number of the cycler from the manufacturer. |
|||||||||||||||||||
| calibration_date | date | 13 | √ | null |
|
|
Date of last calibration. |
|||||||||||||||||||
| calibration_due_date | date | 13 | √ | null |
|
|
Date of next calibration. |
|||||||||||||||||||
| location | text | 2147483647 | √ | null |
|
|
Lab where cycler is located. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| cyclers_pkey | Primary key | Asc | cycler_id |



