uniqueid

333 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id MEDIUMINT UNSIGNED 8 √ null
hash CHAR 32 √ null
unique_id_users.uniqueid_hash FK_user_hash_to_uid R
uuid VARCHAR 255 null
mem_SerialNumber VARCHAR 255 null
deviceID VARCHAR 255 null
manufacturer VARCHAR 255 null
name VARCHAR 255 null
processorId VARCHAR 255 null
SMBIOSBIOSVersion VARCHAR 255 null
serialNumber VARCHAR 255 null
volumeSerialNumber VARCHAR 255 null
create_time TIMESTAMP 19 current_timestamp()
update_time TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
uid_hash_index Must be unique Asc hash

Relationships

Close relationships within degrees of separation