Datamodel
Last updated on 13-Mar-2018 by Thomas P. Boesen
On this page
Record Types
Primary entity
- Sample
- Plate
Associated record
- Attribute
- XRef
- StepInput
Other
- Sequence
Master data
- User
- Project
- Department
Entity Classes
Shared Fields
Description of the individual fields
Tables
Description of the individual tables (in separate page) Description of fields within the tables (in separte pages)
Entity IDs
Prefixes
Custom Entity Classes
Attributes
Foreign Keys and Cross References
Date and Time
Default Entity Types
Sample • Plasmid (mini prep) • PCR
Numeric Columns
Different Databases
| Database | Decimals | Floats | Ints |
|---|---|---|---|
| MS SQL Server | DECIMAL(18,4) | FLOAT | INT |
| Oracle | NUMBER(18,4) | DOUBLE PRECISION | NUMBER(10,0) |
| PostgreSQL | DECIMAL(18,4) | DOUBLE PRECISION | INTEGER |
| MySQL | DECIMAL(18,4) | DOUBLE | INT |