ERD_Jeju Air Port
제주공항 설비시스템 구축 DB ERD
테이블 (14)
Alarm (dbo.Alarm)
- AlarmObject — nvarChar(10)
- Description — nvarChar(80)
- AlarmLevelName — nvarChar(10)
- AlmFlagHH — bit — NOT NULL
- AlmFlagH — bit — NOT NULL
- BaseLevelFlag — bit — NOT NULL
- HHLimit — Real
- HLimit — Real
- BaseLevel — Real
- AlarmMessage — nvarChar(80)
AlarmD (dbo.AlarmD)
- TagName (Tagname) — nvarchar(10) — NOT NULL
- PointType — tinyint
- Date — nvarchar(20)
- aValue1 — real
- aStatus1 — tinyint
- aValue2 — real
- aStatus2 — tinyint
- aValue3 — real
- aStatus3 — tinyint
- aValue4 — real
- aStatus4 — tinyint
- aValue5 — real
- aStatus5 — tinyint
AlarmLevel (dbo.AlarmLevel)
- AlarmLevelID — int — NOT NULL
- AlarmLevelName — nvarchar(10) — NOT NULL
- Description — nvarchar(80)
- LevelNumber — smallint
- PrintAlarm — bit — NOT NULL
- PrintReport — bit — NOT NULL
- BeepOnAlarm — bit — NOT NULL
- DisplayPanel — bit — NOT NULL
- DisplayAlarmView — bit — NOT NULL
- FlagAlarmSendAllSystem — bit — NOT NULL
- FlagToSystem — bit — NOT NULL
- FlagToTerminal — bit — NOT NULL
- FlagToPrinter — bit — NOT NULL
CycleD (dbo.CycleD)
- TagName (Tagname) — nvarchar(11) — NOT NULL
- PointType — tinyint
- Date — nvarchar(15)
- aValue1 — real
- aStatus1 — tinyint
- aValue2 — real
- aStatus2 — tinyint
- aValue3 — real
- aStatus3 — tinyint
- aValue4 — real
- aStatus4 — tinyint
- aValue5 — real
- aStatus5 — tinyint
DayD (dbo.DayD)
- TagName (Tagname) — nvarchar(11) — NOT NULL
- PointType — tinyint
- Date — nvarchar(15)
- aValue1 — real
- aStatus1 — tinyint
- aValue2 — real
- aStatus2 — tinyint
- aValue3 — real
- aStatus3 — tinyint
- aValue4 — real
- aStatus4 — tinyint
- aValue5 — real
- aStatus5 — tinyint
Device (dbo.Device)
- DeviceType — nvarchar(11)
- Description — nvarchar(50)
- CommBaudRate — smallInt
- CommRetryCount — smallint
- CommErrCount — smallint
- NodeID — smallint
- CommPortType — smallint
- millisecSP — smallint
- dacqMethod — tinyint
- IpAddress — nvarchar(20)
- ID — int — NOT NULL
Equipment (dbo.Equipment)
- EqNumber — nvarchar(11)
- DeviceName — nvarchar(10)
- Description — nvarchar(50)
- MotorType — bit — NOT NULL
- DiTag1 — nvarchar(10)
- DiTag2 — nvarchar(10)
- AiTag1 — nvarchar(10)
- AiTag2 — nvarchar(10)
- DiValue1 — bit — NOT NULL
- DiValue2 — bit — NOT NULL
- AiValue1 — real
- AiValue2 — real
- Tag1 — nvarchar(10)
- Tag2 — nvarchar(10)
- Tag3 — nvarchar(10)
- Tag4 — nvarchar(10)
- Tag5 (Field) — nvarchar(10)
- Tag6 — nvarchar(10)
- Tag7 — nvarchar(10)
- Tag8 — nvarchar(10)
- Tag9 — nvarchar(10)
- Tag10 — nvarchar(10)
- ID — int — NOT NULL
HisGenDB (dbo.HisGenDB)
- HGenID — tinyint
- HGenName — nvarchar(10)
- HGenDesc — nvarchar(40)
- HGenDType — tinyint
- HGenDSrc — tinyint
- HGenMethod — tinyint
- HGenMinP — tinyint
- HGenHourP — tinyint
HourD (dbo.HourD)
- TagName (Tagname) — nvarchar(11) — NOT NULL
- PointType — tinyint
- Date — nvarchar(15)
- aValue1 — real
- aStatus1 — tinyint
- aValue2 — real
- aStatus2 — tinyint
- aValue3 — real
- aStatus3 — tinyint
- aValue4 — real
- aStatus4 — tinyint
- aValue5 — real
- aStatus5 — tinyint
MonthD (dbo.MonthD)
- TagName (Tagname) — nvarchar(11) — NOT NULL
- PointType — tinyint
- Date — nvarchar(15)
- aValue1 — real
- aStatus1 — tinyint
- aValue2 — real
- aStatus2 — tinyint
- aValue3 — real
- aStatus3 — tinyint
- aValue4 — real
- aStatus4 — tinyint
- aValue5 — real
- aStatus5 — tinyint
Point (dbo.Point)
- TagName — nvarchar(10) — NOT NULL
- Description — nvarchar(80)
- PointType — smallint
- EngineeringUnit — nvarchar(10)
- MeasureOnOff — smallint
- AlarmCapability — smallint
- DataPrototype — smallint
- DataImaginaryPart — smallint
- DataRealPart — smallint
- ChannelNumber — nvarchar(10)
- UnitNumber — smallint
- DeviceType — nvarchar(10)
- Polarity — smallint
- Threshold — smallint
- ConScaleMin — smallint
- ConScaleMax — smallint
- AlarmObject — nvarchar(10)
- cHGenID — tinyint
- hHGenID — tinyint
- dHGenID — tinyint
- mHGenID — tinyint
- ReccordNumber — int — NOT NULL
Security (dbo.Security)
- UserID — nvarchar(10) — NOT NULL
- FullName — nvarchar(20)
- Password — nvarchar(10)
- SecurityLevel — nvarchar(20)
- LogOnProgram — nvarchar(50)
- LogOffProgram — nvarchar(50)
- SocialSecurity — nvarchar(14)
- Address — nvarchar(60)
- OfficePhone — nvarchar(13)
- HomePhone — nvarchar(13)
- ExmployeeNumber — nvarchar(10)
- Title — nvarchar(40)
SpuPoint (dbo.SpuPoint)
- TagName — nvarchar(10) — NOT NULL
- Description — nvarchar(80)
- PointType — smallint
- MeasureOnOff — smallint
- AlarmCapability — smallint
- DataPrototype — smallint
- DataImaginaryPart — smallint
- DataRealPart — smallint
- ChannelNumber — nvarchar(10)
- UnitNumber — smallint
- DeviceType — nvarchar(10)
- Polarity — smallint
- ConScaleMin1 — smallint
- ConScaleMax1 — smallint
- ConScaleMin2 — smallint
- ConScaleMax2 — smallint
- ConScaleMin3 — smallint
- ConScaleMax3 — smallint
- ConScaleMin4 — smallint
- ConScaleMax4 — smallint
- ConScaleMin5 — smallint
- ConScaleMax5 — smallint
- AlarmObject1 — nvarchar(10)
- AlarmObject2 — nvarchar(10)
- AlarmObject3 — nvarchar(10)
- AlarmObject4 — nvarchar(10)
- AlarmObject5 — nvarchar(10)
- cHGenID — tinyint
- hHGenID — tinyint
- dHGenID — tinyint
- mHGenID — tinyint
- ReccordNumber — int — NOT NULL
System (dbo.System)
- SysName — nvarchar(80)
- SysDescription — nvarchar(80)
- NodeLocation — nvarchar(50)
- NodeType — nvarchar(10)
- NodeInformation — nvarchar(255)
- CycleDataTime — smallint
- HourlyDataTime — smallint
- DailyDataTime — smallint
- MonthlyDataTime — smallint