cable

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
cable_fotos.cable_id cable_fotos_cable_id_foreign C
compra_cable.cable_id compra_cable_cable_id_foreign R
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
cable_nombre VARCHAR 255 null
cable_precio_unitario DECIMAL 10,2 0.00
cable_precio_final DECIMAL 10,2 0.00
cable_foto VARCHAR 255 √ null
cable_descuento DECIMAL 10,2 0.00
cable_destacado BIT 0 0
comentario TEXT 65535 √ null
descripcion TEXT 65535 √ null
largo DECIMAL 8,2 √ null
test BIT 0 0
peso DECIMAL 8,2 √ null
solicitud_recepcion_id BIGINT UNSIGNED 20 √ null
solicitud_recepcion.id cable_solicitud_recepcion_id_foreign R
disponibilidad_id BIGINT UNSIGNED 20 null
disponibilidad.id cable_disponibilidad_id_foreign R
almacen_id BIGINT UNSIGNED 20 null
almacen.id cable_almacen_id_foreign R
estado_id BIGINT UNSIGNED 20 null
estado.id cable_estado_id_foreign R
marca_id BIGINT UNSIGNED 20 null
marca.id cable_marca_id_foreign R
tipo_entrada_1_id BIGINT UNSIGNED 20 √ null
tipo_entrada.id cable_tipo_entrada_1_id_foreign R
tipo_entrada_2_id BIGINT UNSIGNED 20 √ null
tipo_entrada.id cable_tipo_entrada_2_id_foreign R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cable_almacen_id_foreign Performance Asc almacen_id
cable_disponibilidad_id_foreign Performance Asc disponibilidad_id
cable_estado_id_foreign Performance Asc estado_id
cable_marca_id_foreign Performance Asc marca_id
cable_solicitud_recepcion_id_foreign Performance Asc solicitud_recepcion_id
cable_tipo_entrada_1_id_foreign Performance Asc tipo_entrada_1_id
cable_tipo_entrada_2_id_foreign Performance Asc tipo_entrada_2_id

Relationships

Close relationships within degrees of separation