Skip to main content

The transported_items Table

Column NameData TypeNullableUpdatableComment
transported_items_idBIGINT NOT NULLNONOPrimary Key
external_manifest_identifierVARCHAR(100)YESYES
inventory_external_identifierVARCHAR(100)YESYES
plant_external_identifierVARCHAR(100)YESYES
descriptionVARCHAR(250)YESYES
product_typeVARCHAR(75)YESYES
medicalVARCHAR(50)YESYES
inventory_typeENUMYESYESClones, Plant, Seed...
strainVARCHAR(100)YESYES
quantityVARCHAR(50)YESYES
uomVARCHAR(50)YESYES
weight_per_unitVARCHAR(50)YESYES
servings_per_unitVARCHAR(50)YESYES
external_identifierVARCHAR(100)YESYES
created_byVARCHAR(35)NONO
created_dateDATENONO
updated_byVARCHAR(35)YESYES
updated_dateDATEYESYES
record_created_byVARCHAR(35)NONO
record_created_dateDATENONO
record_updated_byVARCHAR(35)YESYES
record_updated_dateDATEYESYES
is_deletedENUMYESYESTrue,False
operationENUMYESYESInsert,Update,Delete
error_messageVARCHAR(100)YESYES

Indexes

Index TypeColumn Name
PRIMARY KEYtransported_items_id
INDEXtransported_items_id

Foreign Keys

Source ColumnTarget TableTarget ColumnActions