DB関連/Oracle SQL Developer Data Modeler/Attribute Properties

Top / DB関連 / Oracle SQL Developer Data Modeler / Attribute Properties

Attribute Properties †

This dialog box displays the properties of an attribute,
which is a component of an entity in the Logical Model.

General †

No	キーワード	意味
1	Name	Name of the attribute.
2	Synonym	Synonym for the attribute.
3	Preferred Abbreviation	Name that will be used for any corresponding table column during forward-engineering if the Use Preferred Abbreviations option is enabled in the Engineering dialog box.
4	Long Name	Long name in the format: entity-name.attribute-name
5	Allow Nulls	Controls whether null values are allowed for the attribute. If this option is enabled, a non-null value is mandatory.
6	Datatype	Enables you to specify a domain, logical type, distinct type, collection type, or structured type as the data type of the attribute. You can click the ellipsis (...) button to specify further details for the selected type.
7	Entity	Name of the entity with which the attribute is associated.
8	Source Name	User-specified name of the source for this attribute.
9	Source Type	Manual, System, Derived, or Aggregate.
10	Formula Description	For a derived or aggregate source type, the formula for the attribute.
11	Scope	For a structured type with Reference enabled, limits the scope by specifying the table in which the type is implemented.
12	Type Substitution	For a structured type with Reference disabled, or for a structured type applied to an entity, controls whether a substitutional structured type is generated in the DDL.

↑

Default and Constraint †

No	キーワード	意味
1	Constraint Name	Name of the constraint.
2	Default Value	Default value for the attribute.
3	Use Domain Constraints	Controls whether the properties defined in Domains Administration for the associated domain are used. If this option is disabled, you can use the remaining fields to specify the database type for the constraint and the ranges or a list of values.
5	Constraint	Enables you to specify a constraint for one or more types of databases.
6	Ranges	Enables you to specify one or more value ranges for the attribute.
7	Value List	Enables you to specify a list of valid values for the attribute.

↑

Permitted Subtypes †

For a structured data type, lists all subtypes for the attribute,
and lets you specify whether each is permitted for the attribute.

↑

Engineer To †

Enables you to specify the relational models to which this attribute should be propagated in forward engineering operations.
Engineer Controls whether the attribute is propagated to the specified Relational Design (model) during forward engineering operations.

↑

Comments in RDBMS †

Comment text to be included in database objects that are generated based on this modeling object.

↑

Impact Analysis Enables †

you to view and specify information to be used by Oracle Warehouse Builder for impact analysis.