Modeler: 11/OtftEditor

From CaseTalk Wiki
Jump to: navigation, search

Object Type / Fact Type Editor

OtftEditor11.png

The dialog allows editing various default properties of Object/Fact Types.

  • Name (Object/Fact/Label Type name)
  • Schema (Names must be unique in combination with this Schema Name)
  • Plural (Plural Name)
  • Abbreviation (Abbreviated Name)
  • Concept (Concept Type can be anything. Default provided are: Person, Location, Event, Thing)
  • Aliases (Comma seperated list of Aliases for this OTFT)
  • Comments and other annotations (Comments, and annotations as declared in Custom Attribute Definitions)
  • Supertype, Abstract, Subtype (Specify if the Object Type a Supertype, Subtype or even Abstract.)
  • Derivable (Mark this Object/Fact Type to be derivable.)
  • Transitional (The population may be gathered from various sources, potentially conflicting. The artifacts will add a source_id column to the primary key.)
  • Color and Background (Visual colors for personal use.)
  • Task (The lifecycle specifier for this OTFT: Conceive, Plan, Develop, Qualify, Launch, Deliver, Retire)
  • Temporal (Specify which temporal aspects are relevant: Valid Time, Transaction Time or Both.)
  • Reducable (Modeler option to specify if this OTFT could, should, must be reduced during model transformation.)
  • Generate Artificial Key (In the artifact this Type is required to be identifier using an artificial key. The natural key will become an alternate key.)
  • Static Population (The population is considered to be static, as in a reference table.)
  • Estimated Tuples (Estimated amount of tuples in the final artifact.)

Label Type Editor

Label Types contain different settings and this same dialog is presented differently for them:

LabelEditor11.png

The dialog for Label Types is slightly different, it lacks a few from the Object/Fact Type mode, and adds the following:

  • Datatype Name (The datatype name can be specified using the ellipses button. This enables supporting datatypes from different artifacts.)
  • Length
  • Precision
  • Localize (If set, the artifact will provide an additional database table to allow production data to be translated using a locale identifier. This is typically used for multi-lingual websites where product_name might need to be notated in various languages.)

Additionally Label Types may contain Value Constraints which limit the valid population.