Hi,
What is the best practice for extending an existing table? Is it possible to add "user-defined" fields to existing tables, (and if so, what are the naming conventions & procedures, etc), or do we need a custom "local table" that has the same key to provide a one-to-one linking between the standard Tessitura table and our local table? If this is the case, then is there any automation provided by the Web API that will return our custom fields, or must I also build local procedures, call those separately, and join the tables logically in code after retrieving the data from the standard Tessitura web API, and our local procedure API call?
One example would be to provide 3 custom fields for the "TR_Facility" table. Tessitura wouldn't use this data anywhere, but we will use it on our web site.
Thank you,
Larry
It's not really kosher to add to existing standard tables. You'll probably want to go the local table route as you said. Although if what you really need is custom content for the web, you may be able to use the existing content fields and specific content types to accomplish the same thing, depending on what it is.