There is a one-to-one relationship between
Aggregation table (an
AggregationId is always a
CodeId. And of course, a
CodeId is unique). Note: A
Code.CodeId doesn't need to be in
There is a one-to-many relationship between
AggregationChildren table (an aggregation will have one or more children).
I think I'm wasting a lot of space repeating a
NVARCHAR(20) data in three tables
By the way, `AggregationChildren.
What do you think?
I think I can delete
AggregationChildren tables.Then, add two new columns to
One to indicate to replace
Another one to replace