This seems to me like a good interview question so I'm kinda ashamed for asking someone else and not trying to figure it out, but databases is not my field. A colleague at work wanted to have fully normalized database schema for mapping enums. The enums represent the domain models of different systems and the goal is to create a bidirectional mapping of data APIs between each software system. So System A may have an API parameter of type enum that can have 3 possible values, System B's API parameter may have an enum with 2 possible values, and System C may have 4 possible values. Not all enums may map but some of them will and there could be a one to many mapping. The actual mappings of enum values needs to user configurable and read in from text file.
via Nathan
No comments:
Post a Comment