Timeline for How to implement/architect a SQL database schema which can handle types/tables with many optional properties?
Current License: CC BY-SA 4.0
7 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jul 24, 2022 at 5:56 | comment | added | philipxy | @Charlieface Rearranging for subtypes/inheritance is not normalization. | |
Jul 24, 2022 at 4:01 | comment | added | Charlieface |
Most of those columns should probably be normalized out to a separate table called Script or Alphabet . Some of the columns are mutually exclusive, so should probably be a single column of different states. Sounds like you need to read up on normalization.
|
|
Jul 24, 2022 at 2:17 | history | became hot network question | |||
Jul 24, 2022 at 0:19 | vote | accept | Lance Pollard | ||
Jul 24, 2022 at 0:16 | answer | added | J.D. | timeline score: 2 | |
Jul 23, 2022 at 20:08 | answer | added | David Browne - Microsoft | timeline score: 3 | |
Jul 23, 2022 at 18:12 | history | asked | Lance Pollard | CC BY-SA 4.0 |