tool_brickfield_content

0 rows


Description

Content of an area at a particular time (recognised by a hash)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
tool_brickfield_results.contentid toolbricresu_con2_fkR
areaid BIGINT 19 null
tool_brickfield_areas.id toolbriccont_are2_fkR
contenthash VARCHAR 40
iscurrent BIT 1 0
status TINYINT 3 0

0 - needs checking, -1 in progress, 1 checked
timecreated BIGINT 19 null
timechecked BIGINT 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolbriccont_are_ix Performance Asc areaid
toolbriccont_iscare_ix Performance Asc/Asc iscurrent + areaid
toolbriccont_sta_ix Performance Asc status

Relationships

Close relationships within degrees of separation