• State Verified Answer
  • Locked Locked
  • Replies 4 replies
  • Subscribers 96 subscribers
  • Views 3882 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Schema Extension across tables - 7.1.1

kinshasa
over 6 years ago

Hi Experts,

Is it possible to apply the same schema extensions to multiple tables, or does each have to be done one table at a time? Typica use case here is extending both ShoppingCartItem and PersonWantsOrg. I need to make about 20 extensions on each table and typing each column by hand with the correct data type is error-prone.

Thanks

Kin

Parents
  • +1 over 6 years ago
    Hi

    If I remember right, you can use UNSItemB for permissions controls for groups and users but if you aren't using it for that, then it includes ten string-based custom attributes. Other tables like UNSAccountBHasUNSItemB map the user to the permissions control.

    If you aren't using UNSItemB, then you can apply similar logic. Create one new table to cover all your additional attributes, including a FK reference to an object key. If you don't place any constraints on it, the one table will cover all your extension attributes on all your tables.
Reply
  • +1 over 6 years ago
    Hi

    If I remember right, you can use UNSItemB for permissions controls for groups and users but if you aren't using it for that, then it includes ten string-based custom attributes. Other tables like UNSAccountBHasUNSItemB map the user to the permissions control.

    If you aren't using UNSItemB, then you can apply similar logic. Create one new table to cover all your additional attributes, including a FK reference to an object key. If you don't place any constraints on it, the one table will cover all your extension attributes on all your tables.
Children
No Data