residuo

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
residuo_fotos.residuo_id residuo_fotos_residuo_id_foreign C
nombre VARCHAR 255 null
fecha DATE 10 null
hora VARCHAR 255 null
descripcion TEXT 65535 null
foto VARCHAR 255 √ null
peso DOUBLE 22 null
almacen_id BIGINT UNSIGNED 20 null
almacen.id residuo_almacen_id_foreign C
user_id BIGINT UNSIGNED 20 null
users.id residuo_user_id_foreign C
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
residuo_almacen_id_foreign Performance Asc almacen_id
residuo_user_id_foreign Performance Asc user_id

Relationships

Close relationships within degrees of separation