separating tables

  • sparrow

    sparrow - 2007-12-25

    Hi development team
    3 questions, please
    - what does mean IsPersonal property for an entity?
    - why tinyint type is absent in data type set?
    - is there any way to tell Norma to separate a table that has 1:1 relatioship with another table or is a subtype of another table?

    • Matthew Curland

      Matthew Curland - 2008-01-24

      1) IsPersonal will eventually change some of the verbalization patterns to use 'who' instead of 'that'. For example, a Person EntityType might be marked with 'IsPersonal=true'. This will come into play more with advanced verbalizations that Terry promises to write specs for after his book is done. You should see new verbalizations coming on line very quickly at that point.

      2) It needs to be added. We've added some other ones, no reason to not do this one. It is commonly used. I'll look at getting it in for the next setup drop.

      3) Yes. With the (relatively new) 'Map to Relational Model' extension, you get a new extension property on the Subtype relationship. You can choose to absorb (the default), separate (create a separate table), or partition (if the identifying type has a disjunctive mandatory across all subtypes) to create one table per subtype. Note that the triggers needed in lieu of the foreign keys lost when partitioning is implemented (identifiers are now spread across tables) have not been implemented.



Log in to post a comment.