Charges - (New datamodel, part 1) Update database to new structure and naming

[prtandrup]

Description Given changed requirements for the charges datamodel, we need to update the database to cope with this. A new structure and naming convention will be applied here.

Preconditions

• New datamodel is available "on paper" (update: Please see the comments from Michael below)
• As part of #205 it will be determine that the current (in progress) datamodel is still valid. If so, this story can begin.

Notes

• Volt has decided not to touch the current database on [dbo], but add the new datamodel using another schema. This will ensure working software until we are ready to switch to the new schema and delete the [dbo]. Switching and deleting will be done in a later story.

Acceptance criteria AC#1 SQL database on U + T reflects the new datamodel, using a new schema (not dbo) AC#2 SeedData and TestData scripts have been updated to match this as well and can be succesfully executed U + T.

[bemwen]

Quick and dirty drawing

[bemwen]

As per discussion at standup today, the following tables should be removed:

• ChargeType
• ResolutionType
• VATPayerType

[bemwen]

MarketParticipant should be changed as follows to cohere to the new naming and enum strategy:

[lasrinnil]

Implmented and verified on U:

[Mech0z]

Nit: Sometimes Id is written ID other times Id ChargePeriodDetails.Vatclassification should be VatClassification