Refactor Database Models in models.py - apply this to patho-webcore branch

[Daniel-VM]

Refactor the database schema in models.py to align with the updated design in the databas diagram io. This involves implementing new models, updating relationships, and ensuring the schema supports efficient queries. Moreover, this changes need to be extended to all project (a separate issue might be required for this specific task).

Summary of database changes made

Enhancements to sample state tracking:

• Create sample state history, that retrieves both sample_state and error_type. #180

Refactor models and relationships of bioinfo_analysis_value & Lineage tables. Goal --> MetadataValues table:

• Implemented a strategy to reduce the number of tables in the interaction between bioinfo_analysis_value and metadata_schema, ensuring value entries in bioinfo_analysis_value are tagged with analysis_date. 🏃🏾 #177
• Eliminated tables and relationships tagged as lineage. #179

Relationship Restructuring:

• Changed the relationship between the Chromosome and OrganismAnnotation tables to many-to-many by introducing an intermediate table.

⚠️ This should be applied to pathoweb-core branch.