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

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

Entiey Properties †

General †

No	キーワード	意味
1	Name	Name of the entity.
2	Synonyms	Synonyms for the entity.
3	Synonym to display	Synonym to display for the entity.
4	Preferred Abbreviation	Name that will be used for any corresponding table during forward-engineering if the Use Preferred Abbreviations option is enabled in the Engineering dialog box.
5	Long Name	Long name to be used in entity-name.attribute-name displays.
6	FWD Engineer Strategy	This field is important when you are working with supertype and subtype entities. It defines the strategy of engineering entities to relational model tables:
7	Single Table:	The subtype entity metadata are included in the supertype table. There are no subtype tables.
8	Table per Child:	The supertype entity metadata is included in the subtype tables. There is no supertype table.
9	Table for each Entity:	A separate table is generated for each supertype and subtype entity.
10	Based on Structured Type	If the entity is based on a structured type, select it from the list. The entity will contain the attributes as defined in the structured type.
11	Super Type	If the entity is a subtype, select its supertype from the list. The entity inherits all attributes from the specified supertype.
12	Source:	Description of the source type. Examples: DDL, COBOL Copybook, IDMS Schema
13	Type	Classification type, from the list defined in the General Options. Examples: Fact, Dimension, Logging, Summary, Temporary.
14	Scope	For an entity classified as Temporary, you can specify a scope, such as Session or Application.
15	Allow Type Substitution	For a structured type with Reference disabled, or for a structured type applied to an entity, controls whether a substitutional structured type generation in the DDL is allowed.

↑

Attribute †

Lists the attributes currently defined for the entity.
The properties for each attribute include its name and data type,
and whether it is the primary unique identifier (Primary UID),
a relation unique identifier (Relation UID, comparable to foreign key),
or a required field (M, for mandatory).
To add an attribute, click the Add (+) icon; to delete an attribute,
select it and click the Remove (X) icon;
to view the properties of an attribute,
double-click in the cell to the left of the name.

Oracle SQL Developer では、属性については表示用のシノニムを定義することができません。
これができれば、論理DBのエンティティについて、現地語で書くことができるのですが...。
2つのモデルを多重で管理するしか方法が無いようです。

↑

Unique Identifiers †

Lists the unique identifiers (UIDs) currently defined for the entity.
The properties for each key include its name and whether it is included in the primary unique identifier (PUID).
To make the attribute a unique identifier,
click the Add (+) icon; to make the attribute not a unique identifier,
select it and click the Remove (X) icon;
to view the properties of a unique identifier, double-click its name.

↑

Relations †

Lists any relations associated with the entity,
To view the properties of a relation, double-click its name.

↑

Volume Properties †

No	キーワード	意味
1	Volumes:Minimum:	Minimum data volume for the entity.
2	Volumes: Expected:	Expected or typical data volume for the entity.
3	Volumes: Maximum:	Maximum data volume for the entity.
4	Growth Rate: Percent:	Expected growth rate percentage for the entity, for each period as specified in the next field.
5	Growth Rate: Year/Month/Day:	The period (year, month, or day) to which the expected growth rate applies.
6	Normal Form:	The required normal form (database normalization) for the entity: None, First, Second, Third, or Fourth.
7	Adequately Normalized?:	YES indicates that the model is sufficiently normalized. NO indicates that the model is not sufficiently normalized, and that additional normalization may be required on the relational model

↑

Engineer To †

Enables you to specify the relational models to which this entity should be propagated in forward engineering operations.

Engineer: Controls whether the entity 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