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