Manufacturer Model 
EntityType  Dependent, Supertype 
Logical Entity Name  Manufacturer Model 
Default Table Name  Mnfctr_Mdl 
Logical Only  NO 
Owner  EQUIP 
Definition 
Manufacturer Model: The master list of equipment produced by the manufacturer.
 
Note 
 

Manufacturer Model Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
Mnfctr Id(PK)(FK)    NUMERIC(4, 0)  NO 
Manufacturer Identifier: The unique identifier for the manufacturer.
 
Mdl Nbr(PK)    VARCHAR(75)  NO 
Manufacturer Model Number: The manufacturer supplied model number for the equipment.
 
Operation Group Identifier(FK)  Operation Group  VARCHAR(10)  NO 
Equipment Category  Identifier: The unique identifier for a specific equipment category.
 
Equip Subcat Id(FK)    VARCHAR(10)  YES 
Equipment Subcategory Identifier:  The unique identifier for an equipment subcategory.
 
Mdl Desc  Description  VARCHAR(255)  YES 
Model Description:  A free form text field used to describe the manufacturer model.
 
Elect Class  Default Text  VARCHAR(50)  YES 
Electrical Class: The electrical classification of the manufacturer model consisting of class, division and group.
 
Unit Cst  Currency  MONEY(18, 0)  YES 
Unit Cost: The original purchase cost of the manufacturer model.
 
Pnl Hght  Dimension  NUMERIC(12, 4)  YES 
Panel Height: The physical rack space required to hold the equipment.  Measured in inches.
 
AC Voltage  Default Text  VARCHAR(50)  YES 
AC Voltage: The AC voltage specified  by the manufacturer for the specific model.  It is measured in volts.
 
AC Cur  Default Text  VARCHAR(50)  YES 
AC Current: The AC current specified  by the manufacturer for the specific model.  Measured in amps.
 
AC Watts  Default Text  VARCHAR(50)  YES 
AC Watts: The AC watts specified by the manufacturer for the specific model.  Measured in Watts.
 
AC VA  Default Text  VARCHAR(50)  YES 
AC VA
 
DC Voltage  Default Text  VARCHAR(50)  YES 
DC Voltage: The DC voltage specified by the manufacturer for the model.  Measured in volts.
 
DC Cur  Default Text  VARCHAR(50)  YES 
DC Current: The DC current specified by the manufacturer for the model.  Measures in amps.
 
Heat Out  Default Text  VARCHAR(50)  YES 
Heat Out: The maximum heat dissipation specified by the manufacturer for the model.  Measured in BTU/hr. 
 
RAD Limit  Default Text  VARCHAR(50)  YES 
Radiation Limit: The radiation limit specified by the manufacturer for the model.
 
Dimensions UOM(FK)    VARCHAR(50)  YES 
Unit of Measure:  A field used to define a unique unit of measure.
 
Width  Dimension  NUMERIC(12, 4)  YES 
Width: The physical width of the equipment.
 
Depth  Dimension  NUMERIC(12, 4)  YES 
Depth: The physical depth of the equipment
 
Height  Dimension  NUMERIC(12, 4)  YES 
Height: The height of the equipment.
 
Length  Dimension  NUMERIC(12, 4)  YES 
Length: The length of the equipment.
 
Wt    NUMERIC(10, 0)  YES 
Weight: The weight of the equipment.
 
Web Addr  URL  VARCHAR(2048)  YES 
Web Site Address:  Contains the internet address for the manufacturer's website for the specific product model.
 
Est Cost  Currency  MONEY(18, 0)  YES 
Estimated Cost:  The estimated cost for the manufacturer model.
 
Shape    VARCHAR(50)  YES 
Shape: 
 
Output UOM    VARCHAR(25)  YES 
Output Unit of Measure:  The scale used when specifying the Output High and Output Low values.
 
Output High    NUMERIC(10, 2)  YES 
Output High:  The range end value for the Input Type.
 
Output Low    NUMERIC(10, 2)  YES 
Output Low:  The starting range value for the Input Type.
 
Input Type    VARCHAR(255)  YES 
Input Type:  The category of input type for the manufacturer model.
 
Tmin  Temperature  NUMERIC(94, 0)  YES 
Minimum Temperature:  Measured in Kelvin.
 
Tmax  Temperature  NUMERIC(94, 0)  YES 
Maximum Temperature:  Measured in Kelvin.
 
Pmax    INTEGER  YES 
Maximum Pressure:  Measured in Pascal
 
Magfld    NUMERIC(12, 6)  YES 
Magnetic Field:  Measured in Telsa
 
Rack Mount Ind  Indicator  CHAR(1)  NO 
Rack Mount Indicator:  Used to identify equipment that is mounted in a rack.  Default is "N".
 

Manufacturer Model Keys 
Key Name  Key Type  Keys 
mnfctr_mdl_pk  PrimaryKey  Mnfctr Id, Mdl Nbr 
equip_mdl_type_rf  Inversion Entry  Operation Group Identifier 
mnfctr_rf  Inversion Entry  Mnfctr Id 

Manufacturer Model Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Equipment Category  Non-Identifying  One To Zero or More    groups  is assigned to  Operation Group Identifier  NO 
Manufacturer  Identifying  One To Zero or More    produces  is produced by  Mnfctr Id  NO 
Equipment Subcategory  Non-Identifying  Zero or One to Zero or More        Operation Group Identifier, Equip Subcat Id  NO 
Unit of Measure  Non-Identifying  Zero or One to Zero or More        Dimensions UOM  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
Ctrls Mnfctr Mdl  Identifying  One To Zero or More          YES 
Magnet Manufacter Model  Identifying  One To Zero or More          YES 
Power Supply Manufacter Model  Identifying  One To Zero or More          YES 
Equipment  Non-Identifying  One To Zero or More          NO 

Manufacturer Model Check Constraints 
Check Constraint Name  CheckConstraint 

Manufacturer Model Object Permissions 

User/Role Name  Grantee Type  Permission Type  Action Type  Is Action Extended  Is System 
Manufacturer Model Security Types 
Name  Current Value 

Manufacturer Model Bound Attachments 
Name  Current Value 

Manufacturer Model Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
EQUIP.Manufacturer Model 
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)
Does Not Exist 
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       

Manufacturer Model Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Equipment 
Logical  Power Supply 

Manufacturer Model Data Movement Rules 
Name  Type  Rule Text/Value