pc

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
modelo VARCHAR 255 √ null
marca_id BIGINT UNSIGNED 20 √ null
marca.id pc_marca_id_foreign R
ram VARCHAR 255 √ null
procesador VARCHAR 255 √ null
disco_duro VARCHAR 255 √ null
gabinete VARCHAR 255 √ null
fuente_poder VARCHAR 255 √ null
placa_madre VARCHAR 255 √ null
comentario VARCHAR 255 √ null
disponibilidad_id BIGINT UNSIGNED 20 1
disponibilidad.id pc_disponibilidad_id_foreign R
estado_id BIGINT UNSIGNED 20 1
estado.id pc_estado_id_foreign R
almacen_id BIGINT UNSIGNED 20 1
almacen.id pc_almacen_id_foreign R
precio_venta DOUBLE 22 √ null
test BIT 0 0
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
pc_almacen_id_foreign Performance Asc almacen_id
pc_disponibilidad_id_foreign Performance Asc disponibilidad_id
pc_estado_id_foreign Performance Asc estado_id
pc_marca_id_foreign Performance Asc marca_id

Relationships

Close relationships within degrees of separation