I’m stuck! 3 table names.
Schema Master, Schema, Scheme.
They are too confusing for me I always get them mixed up....
Any ideas on how to name better?
I also maybe designing this database incorrectly but I'm really struggling to come up with any other way to handle multiple schemas, especially when custom ones per team will start popping up.
I also want to try and be clever and maybe other the just industry sectors also include
Country > Region A > Region B or maybe something like
Equity > Global Equity > European Equity > Germany Equity.
I'm working in MSSQL.
BICs GICs ICB
GICS Level 1, parent - NULL GICS Level 2, parent - GICS Level 1 etc...
GICS, Level 1, energy, parent - NULL GICS, Level 2, coal, parent - energy
This is a diagram for GICS. What i'm trying to avoid is having to design/create a table for each schema and then tables for each level. I think it can be handled using the method above.