I am designing a system which stores certain hash values to represent certain pieces of text for example.
Each hash value can represent more than one text file.
I have 4 tables being the details_table,text_table,attribute_table,connector_table.
The attribute_table is laid out as followed:
The details_table is laid out like:
The text_table is laid out like :
And finally the connector_table is laid out like :
The details table contains the hash value. To save time when a hash value is marked as ready to export I would like the associated text rows to also be marked as ready to export how would I do this?
Would I need to add another table with hash status ?
If I use the status related to the text table then when the text fields are exported it would mark the hash as exported and so any new files that had the same hash would be marked as exported.
Its really bugging me as the only way I can see is if I create another table and connect the detail has to it and set the status that way?
If anyone else has anything better or a different solution I would appreciate the guidance?