os_supplies

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_supply_allowed_cps.SUPPLY_ID FK_OS_SUPPLY_CPS_SUPPLY_IDR
os_supply_items.SUPPLY_ID FK_SUPPLY_ITEMS_SUPPLYR
CODE VARCHAR 32 √ null
TYPE_ID BIGINT 19 null
os_supply_types.IDENTIFIER FK_SUPPLY_TYPER
DESCRIPTION VARCHAR 255 √ null
PROCUREMENT_DATE TIMESTAMP 19 CURRENT_TIMESTAMP
PROCURED_QTY DECIMAL 16,6 √ null
AVAILABLE_QTY DECIMAL 16,6 √ null
EXPIRY_DATE TIMESTAMP 19 CURRENT_TIMESTAMP
VENDOR_ID BIGINT 19 null
os_supply_vendors.IDENTIFIER FK_SUPPLY_VENDORR
HAS_ITEMS BIT 1 null
CREATED_BY BIGINT 19 null
catissue_user.IDENTIFIER FK_SUPPLY_CREATORR
CREATION_TIME TIMESTAMP 19 CURRENT_TIMESTAMP
UPDATED_BY BIGINT 19 √ null
catissue_user.IDENTIFIER FK_SUPPLY_UPDATERR
UPDATE_TIME TIMESTAMP 19 √ null
SITE_ID BIGINT 19 √ null
catissue_site.IDENTIFIER FK_SUPPLY_SITER
LOCATION_ID BIGINT 19 √ null
os_supply_locations.IDENTIFIER FK_SUPPLY_LOCATIONR
UTILISATION_SITE_ID BIGINT 19 √ null
catissue_site.IDENTIFIER FK_SUPPLY_UTILISATION_SITER

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
CODE Must be unique Asc CODE
FK_SUPPLY_CREATOR Performance Asc CREATED_BY
FK_SUPPLY_LOCATION Performance Asc LOCATION_ID
FK_SUPPLY_SITE Performance Asc SITE_ID
FK_SUPPLY_TYPE Performance Asc TYPE_ID
FK_SUPPLY_UPDATER Performance Asc UPDATED_BY
FK_SUPPLY_UTILISATION_SITE Performance Asc UTILISATION_SITE_ID
FK_SUPPLY_VENDOR Performance Asc VENDOR_ID

Relationships

Close relationships within degrees of separation