Defining a key constraint | Sybase XML specs

Defining identity constraints

Defining a key constraint

A key constraint specifies that an element or an attribute value (or set of values) must be a key within a specified scope.

A key means that data should be unique, not null and always present within a specified scope.

For example:

Generated schema:

The KEYCODE key constraint, defined on the project element, specifies that the code attribute must be unique, not null and always present within the product element.

To display a key property sheet, double-click its name or its icon in the

Browser tree view.

66	PowerDesigner

Image 78

Sybase XML manual Defining a key constraint

Contents

Sybase PowerDesigner 11.1 Last Revised June Contents 101 Managing external shortcuts through references and data100 102 Working with an XML model 139 169 Why reverse engineer an XSD, a DTD or an XDRHow to reverse engineer an XSD, a DTD or an XDR Mapping XML Model objects to OOM objects 171 Exchanging data with databases supporting XML 215 Vii Viii Subject AudienceDocumentation primer Object Oriented Model Getting Started Conceptual Data Model User’s Guide To work with the CDMPhysical Data Model User’s Guide Business Process Model User’s Guide BeforeInsertTrigger template Typographic conventions Bibliography Xii Contents XML Model Basics Functional overview What is an XML model? Demo models About XML Objects in an XML model Tool Object Description XSD Objects in a diagram Tool Element symbol Group symbol Complex type symbol Tool Sequence symbol Choice symbol All symbol All Defining the XML model environment Choosing the XML language of an XML modelNot certified resource file Changing the XML language of an XML model ™ To change the XML language of an XML modelLanguage Description Changes concerning simple and complex types Selecting extended model definitions at model creation Option Description Defining model options XML model extended dependencies ™ To define XML model options Defining the XML model environment Defining an XML model Defining model properties™ To define the properties of an XML model Model General Property Description Model Detail Model Items Button Moves itemTool Tooltip Description Model External Schemas Model Namespaces XML Model Basics Creating an XML model Model Preview Creating an XML model using the New model option ™ To create a new XML model using the New model option Defining an XML model List of templates ™ To open an existing XML model Opening an existing XML modelDetaching an XML model from the workspace ™ To detach an XML model from a workspace Model Saving and closing an XML modelSaving an XML Closing an XML model Defining an XML model Building an XML model XML diagram basics Defining an XML diagram Why build an XML diagram? Creating an XML diagram Group Symbols featureExpand/Expand All/Collapse/Arrange Symbols features Defining elements Defining element properties Element general properties Global and local elements in XDR files Defining elements XDR files Property or Element detail properties Element attributes properties Building an XML model Element constraints properties Element mapping propertiesElement Sources Creating an element Attributes Mapping™ To create an element from the palette Defining elements How to link a child object to an element? Tool Action Result Defining the attributes of an element Pointer indications Building an XML model Attribute general properties Global and local attributes in XDR files Defining attributes Attribute detail properties Attribute values Adding an attribute to an element Element values with XDR™ To add an attribute to an element Modifying element display preferences Linking child elements to a parent elementPreference Description Defining group particles Group particlesGroup particle Value of the order attribute in XDR Group particles properties Items list Creating a group particle ™ To create a group particle from an element property sheet Name and code uniqueness From the palette How to link a child object to a group particle? Clicking an element symbol with the Element tool Defining Any properties Any general properties ™ To create an Any Modifying the Any display preference Defining Any Attribute properties For example Any Attribute general properties Defining identity constraints Defining a unique constraint Unique general properties Unique fields properties Defining a key constraint Defining a keyRef constraint Key general propertiesKey fields properties Defining identity constraints Creating an identity constraint KeyRef general propertiesKeyRef fields properties Defining an identity constraint selector XPath abbreviated syntax Syntax Description Defining selector general properties ™ To display a selector property sheet Defining an identity constraint field Defining field general properties ™ To create an identity constraint field Building an XML model Defining groups Defining a group of elements Defining group properties Groups in DTD and XDR files Creating a group of elements ™ To create a group of elements from the palette Defining groups How to link a child object to a group of elements? Modifying the group display preference Defining a group of attributes Defining attribute group properties Attribute group general properties Attribute group AttributesProperties Creating an attribute group ™ To create an attribute group from the Browser tree view Defining groups References Data types Example of shortcuts through a reference and a data type What is a simple type? Defining simple typesType of derivation Description Creating a simple type Defining simple type propertiesModifying the simple type display preference ™ To create a simple type from the Browser tree view Building an XML model What is a complex type? Defining complex types Defining complex type properties Complex type general properties Complex type detail properties Complex type attributes properties Sources Complex type mapping propertiesComplex Type Icon Tool Description Modifying complex type display preferences Creating a complex type ™ To create a complex type from the palette How to link a child object to a complex type? Pointer indications ™ To create a simple content Defining simple content propertiesSimple content General property ™ To create a complex content Defining complex content propertiesComplex content General properties Derivation in element property sheet Defining derivationsDeriving by extension 102 Defining extension ™ To define a derivation by extension103 Deriving by restriction Restriction on a simple type104 Restriction detail Defining restriction facetsRestriction general 105 Enumerations Facet generalRestriction 106 Restriction patterns 107 Creating a restriction on a simple type ™ To create a restriction on a simple type108 109 110 ™ To create a restriction on a complex type Restriction on a complex typeEnumeration and Pattern facets 111 Deriving by list 112 Deriving by union ™ To define a simple type derivation by list113 ™ To define a simple type derivation by union Union generalUnion types 114 Defining annotations 115 Annotation general property Defining annotation propertiesDefining documentation properties Annotation items properties Documentation general properties Documentation contentDefining application information properties Application information general properties Application information content Creating an annotation118 119 Defining notations Defining notation properties120 Creating a notation ™ To create a notation from the Browser tree view121 122 Defining entitiesDefining entity properties Entity name Reference Value Creating an entity ™ To create an entity from the Browser tree view123 124 Defining import properties Defining import, include and redefineDefining an import Import general Creating an import ™ To create an import from the Browser tree view126 Include general Defining an includeDefining include properties 127 ™ To create an include from the Browser tree view Defining a redefineCreating an include 128 Defining redefine properties Redefine general129 ™ To create a redefine from the Browser tree view Creating a redefineRedefine items 130 131 Defining business rule properties What is a business rule?Defining business rules Business rule general properties 133 Creating a business ruleBusiness rule expression property Type Description Example ™ To create a business rule from the List of Business Rules 134 Applying a business rule to an XML object 135 ™ To apply a business rule to an XML object 136 Column in the List of business rules 137 138 Working with an XML model 139 XML model check options Levels of problem severityChecking an XML model 140 Automatic correction Selecting objects in the diagramXML model object selection in the Check Model 141 Checking an XML model ™ To check an XML model142 Selecting all or clearing all check boxes 143 Dockable result window ™ To display errors and warnings selected in the last checkDisplaying previously applied check options in an XML model 144 Contextual menu Making corrections based on XML model check resultsDisplay the Check toolbar 145 ™ To make manual corrections to an XML model Making manual corrections to an XML modelMaking automatic corrections to an XML model ™ To make automatic corrections to an XML model Existence of particle XML Model objects verified by Check ModelGroup particle check Invalid cardinality Undefined identifier Model checkIdentifier uniqueness Shortcut code uniqueness Missing namespaces Business rule check in an XSMData source check Business rule name and code uniqueness Existence of model File checkData source name and code uniqueness 150 Existence of external file location Entity checkEmbedded file name uniqueness Entity name and code uniqueness Include check Simple type checkComplex type check Element name and code uniqueness Element checkExistence of attribute Undefined type Undefined reference 154 Group check Group name and code uniqueness155 Attribute name and code uniqueness Attribute checkNotation check 156 Undefined notation Attribute group checkNotation name and code uniqueness Attribute group name and code uniqueness Redefine check Undefined schema location and namespaceImport check Existence of attributes Key name and code uniqueness Key checkExistence of component Existence of fields KeyRef check KeyRef name and code uniqueness160 Unique check Unique name and code uniqueness161 Extended object name and code uniqueness Extended object checkExtended link check Extended link name and code uniqueness Restriction check Replication checkExtension check Partial object replication Simple type list check Existence of facet164 Existence of items Simple type union checkAnnotation check 165 Defining data sources in an XML model Mapping objects in an XML modelUnderstanding object mapping 166 ™ To create a data source in an XML model Data source properties in an XML modelCreating a data source in an XML model 167 168 169 Mapping XML Model objects to PDM objectsMapping elements XML Model object PDM object Mapping complex types 170Tool Description Mapping XML Model objects to OOM objects 171XML Model object OOM object Creating a mapping for an XML object ™ To create a mapping for an element172 173 Create From Sources and Generate Mapping tools 174 Modifying the mapping of an attribute ™ To modify the mapping of an attribute175 Move Manipulating XML objects graphicallyLocal objects 176 ™ To convert a local object into a global object Global objectsExample converting a local object into a global object Drag and drop After conversions 178 Comparing and merging XML models 179 180 Generating an XML model from a Physical Data ModelGenerating XML Model objects PDM object Generated object in an XML model Generate new XML Generating and updating an XML modelXML model naming conventions 181 XML model Update existingDefining XML model generation options Clearing the Preserve modifications check box Check model before generation 183 Generating a new XML model from a PDM ™ To generate a new XML model from a PDM184 185 Updating an existing XML modelGenerating an XML model from a package Preserve modifications Result ™ To update an existing XML model by generating from a PDM Preserve modifications186 Merging models 187 Generating an XML model from an Object- Oriented Model 188OOM Object Generated object in an XML model 189 190 191 Generating a new XML model from an OOM ™ To generate a new XML model from an OOM192 193 ™ To update an existing XML model by generating from an OOM 194 195 Creating an XML model report What is a report?Editing an XML model report ™ To create a model report 197 Inserting diagram Language in a template198 199 200 201 Why generate an XDR file? Why generate an XSD file?Why generate a DTD file? Generating an XSD, a DTD or an XDR file Defining generation targets Defining generation parametersCheck model 203 Defining generation tasks Using the Move up or down arrowsDefining generation options 204 205 How to generate an XSD, a DTD or an XDR file?Parameter entities during DTD generation Model targeted with Generated file 206 207 How to reverse engineer an XSD, a DTD or an XDR file? What is reverse engineering?Why reverse engineer an XSD, a DTD or an XDR file? Reverse engineering an XSD, a DTD or an XDR file Reverse engineering to a new XML model Reverse engineering optionsReverse engineering target models Convert Unique References 210 211 Reverse engineering to an existing XML model 212 Auto-layout 213 214 Exchanging data with databases supporting XML 215 Why use XML in databases? 216 Generating an annotated schema for Microsoft SQL Server Mapping XML objects to PDM objects217 218 219 220 221 Extended model definitions 222 Annotated schema preview 223 224 Reinforcing mapping with extended attributes 225 226 Annotation Description 227 228 229 Generating an annotated schema for Oracle ™ To generate an annotated schema for Oracle230 231 232 233 234 235 236 237 Generating a DAD file for IBM DB2™ To generate a DAD file for IBM DB2 Type of storage Type of mapping Description Generating a DAD file for IBM DB2 238 239 240 241 242 DAD file preview 243 244 Extended attribute Description 245 246 247 248 Generating SQL/XML queries ™ To generate SQL/XML queries249 Generating SQL/XML queries 250 251 252 253 254 Generating from an XML model 255 256 Generation basicsTarget models parameters Generation option Description Generating from an XML model 257 258 Why generate an XML model from an XML model? Generating an XML model from an XML model259 Generating an XML model from an XML model 260 Generating a new XML model from an XML model 261 ™ To generate a new XML model from an XML model 262 Updating an existing XML model 263 264 265 266 267 268 XSM User’s Guide 269 XML language UnionUnique XPath Index 271 PowerDesigner 272 273 274 IBM DB2 275 276 277 XML 278