migration_day Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
day_ref		INTEGER	NO
migration_date		DATE	YES
year		NUMERIC(0, 0)	NO
month		NUMERIC(0, 0)	NO
Quarter		VARCHAR(20)	NO
Week		NUMERIC(0, 0)	NO
Day_of_week		VARCHAR(10)	YES

migration_day Keys

Key Name	Key Type	Keys
PK_MIG_DAY	PrimaryKey	day_ref
IDX_MIG_YEAR	Inversion Entry	year
IDX_MIG_DATE	Inversion Entry	migration_date
IDX_MIG_MONTH	Inversion Entry	month
IDX_MIG_QUARTER	Inversion Entry	Quarter
IDX_MIG_WEEK	Inversion Entry	Week
IDX_MIG_DAY_OF_WEEK	Inversion Entry	Day_of_week

migration_day Relationships

Parent Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Migration_event	Non-Identifying	One To Zero or More					NO

migration_day Check Constraints

Check Constraint Name

CheckConstraint

migration_day Security Types

Name	Current Value

migration_day Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical migration_day	NO
BARD - MySQL (MySQL) Does Not Exist	NO
BARD_Dev (Oracle) MIGRATION_DAY	NO
Current Production (Oracle) Does Not Exist	NO

migration_day Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	Migration
BARD_Dev (Oracle)	Main Model
BARD_Dev (Oracle)	Migration