Schema reference / Tables / view MDX source

testicular_volume

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`	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

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`	cascade
`form_id, form_block_id`	`form_block`	cascade
`testicle_examined_valueset_id, testicle_examined_code, testicle_examined_system, testicle_examined`	`valueset_code`	restrict
`method_valueset_id, method_code, method_system, method`	`valueset_code`	restrict

Referenced by

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`	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`	cascade
`device_id`	`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