AiPipe_Water_v1

테이블 (38)

Curve (Curves)

  • Key (CurveID) — integer — 기본 키 — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 플랜 정보.Key — NOT NULL
  • Field (Curve) — text
  • Field (CurveType) — integer

Hydraulics (HydraulicsOption)

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 플랜 정보.Key — NOT NULL
  • Field (FlowUnit) — integer
  • Field2 (HeadlossFormula) — integer
  • Field3 (SpecificGravity) — real
  • Field4 (RelativeViscosity) — real
  • Field5 (MaximumTrials) — integer
  • Field (Accuracy) — real
  • Field (If_Unbalanced) — integer
  • Field (DetaultPatternID) — integer
  • Field (DemandMultiplier) — real
  • Field (Emitter_Exponent) — real
  • Field (StatusReport) — integer
  • Field (MaxHeadError) — real
  • Field (MaxFlowChange) — real
  • Field (DemandModel) — integer
  • Field (MinimumPressure) — real
  • Field (RequiredPressure) — real
  • Field (PressureExponent) — real
  • Field (CheckFreq) — integer
  • Field (MaxCheck) — integer
  • Field (DampLimit) — integer

Label (Labels)

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 플랜 정보.Key — NOT NULL
  • Field (X) — real
  • Field2 (Y) — real
  • Field (Text) — text

Reaction설정 (ReactionOption)

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 플랜 정보.Key — NOT NULL
  • Field (BulkReactionOrder) — real
  • Field2 (WallReactionOrder) — integer
  • Field3 (GlobalBulkCoeff) — real
  • Field4 (GlobalWallCoeff) — real
  • Field5 (LimitingConcentration) — real
  • Field6 (WallCoeffCorrelation) — real

SourceQuality

  • Key (NodeID) — Integer — 외래 키 → 노드정보.Key — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 노드정보.Key — NOT NULL
  • Field (SourceQuality) — Real
  • Field2 (TimePatternID) — Integer
  • Field3 (SourceType) — int

관로정보 (PipeInfos)

  • Key (LinkID) — integer — 외래 키 → 링크정보.Key — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 링크정보.Key — NOT NULL
  • Field (Roughness) — real
  • Field2 (LossCoeff) — real
  • Field3 (InitialStatus) — integer
  • Field4 (BulkCoeff) — real
  • Field5 (WallCoeff) — real

구역정보 (AreaInfo)

  • Key (AreaID) — integer — 기본 키 — NOT NULL
  • Field (Name) — text
  • Field

노드정보 (NodeInfos)

  • Key (NodeID) — Integer — 기본 키 — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 플랜 정보.Key — NOT NULL
  • Field (NodeName) — text
  • Field (X) — real
  • Field (Y) — real
  • Field (Description) — text
  • Field2 (Tag) — text
  • Field (InitQuality) — real
  • Field2 (SourceQuality) — real
  • Field (HydResult) — integer

디멘드카테고리 (DemandCategories)

  • Key (ID) — 기본 키 — NOT NULL
  • Key (ID2) — Integer — 외래 키 → 절점.Key — NOT NULL
  • Key (NodeID) — Integer — 외래 키 → 절점.Key — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 절점.Key — NOT NULL
  • Field (BaseDemand) — real
  • Field2 (TimePattern) — real
  • Field3 (Category) — real

링크정보 (LinkInfos)

  • Key (LinkID) — integer — 기본 키 — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 플랜 정보.Key — NOT NULL
  • Field (LinkName) — text
  • Field (StartNodeID) — integer
  • Field (EndNodeID) — integer
  • Field (Description) — text
  • Field (Tag) — text
  • Field (Length) — real
  • Field (Diameter) — integer
  • Field (MeterialID) — integer
  • Field (HydResult) — integer

링크좌표 정보 (Link_CoordinateInfos)

  • Key (LinkID) — integer — 외래 키 → 링크정보.Key — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 링크정보.Key — NOT NULL
  • Field (X) — real
  • Field2 (Y) — real
  • Field (GroundLevel) — real
  • Field (PipeLevel) — real
  • Field (Type) — integer

배수지 (Tanks)

  • Key (ID) — Integer — 기본 키 — NOT NULL
  • Key (NodeID) — Integer — 외래 키 → 노드정보.Key — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 노드정보.Key — NOT NULL
  • Field (Elevation) — real
  • Field2 (InitialLevel) — real
  • Field3 (MinimumLevel) — real
  • Field4 (VolumncurveID) — Integer
  • Field5 (CanOverflow) — Integer
  • Field6 (MixingModel) — Integer
  • Field7 (MixingFraction) — real
  • Field8 (Reactioncoeff) — real

밸브 정보 (ValveInfos)

  • Key (LinkID) — integer — 외래 키 → 링크정보.Key — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 링크정보.Key — NOT NULL
  • Field (Type) — integer
  • Field2 (Setting) — real
  • Field3 (LossCoeff) — real
  • Field4 (FixedStatus) — integer

수리해석 결과 (Node_HYDResults)

  • Key (NodeID) — Integer — 외래 키 → 노드정보.Key — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 노드정보.Key — NOT NULL
  • Field (Actural Demand) — real
  • Field2 (Total Head) — real
  • Field3 (Pressure) — real
  • Field6 (Quality) — real
  • Field5 (NetInflow) — real
  • Field4 (Elevation) — real

수리해석 결과 (Link_HydraulicResults)

  • Key (LinkID) — integer — 외래 키 → 링크정보.Key — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 링크정보.Key — NOT NULL
  • Field (Flow) — real
  • Field2 (Velocity) — real
  • Field3 (HeadLoss) — real
  • Field4 (FrictionFactor) — real
  • Field5 (ReactionRate) — real
  • Field6 (Quality) — real
  • Field7 (Status) — real

수요예측량 (ForcastDemand)

  • Key — integer — 기본 키 — NOT NULL
  • Key (AreaID) — integer — 외래 키 → 구역정보.Key — NOT NULL
  • Field

수질 설정 (QualityOption)

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 플랜 정보.Key — NOT NULL
  • Field (Parameter) — integer
  • Field2 (MassUnits) — integer
  • Field3 (RelativeDiffusivity) — real
  • Field4 (TraceNodeID) — integer
  • Field5 (QualityTolerance) — real
  • Field

시간 옵션 (TimeOption)

  • Key — Integer — 기본 키 — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 플랜 정보.Key — NOT NULL
  • Field (TotalDuration) — text
  • Field2 (HydraulicTimeStep) — text
  • Field3 (QualityTimeStep) — text
  • Field4 (PatternTimeStep) — text
  • Field5 (PatternStartTime) — text
  • (ReportingTimeStep) — text
  • Field7 (ReportStartTime) — text
  • Field8 (ClockStartTime) — text
  • Field9 (Statistic) — Integer

작도레이어(기존테이블 점검요망) (LayerItem)

  • Key (LayerID) — INTEGER — 기본 키 — NOT NULL
  • ConditionID — INTEGER — 선형:0, 횡단:1, 종단:2
  • ConditionType — INTEGER — 기본:0, 상세:1, 비고:2, 지간선:3, 관종별:4
  • Name — VARCHAR
  • Use — BOOLEAN
  • LayerColorIndex — INTEGER
  • LayerColor — VARCHAR
  • LayerName — VARCHAR

전기료 옵션 (EnergyOption)

  • Key — integer — 기본 키 — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 플랜 정보.Key — NOT NULL
  • Field (PumpEff) — real
  • Field2 (EnergyPrice) — real
  • Field3 (PricePatternID) — integer
  • Field4 (DemandCharge) — real

절점 (Junctions)

  • Key (ID) — Integer — 기본 키 — NOT NULL
  • Key (NodeID) — Integer — 외래 키 → 노드정보.Key — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 노드정보.Key — NOT NULL
  • Field (Elevation) — real
  • Field2 (BaseDemand) — real
  • Field3 (DemandPatternID)
  • Field5 (EmitterCoeff)

정수지 (Reservoir)

  • Key (ID) — Integer — 기본 키 — NOT NULL
  • Key (NodeID) — Integer — 외래 키 → 노드정보.Key — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 노드정보.Key — NOT NULL
  • Field (TotalHead) — real
  • Field2 (HeadPattern) — text

종단작도조건 (VerticalDrawSettingDatas)

  • Key (VerticalID) — Integer — 기본 키 — NOT NULL
  • GeneralHorizentalScale — INTEGER
  • GeneralVerticalScale — INTEGER
  • GeneralDivide — INTEGER
  • GeneralDivideLength — FLOAT
  • GeneralManhole — INTEGER
  • TableTitleTextSize — FLOAT — 테이블
  • TableContentTextSize — FLOAT
  • TableTitleWidth — FLOAT
  • TableTitleDirection — enum(CreateTitleDirectionTypes)
  • TableTopMargin — FLOAT
  • BoringType — INTEGER
  • PoleWidth — FLOAT
  • PoleType — enum(Pole_Type)
  • PoleHeightInterval — FLOAT
  • Pole_H_IntervalCount — INTEGER
  • PoleRightMargin — FLOAT
  • PoleWorkingAreaHeight — FLOAT
  • PoleRemarkAreaHeight — FLOAT
  • PoleTextSize — FLOAT
  • DrawFlow — enum(ConstructionDirectionType)
  • StationType — enum(StationMarkType)
  • StationCaption1 — VARCHAR
  • StationCaption2 — VARCHAR
  • StationSurveying — FLOAT
  • RemarkTextSize — FLOAT
  • RemarkFlagTextSize — FLOAT
  • RemarkStationFlagTextSize — FLOAT
  • RemarkFlagHeightLimit — INTEGER
  • RemarkFlagHeightLimitValue — FLOAT
  • RemarkFlagType — enum(Flag_Type)
  • RemarkFlagObstructionType — enum(Flag_Type)
  • RemarkSlopeType — enum(Flag_Type)
  • WorkTargetSurveyingStation — INTEGER
  • WorkTargetPipeinNode — INTEGER
  • WorkTargetGroundInflectionPoint — INTEGER
  • OutskirtsApply — INTEGER
  • OutskirtsPosX — FLOAT
  • OutskirtsPosY — FLOAT
  • OutskirtsSizeWidth — FLOAT
  • OutskirtsSizeHeight — FLOAT

종단제원 (VerticalSpec)

  • VerticalSpecID — INTEGER — 기본 키 — NOT NULL
  • VerticalID (VerticalID2) — INTEGER — 외래 키 — NOT NULL
  • StationType — enum(STATION_TYPE)
  • StartStation — FLOAT
  • EndStation — FLOAT
  • Info — VARCHAR
  • PipeName — VARCHAR
  • Location — FLOAT
  • Remark1 — VARCHAR
  • Remark2 — VARCHAR
  • Remark3 — VARCHAR

주소별 물 사용량 (AddressbyDemand)

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Field (CustormerID) — text
  • Field2 (Address) — text
  • Field3 (BusinessType) — text
  • Field4 (Jan) — real
  • Field5 (Feb) — real
  • Field6 (Mar) — real
  • Field7 (Apr) — real
  • Field8 (May) — real
  • Field9 (Jun) — real
  • Field10 (Jul) — real
  • Field11 (Aug) — real
  • Field12 (Sep) — real
  • Field13 (Oct) — real
  • Field14 (Nov) — real
  • Field (Dec) — real
  • Field (Lat) — real
  • Field2 (Lon) — real
  • Field (LinkNodeID) — integer
  • Key (AreaID) — integer — 외래 키 → 구역정보.Key — NOT NULL

지장물 데이터 (ObstaclesListDatas)

  • ObstaclesID — INTEGER — 기본 키 — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 플랜 정보.Key — NOT NULL
  • ObstaclesType — enum(ObstaclesType)
  • Title — VARCHAR
  • Classification — enum(BuriedPipeType)
  • ID — VARCHAR
  • NotEmpty — VARCHAR
  • StructureShape — enum(PipeFormType)
  • Material — VARCHAR
  • PipeDiameter — VARCHAR
  • Extension — FLOAT
  • RealExtension — FLOAT
  • PipeStartLevel — FLOAT
  • PipeEndLevel — FLOAT
  • StartBurialDepth — FLOAT
  • EndBurialDepth — FLOAT
  • Gradient — FLOAT
  • InstallationYear — VARCHAR
  • CrossList — VARCHAR
  • CrossInfo — VARCHAR
  • TotalEditBuriedPipeLayer — BLOB(HmPolyline2D)

지장물 정보 (ObstructionDatas)

  • ObstructionID — INTEGER — 기본 키 — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 플랜 정보.Key — NOT NULL
  • Name — VARCHAR — NOT NULL
  • Classification — VARCHAR — NOT NULL
  • Value — FLOAT
  • Color — VARCHAR — NOT NULL
  • IsChecked — INTEGER — 점검요망

지하매설물 도면층 선택데이터 (InfoSetting)

  • SettingID — INTEGER — 기본 키 — NOT NULL
  • PipeID — INTEGER — 외래 키 → 지하매설물 정보.PipeID — NOT NULL
  • Type — enum(BuriedPipeType)
  • Name — VARCHAR
  • LayerColumns — BLOB(string)

지하매설물 정보 (BuriedPipeDatas)

  • PipeID — INTEGER — 기본 키 — NOT NULL
  • SafeFileName — VARCHAR
  • FileName — VARCHAR
  • InputRangeType — enum(BuriedPipeInputRangeType)
  • OutOfRangeType — enum(BuriedPipeOutOfRangeType)
  • LineCountType — enum(SpecificationLineCountType)
  • OuputLocationType — enum(SpecificationOuputLocationType)

커브 상세정보 (Curve_DetailInfos)

  • Key — integer — 기본 키 — NOT NULL
  • Key (CurveID) — integer — 외래 키 → Curve.Key — NOT NULL
  • Key (PlanID) — integer — 외래 키 → Curve.Key — NOT NULL
  • Field (Standard) — real
  • Field2 (Value) — real

컨트롤관련 (Controls)

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (PlanID) — integer — 기본 키 — NOT NULL
  • Key (PlanID2) — integer — 외래 키 → 플랜 정보.Key — NOT NULL
  • Field (Type) — integer
  • Field2 (Value) — Text

패턴 (Patterns)

  • Key (PatternID) — integer — 기본 키 — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 플랜 정보.Key — NOT NULL
  • Field (Pattern) — text
  • Field (Description) — text

패턴 상세정보 (Pattern_DetailInfos)

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (PatternID) — integer — 외래 키 → 패턴.Key — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 패턴.Key — NOT NULL
  • Field (Value) — real

펌프 정보 (PumpInfos)

  • Key (LinkID) — integer — 외래 키 → 링크정보.Key — NOT NULL
  • Key (PlanID) — integer — 외래 키 → 링크정보.Key — NOT NULL
  • Field (PumpCurveID) — integer
  • Field2 (Power) — real
  • Field3 (Speed) — real
  • Field4 (PatternID) — integer
  • Field5 (InitStatus) — integer
  • Field6 (EffCurveID) — integer
  • Field7 (EnergyPrice) — real
  • Field8 (PricePatternID) — integer

평면작도조건 (ResultPipeDrawSettingInfo)

  • Key (ResultPipeDrawID) — integer — 기본 키 — NOT NULL
  • Width — VARCHAR — 화살촉설정
  • Height — VARCHAR — 화살촉설정
  • ArrowStyle — VARCHAR — 화살촉설정
  • ArrowPosition — VARCHAR — 화살촉설정
  • IsOutLineChecked — INTEGER — 관로 번호 표현 방식
  • OutLineType — VARCHAR — 관로 번호 표현 방식
  • Distance — VARCHAR — 관로 번호 표현 방식
  • Radius — VARCHAR — 관로 번호 표현 방식
  • LinkFontSize — VARCHAR — 관로제원
  • StyleNo — INTEGER — 관로제원설정
  • Label11 — VARCHAR — 관로제원설정
  • Label12 — VARCHAR — 관로제원설정
  • Label13 — VARCHAR — 관로제원설정
  • Label21 — VARCHAR — 관로제원설정
  • Label22 — VARCHAR — 관로제원설정
  • Label23 — VARCHAR — 관로제원설정
  • Label31 — VARCHAR — 관로제원설정
  • Label32 — VARCHAR — 관로제원설정
  • Label33 — VARCHAR — 관로제원설정
  • Label41 — VARCHAR — 관로제원설정
  • Label42 — VARCHAR — 관로제원설정
  • Label43 — VARCHAR — 관로제원설정
  • LeftMargin — FLOAT — 관로제원설정
  • RightMargin — FLOAT — 관로제원설정
  • TopBottomMargin — FLOAT — 관로제원설정
  • JunctionScale — VARCHAR — 개체 크기 및 기타
  • ReservoirScale — VARCHAR — 개체 크기 및 기타
  • PumpScale — VARCHAR — 개체 크기 및 기타
  • TankScale — VARCHAR — 개체 크기 및 기타
  • ValveScale — VARCHAR — 개체 크기 및 기타
  • TextScale — VARCHAR — 개체 크기 및 기타
  • CurvePipeFlagScale — VARCHAR — 개체 크기 및 기타

프로젝트 정보 (ProjectInfos)

  • Field (ProjectName) — text
  • Field (ProjectDescription) — text

플랜 정보 (PlanInfos)

  • Key (PlanID) — integer — 기본 키 — NOT NULL
  • Field (PlanName) — text
  • Field (PlanDescription) — text

횡단작도조건 (CrossDrawSettingDatas)

  • Key (CrossDrawSettingID) — Integer — 기본 키 — NOT NULL
  • GeneralHorizentalScale — INTEGER
  • GeneralVerticalScale — INTEGER
  • TextSize — FLOAT
  • PavementSize — FLOAT
  • PolePosition — FLOAT
  • UseBox — INTEGER
  • BoxPosition — INTEGER
  • OffsetX — FLOAT
  • OffsetY — FLOAT
  • UseArrangement — INTEGER
  • ArrangementCount — INTEGER
  • ArrangementInterval — FLOAT
  • UseFormBox — INTEGER
  • CountX — INTEGER
  • CountY — INTEGER
  • SizeX — FLOAT
  • SizeY — FLOAT
  • AddonInfoType — enum(AdditionalInformationType)
  • LeftWidth — FLOAT
  • RightWidth — FLOAT
  • TargetPipelineType — enum(TargetPipelineType)
  • SlopeApplyType — enum(SlopeApplyType)
  • TopWidth — FLOAT — 경량복공가시설
  • Depth — FLOAT — 경량복공가시설