--- title: "testicular_volume" description: "The estimated or calculated volume of a testicle." --- The estimated or calculated volume of a testicle. **Purpose.** To record the volume of an individual's testicle. ## Source | Model | Leg | Role | |---|---|---| | `openEHR-EHR-OBSERVATION.testicular_volume.v1` | openEHR | defines this table | ## Columns | Column | Type | Null | Description | Source | |---|---|---|---|---| | `id` | `uuid primary key` | no | Primary key. | — | | `form_id` | `uuid` → [`form`](/docs/tables/form) | no | The form this entry was recorded on. | — | | `form_block_id` | `uuid` | yes | The block within the form, when the entry is bound to one. | — | | `testicle_examined`
`testicle_examined_code`
`testicle_examined_system`
`testicle_examined_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Testicle examined | `/data[at0001]/events[at0002]/data[at0003]/items[at0020]` | | `testicular_volume_magnitude`
`testicular_volume_units` | quantity
`numeric`, `text` | yes | Testicular volume | `/data[at0001]/events[at0002]/data[at0003]/items[at0010]` | | `comment` | `text` | yes | Comment | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]` | | `confounding_factors` | `text` | yes | Confounding factors | `/data[at0001]/events[at0002]/state[at0011]/items[at0012]` | | `method`
`method_code`
`method_system`
`method_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Method | `/protocol[at0006]/items[at0013]` | | `formula` | `text` | yes | Formula | `/protocol[at0006]/items[at0008]` | ## Constraints ```sql check ((testicle_examined_code is null and testicle_examined_system is null and testicle_examined_valueset_id is null) or (testicle_examined is not null and testicle_examined_code is not null and testicle_examined_system is not null and testicle_examined_valueset_id is not null)) check ((testicular_volume_magnitude is null and testicular_volume_units is null) or (testicular_volume_magnitude is not null and testicular_volume_units is not null)) check (testicular_volume_magnitude is null or (testicular_volume_units = 'ml' and testicular_volume_magnitude >= 0) or (testicular_volume_units = 'cm3' and testicular_volume_magnitude >= 0)) check ((method_code is null and method_system is null and method_valueset_id is null) or (method is not null and method_code is not null and method_system is not null and method_valueset_id is not null)) ``` ## Unique - `form_block_id` ## References | Columns | Target | On delete | |---|---|---| | `form_id` | [`form`](/docs/tables/form) | cascade | | `form_id, form_block_id` | [`form_block`](/docs/tables/form_block) | cascade | | `testicle_examined_valueset_id, testicle_examined_code, testicle_examined_system, testicle_examined` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `method_valueset_id, method_code, method_system, method` | [`valueset_code`](/docs/tables/valueset_code) | restrict | ## Referenced by - [`testicular_volume_device`](/docs/tables/testicular_volume_device) via `testicular_volume_id` ## Indexes - `testicular_volume_form_id_idx` on `form_id` ## Child tables 1 table hang off `testicular_volume`, one row per repetition. ### `testicular_volume_device` Child table — one row per repetition, deleted with its parent. | Column | Type | Null | Description | Source | |---|---|---|---|---| | `id` | `uuid primary key` | no | Primary key. | — | | `testicular_volume_id` | `uuid` → [`testicular_volume`](/docs/tables/testicular_volume) | no | — | — | | `position` | `integer` | no | Order of this row within its parent, from zero. | — | | `device_id` | `uuid` | no | Device | `/protocol[at0006]/items[at0007]` | #### Unique - `testicular_volume_id, position` - `testicular_volume_id, device_id` #### References | Columns | Target | On delete | |---|---|---| | `testicular_volume_id` | [`testicular_volume`](/docs/tables/testicular_volume) | cascade | | `device_id` | [`device`](/docs/tables/device) | no action | #### Indexes - `testicular_volume_device_device_id_idx` on `device_id` ## Value sets | Value set | Codes | |---|---| | `org.openehr::openEHR-EHR-OBSERVATION.testicular_volume.v1/testicle_examined` | 2 |