TableSpec Guidelines

  • You cannot alter tables created by Blackbaud Product Development. 

  • Be sure to prefix custom table names with the "USR_" prefix (e.g. "USR_CONSTITUENTPARKINGPERMIT"). USR_ is the prefix that is used by Blackbaud Professional Services to ensure there are no future naming conflicts with tables authored by Blackbaud Product Development. Technically, you can use whatever prefix your team devises; just make sure the prefix is consistent.

  • Be sure to provide a consistent Author for all Infinity specs. The author should not be Blackbaud Product Development. For your own custom development you may use any name of your choosing as long as it is consistent and the name is not Blackbaud Product Development.

    Tip: Starting with version 3.0, you can specify a default prefix and default Author attribute when you install the SDK. For information about these option, log in to the SDK downloads page and view the installation instructions.

  • Table names should be capitalized (e.g. "BOOK" instead of "book").

  • Table names should be singular (e.g. "BOOK" instead of "BOOKS").