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 | NUMERIC(4, 0) | NO | Manufacturer Identifier: The unique identifier for the manufacturer. |
|
Mdl Nbr | VARCHAR(75) | NO | Manufacturer Model Number: The manufacturer supplied model number for the equipment. |
|
Operation Group Identifier | Operation Group | VARCHAR(10) | NO | Equipment Category Identifier: The unique identifier for a specific equipment category. |
Equip Subcat Id | 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 | 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 |