Design Device Equipment Assignment: Used for design purposes.  This table is used to associated a device and manufacturer's model for a given location.

Design Device Manufacturer Model Assignment Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Device Identifier		VARCHAR(30)	NO	Device Id: The unique identifier for the device. It is represented in the form of a bar code. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance.
Mnfctr Id		NUMERIC(4, 0)	NO	Manufacturer Identifier: The unique identifier for a manufacturer.
Mdl Nbr		VARCHAR(75)	NO	Manufacturer Model Number: The manufacturer supplied model number for the equipment.
Bldg Id		VARCHAR(10)	YES	Building Code: The unique identifier for a building.
Area Id	Default Text	VARCHAR(50)	YES	Area Identifier: The unique identifier for a location within a building.

Design Device Manufacturer Model Assignment Keys

Key Name	Key Type	Keys
DSGN_DVC_MNFCTR_MDL_ASGN_PK	PrimaryKey	Device Identifier, Mnfctr Id, Mdl Nbr
DSGN_DVC_MNFCTR_MDL_ASGN_UNQ	Alternate Key	Device Identifier

Design Device Manufacturer Model Assignment 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

Design Device Manufacturer Model Assignment Check Constraints

Check Constraint Name

CheckConstraint

Design Device Manufacturer Model Assignment Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Design Device Manufacturer Model Assignment Security Types

Name	Current Value

Design Device Manufacturer Model Assignment Bound Attachments

Name	Current Value

Design Device Manufacturer Model Assignment Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical EPICS.Design Device Manufacturer Model Assignment	NO
ALARM_MYSQL (MySQL) Does Not Exist	NO
ALARM_ORACLE (Oracle) Does Not Exist	NO
BICS (Oracle) Does Not Exist	NO
BLM (Oracle) Does Not Exist	NO
BYPASS_REQ (Oracle) Does Not Exist	NO
CHAN_ARCH (Oracle) Does Not Exist	NO
CNMS_PRPSL (Oracle) Does Not Exist	NO
DIAG (Oracle) Does Not Exist	NO
DIAG_MPS (Oracle) Does Not Exist	NO
ENGA (Oracle) Does Not Exist	NO
EPICS (Oracle) EPICS.DSGN_DVC_MNFCTR_MDL_ASGN	NO
EQUIP (Oracle) Does Not Exist	NO
EXPRESS (Oracle) Does Not Exist	NO
ICS_SFTW_APPL (Oracle) Does Not Exist	NO
INSTR (Oracle) Does Not Exist	NO
Instrument Logbook (Oracle) Does Not Exist	NO
INVT (Oracle) Does Not Exist	NO
IONSRC (Oracle) Does Not Exist	NO
IONSRC1 (Oracle) Does Not Exist	NO
IPTSv5 (Oracle) Does Not Exist	NO
IRMISBase (Oracle) Does Not Exist	NO
Logbook (Oracle) Does Not Exist	NO
Magnet (Oracle) Does Not Exist	NO
MPS (Oracle) Does Not Exist	NO
NS_OPER (Oracle) Does Not Exist	NO
OPER (Oracle) Does Not Exist	NO
PART (Oracle) Does Not Exist	NO
PRINT (Oracle) Does Not Exist	NO
PROC (Oracle) Does Not Exist	NO
PRPSL (Oracle) Does Not Exist	NO
PUBL (Oracle) Does Not Exist	NO
PUBL_V1 (Oracle) Does Not Exist	NO
PV_LOGGER (Oracle) Does Not Exist	NO
SCORE (Oracle) Does Not Exist	NO
SICAT (Oracle) Does Not Exist	NO
SMPL (Oracle) Does Not Exist	NO
SMPLACT (Oracle) Does Not Exist	NO
SURVEY (Oracle) Does Not Exist	NO
Watchman (Oracle) Does Not Exist	NO
XAL_OPTICS (Oracle) Does Not Exist	NO
XF_ADMIN (Oracle) Does Not Exist	NO

Design Device Manufacturer Model Assignment Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	EPICS
EPICS (Oracle)	Main Model

Design Device Manufacturer Model Assignment Data Movement Rules

Name

Type

Rule Text/Value