os_supply_items

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_supply_items.PARENT_ITEM_ID FK_SUPPLY_ITEM_PARENT_IDR
os_supply_items.ROOT_ITEM_ID FK_SUPPLY_ITEM_ROOT_IDR
os_supply_shipment_items.ITEM_ID FK_SUPPLY_SHIPMENT_ITEMR
BARCODE VARCHAR 255 null
SUPPLY_ID BIGINT 19 null
os_supplies.IDENTIFIER FK_SUPPLY_ITEMS_SUPPLYR
ENTITY_TYPE VARCHAR 32 √ null
ENTITY_ID BIGINT 19 √ null
CONSUMPTION_DATE TIMESTAMP 19 √ null
DESCRIPTION VARCHAR 255 √ null
REASON VARCHAR 255 √ null
REASON_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_SUPPLY_ITEM_CONSUME_REASONR
CPE_ID BIGINT 19 √ null
catissue_coll_prot_event.IDENTIFIER FK_SUPPLY_ITEM_EVENT_IDR
SR_ID BIGINT 19 √ null
catissue_cp_req_specimen.IDENTIFIER FK_SUPPLY_ITEM_SR_IDR
PARENT_ITEM_ID BIGINT 19 √ null
os_supply_items.IDENTIFIER FK_SUPPLY_ITEM_PARENT_IDR
ROOT_ITEM_ID BIGINT 19 √ null
os_supply_items.IDENTIFIER FK_SUPPLY_ITEM_ROOT_IDR
IS_VIRTUAL BIT 1 √ b'0'
USED_BY BIGINT 19 √ null
catissue_user.IDENTIFIER FK_SUPPLY_ITEMS_USED_BYR
ALT_BARCODE VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_SUPPLY_ITEM_CONSUME_REASON Performance Asc REASON_ID
FK_SUPPLY_ITEM_EVENT_ID Performance Asc CPE_ID
FK_SUPPLY_ITEM_PARENT_ID Performance Asc PARENT_ITEM_ID
FK_SUPPLY_ITEM_ROOT_ID Performance Asc ROOT_ITEM_ID
FK_SUPPLY_ITEM_SR_ID Performance Asc SR_ID
FK_SUPPLY_ITEMS_SUPPLY Performance Asc SUPPLY_ID
FK_SUPPLY_ITEMS_USED_BY Performance Asc USED_BY
OS_SUPPLY_ITEM_ALT_BARCODE_UQ Must be unique Asc ALT_BARCODE
OS_SUPPLY_ITEM_BARCODE_UQ Must be unique Asc/Asc BARCODE + SUPPLY_ID

Relationships

Close relationships within degrees of separation