By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
✓
✓
✓
✓
Item_ID | Item_Name | Item_Type_ID | Item_Brand_ID |
---|---|---|---|
2 | 2 | AA | |
4 | 4 | ||
1 | 1 | A | |
3 | 3 | B | AA |
Class_Auto_ID | Class_Key | Class_ID | Class_Name |
---|---|---|---|
1 | Item_Type | A | A |
3 | Item_Brand | AA | AA |
2 | Item_Type | B | B |
Item_ID | Item_Name | Item_Type_ID | Item_Type_Name | Item_Brand_ID | Item_Brand_Name |
---|---|---|---|---|---|
2 | 2 | AA | |||
4 | 4 | ||||
1 | 1 | A | A | ||
3 | 3 | B | AA | AA |