AiPipe_Sewer

테이블 (100)

Aquifer

  • Aquifer_ID — integer — 기본 키 — NOT NULL
  • aquifer_name — integer — NOT NULL
  • porosity — real
  • wilting_point — real
  • field_capacity — real
  • conductivity — real
  • conductivity_slope — real
  • tension_slope — real
  • upper_evap_fraction — real
  • lower_evap_depth — real
  • lower_gw_loss_rate — real
  • bottom_elevation — real
  • water_table_elevation — real
  • unsat_zone_moisture — real
  • upper_evap_pattern (upper_evap_patternID) — integer

Bio_RetentionCells

  • Key (LIDControlID) — integer — 외래 키 → LID Control Editor.Key — NOT NULL
  • Field (Surface_BermHeight) — real
  • Field (Surface_VegetationVolumn) — real
  • Field (Surface_SurfaceRoughness) — real
  • Field (Surface_SurfaceSlope) — real
  • Field (Soil_Thickness) — real
  • (Soil_Porosity) — real
  • Field (Soil_FiedlCapacity) — real
  • Field (Soil_WiltingPoint) — real
  • Field (Soil_Conductivity) — real
  • Field (Soil_ConductivitySlope) — real
  • Field (Soil_SuctionHeader) — real
  • Field (Storage_Thickness) — real
  • Field (Storage_VoidRatio) — real
  • Field (Storage_SeepageRate) — real
  • Field (Storage_CloggingFactor) — real
  • Field (Drain_FlowCoeff) — real
  • Field (Drain_FlowExpo) — real
  • Field (Drain_Offset) — real
  • (Drain_OpenLevel) — real
  • Field (Drain_ClosedLevel) — real
  • Field (Drain_ControlCurveID) — integer

Climatolagy_Adjust

  • ID — integer — NOT NULL
  • DataType — integer
  • Jan — real
  • Feb — real
  • Mar — real
  • Apr — real
  • May — real
  • Jun — real
  • Jul — real
  • Aug — real
  • Sep — real
  • Oct — real
  • Nov — real
  • Doc (Dec) — real

Climatolagy_Areal_Dep

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Field7 (Impervious_0) — double
  • Field (Impervious_1) — double
  • Field (Impervious_2) — double
  • Field (Impervious_3) — double
  • Field2 (Impervious_4) — double
  • Field3 (Impervious_5) — double
  • Field4 (Impervious_6) — double
  • Field5 (Impervious_7) — double
  • Field6 (Impervious_8) — double
  • Field8 (Impervious_9) — double
  • Field9 (Pervious_0) — double
  • Field10 (Pervious_1) — double
  • Field11 (Pervious_2) — double
  • Field12 (Pervious_3) — double
  • Field13 (Pervious_4) — double
  • Field14 (Pervious_5) — double
  • Field15 (Pervious_6) — double
  • Field16 (Pervious_7) — double
  • Field (Pervious_8) — double
  • Field2 (Pervious_9) — double

Climatolagy_Evap

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Field (SourceEvapo) — integer
  • Field2 (DailyEvapo) — real
  • Field (SeriesName) — string
  • Field3 (MonthlySoilRecovery) — string
  • Field4 (DryPeriods) — integer

Climatolagy_Evap_Climate

  • Key (ID) — integer — 외래 키 → Climatolagy_Evap.Key — NOT NULL
  • Jan — real
  • Feb — real
  • Mar — real
  • Apr — real
  • May — real
  • Jun — real
  • Jul — real
  • Aug — real
  • Sep — real
  • Oct — real
  • Nov — real
  • Dec — real

Climatolagy_Evap_Monthly

  • Key (ID) — integer — 외래 키 → Climatolagy_Evap.Key — NOT NULL
  • Jan — real
  • Feb — real
  • Mar — real
  • Apr — real
  • May — real
  • Jun — real
  • Jul — real
  • Aug — real
  • Sep — real
  • Oct — real
  • Nov — real
  • Dec — real

Climatolagy_SnowMelt

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Field (DividingSnowandRain) — real
  • Field (ATI) — real
  • Field (MeltRatio) — real
  • Field (MSL) — real
  • Field (Latitude) — real
  • Field (LongitudeCorrection) — real

Climatolagy_Temps

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Field (TempDataType) — Integer
  • Field2 (DataInfo) — text
  • Field3 (StartDateTime) — text
  • Field4 (UnitforGHCN) — integer

Climatolagy_WindSpeed(DataType이 2일때만 사용) (Climatolagy_WindSpeed)

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Field (DataType) — integer
  • Field (Jan) — real
  • Field (Feb) — real
  • Field (Mar) — real
  • Field (Apr) — real
  • Field (May) — real
  • Field (Jun) — real
  • Field (Jul) — real
  • Field (Aug) — real
  • Field (Sep) — real
  • Field (Oct) — real
  • Field (Nov) — real
  • Field (Dec) — real

ControlCurves

  • Key (ID) — Integer — 기본 키 — NOT NULL
  • Key (CurveID) — Integer — 외래 키 → CurveInfos.Key — NOT NULL
  • Field (Values) — real
  • Field (Setting) — real

ControlInfo

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Field (Control) — text

CurveInfos

  • Key (ID) — Integer — 기본 키 — NOT NULL
  • Field (Curve Name) — text
  • Field (Description) — text

DiversionCurves

  • Key (ID) — Integer — 기본 키 — NOT NULL
  • Key (CurveID) — Integer — 외래 키 → CurveInfos.Key — NOT NULL
  • Field (InFlow) — real
  • Field2 (OutFlow) — real

Green_Roofs

  • Key (LIDControlID) — integer — 외래 키 → LID Control Editor.Key — NOT NULL
  • Field (Surface_BermHeight) — real
  • Field2 (Surface_VegetationVolumn) — real
  • Field3 (Surface_SurfaceRoughness) — real
  • Field (Surface_SurfaceSlope) — real
  • Field (Soil_Thickness) — real
  • Field2 (Soil_Porosity) — real
  • Field3 (Soil_FiedlCapacity) — real
  • Field4 (Soil_WiltingPoint) — real
  • Field5 (Soil_Conductivity) — real
  • Field6 (Soil_ConductivitySlope) — real
  • Field (Soil_SuctionHeader) — real
  • Field (DrainageMat_Thickness) — real
  • Field2 (DrainageMat_VoidFraction) — real
  • Field3 (DrainageMat_Roughness) — real

IAD_DetailInfos

  • Key (UnitID) — integer — 외래 키 → Unit Hydrograph Editor.Key — NOT NULL
  • All Month == 0 (MonthIndex) — integer
  • Field9 (IAD_Short_DMax) — real
  • Field (IAD_Short_DRec) — real
  • Field2 (IAD_Short_Do) — real
  • Field3 (IAD_Medi_DMax) — real
  • Field4 (IAD_Medi_DRec) — real
  • Field5 (IAD_Medi_Do) — real
  • Field6 (IAD_Long_DMax) — real
  • Field7 (IAD_Long_DRec) — real
  • Field8 (IAD_Long_Do) — real

Infitration_Trenches

  • Key (LIDControlID) — integer — 외래 키 → LID Control Editor.Key — NOT NULL
  • Surface_BermHeight — real
  • Surface_VegetationVolumn — real
  • Surface_SurfaceRoughness — real
  • Surface_SurfaceSlope — real
  • Storage_Thickness — real
  • Storage_VoidRatio — real
  • Storage_SeepageRate — real
  • Storage_CloggingFactor — real
  • Drain_FlowCoeff — real
  • Drain_FlowExpo — real
  • Drain_Offset — real
  • Drain_OpenLevel — real
  • Drain_ClosedLevel — real
  • Drain_ControlCurveID (Drain_ControlCurve) — integer

Inlet_Structure_Combination

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (InletID) — integer — 외래 키 — NOT NULL
  • Type — Integer
  • Field2 (Length) — real
  • Field (Width) — real
  • Field (Curb_Length) — real
  • Field2 (Curb_Height) — real
  • Field3 (Curb_Throat) — integer

Inlet_Structure_CurbOpening

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (InletID) — integer — 외래 키 — NOT NULL
  • Field (Length) — real
  • Field2 (Height) — real
  • Field (ThroatAngle) — integer

Inlet_Structure_Custom

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (InletID) — integer — 외래 키 — NOT NULL
  • Field (Type) — integer
  • Field (CurveName) — text

Inlet_Structure_DropCurb

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (InletID) — integer — 외래 키 — NOT NULL
  • Field (Length) — real
  • Field2 (Height) — real

Inlet_Structure_DropGrate

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (InletID) — integer — 외래 키 — NOT NULL
  • Type — Integer
  • Field2 (Length) — real
  • Field (Width) — real

Inlet_Structure_Grate

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (InletID) — integer — 외래 키 — NOT NULL
  • Type — Integer
  • Field2 (Length) — real
  • Field (Width) — real

Inlet_Structure_SlottedDrain (CopyOfUntitled6)

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (InletID) — integer — 외래 키 — NOT NULL
  • Field (Length) — real
  • Field2 (Width) — real

LID Control Editor (LIDControls)

  • Key (LIDControlID) — integer — 기본 키 — NOT NULL
  • Field (ControlName) — text
  • Field (LIDType) — integer

Land_Use_SettingInfo

  • Key (SubcatchmentID) — integer — 외래 키 → Subcatchment.Key — NOT NULL

LidControl_SettingInfo

  • Key (SubcatchmentID) — integer — 외래 키 → Subcatchment.Key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

ManholeInfo

  • Key (ManholeCode) — integer — 기본 키 — NOT NULL
  • Field (ManholeName)

MapLabels

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Field (Text) — text
  • Field (Description) — text
  • Field (X) — real
  • Field (Y) — real
  • Field (AncherNode) — text
  • Field (font) — text
  • Field

Node 수질정보 (TreatmentInfos)

  • Key (ID) — 기본 키 — NOT NULL
  • Key (NodeID) — integer — 외래 키 → 노드정보.Key — NOT NULL
  • Field (PollutantID) — integer
  • Field (Expression) — text

Node 유입유량정보 (Inflows)

  • Key (ID) — 기본 키 — NOT NULL
  • Key (NodeID) — integer — 외래 키 → 노드정보.Key — NOT NULL
  • Field (Constituent) — integer
  • Field2 (Direct_Baseline) — real
  • Field3 (Direct_BaselinePatternID) — integer
  • Field4 (Direct_TimeSeriesID) — integer
  • Field5 (Direct_ScaleFactor) — real
  • Field7 (Dry_Weather_AverageValue) — real
  • Field8 (Dry_Weather_TimePatternID1) — integer
  • Field (Dry_Weather_TimePatternID2) — integer
  • Field2 (Dry_Weather_TimePatternID3) — integer
  • Field (Dry_Weather_TimePatternID4) — integer
  • Field9 (RDII_UnitHydrographGroupID) — integer
  • Field10 (RDII_SewershedArea) — real

Option_Files

  • Key (ID) — integer — 외래 키 → Options.Key — NOT NULL
  • Field (File) — text

Options

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Field (Title) — text
  • Field (Rainfall_RunOff) — integer
  • Field2 (Rainfall_Dependent) — integer
  • Field3 (SnowMelt) — integer
  • Field4 (GroundWater) — integer
  • Field5 (FlowRouting) — integer
  • Field6 (WaterQuality) — integer
  • Field (InfitrationModel) — Integer
  • Field (RoutingModel) — integer
  • Field (AllowPonding) — integer
  • Field (Minimum_ConduitSlope) — double
  • Field (StartAnalysis) — text
  • Field2 (StartReporting) — text
  • Field (EndAnalysis) — text
  • Field (StartSweeping) — text
  • Field (EndSweeping) — text
  • Field (AntecedentDryDays) — real
  • Field (ReportingStep) — integer
  • Field (ReportingStep_Time) — text
  • Field (RunOffStep_Dry) — integer
  • Field (RunOffStep_Dry_Time) — text
  • Field (RunOffStep_Wet) — integer
  • Field (RunOffStep_Wet_Time) — text
  • Field (ControlRuleStep) — text
  • Field (RoutingStep) — real
  • Field (UseSteadyFlowPeriods) — integer
  • Field (SystemFlowTolerance) — integer
  • Field (LateralFlowTolerance) — integer
  • Field (InertalTerms) — integer
  • Field2 (NormalFlow) — integer
  • (ForceMain) — integer
  • Field4 (Surcharge) — integer
  • Field5 (UseVariableTime) — integer
  • Field6 (UseVariableTime_Value) — integer
  • Field7 (MinimumVariable) — real
  • Field8 (TimeStep) — real
  • Field9 (Minimum_Nodal) — real
  • Field10 (HeadConvergence) — real
  • Field11 (MaximumTrials) — integer
  • Field (ParallelThread) — integer

Permeable_Pavement

  • Key (LIDControlID) — integer — 외래 키 → LID Control Editor.Key — NOT NULL
  • Surface_BermHeight — real
  • Surface_VegetationVolumn — real
  • Surface_SurfaceRoughness — real
  • Surface_SurfaceSlope — real
  • Soil_Thickness — real
  • Soil_Porosity — real
  • Soil_FiedlCapacity — real
  • Soil_WiltingPoint — real
  • Soil_Conductivity — real
  • Soil_ConductivitySlope — real
  • Soil_SuctionHeader — real
  • Storage_Thickness — real
  • Storage_VoidRatio — real
  • Storage_SeepageRate — real
  • Storage_CloggingFactor — real
  • Drain_FlowCoeff — real
  • Pavement_VoidRatioreal — real
  • Pavement_ImperviousSurfaceFractionreal — real
  • Pavement_Permeailityreal — real
  • Pavement_CloggingFacotrreal — real
  • Pavement_RegenerationIntervalreal — real
  • Pavement_RegenerationFactorreal — real

PumpCurves

  • Key (ID) — Integer — 기본 키 — NOT NULL
  • Key (CurveID) — Integer — 외래 키 → CurveInfos.Key — NOT NULL
  • Field (PumpType) — integer
  • Field (Volumn) — real
  • Field (Flow) — real

RainGages

  • RainGage_ID — integer — NOT NULL
  • name — text
  • X — real
  • Y — real
  • Description — text
  • Tag — text
  • rain_format — integer
  • time_interval — text
  • snow_catch_factor — real
  • data_source — integer
  • series_name — text
  • file_name — text
  • station_id — text
  • rain_units — integer

Rain_Barrel

  • Key (LIDControlID) — integer — 외래 키 → LID Control Editor.Key — NOT NULL
  • Storage_Height — real
  • Storage_Covered — integer
  • Storage_SeepageRate — real
  • Storage_CloggingFactor — real
  • Drain_FlowCoeff — real

Rain_Gardens

  • Key (LIDControlID) — integer — 외래 키 → LID Control Editor.Key — NOT NULL
  • Field (Surface_BermHeight) — real
  • Field2 (Surface_VegetationVolumn) — real
  • Field3 (Surface_SurfaceRoughness) — real
  • Field4 (Surface_SurfaceSlope) — real
  • Field (Soil_Thickness) — real
  • Field2 (Soil_Porosity) — real
  • Field3 (Soil_FiedlCapacity) — real
  • Field4 (Soil_WiltingPoint) — real
  • Field5 (Soil_Conductivity) — real
  • Field6 (Soil_ConductivitySlope) — real
  • Field7 (Soil_SuctionHeader) — real
  • Field (Storage_Thickness) — real
  • Field2 (Storage_VoidRatio) — real
  • Field3 (Storage_SeepageRate) — real
  • Field4 (Storage_CloggingFactor) — real

RatingCurves

  • Key (ID) — Integer — 기본 키 — NOT NULL
  • Key (CurveID) — Integer — 외래 키 → CurveInfos.Key — NOT NULL
  • Field (Head) — real
  • Field (OutFlow) — real

Rooftop_Diconnection

  • Key (LIDControlID) — integer — 외래 키 → LID Control Editor.Key — NOT NULL
  • Surface_StorageDepth — real
  • Surface_Roughness — real
  • Surface_Slope — real
  • RoofDrain_FlowCapacity — real

SeepageLoss

  • Key (ID) — integer — 외래 키 — NOT NULL
  • Key (NodeID) — integer — 외래 키 — NOT NULL
  • Field (SuctionHead) — real
  • Field2 (Conductivity) — real
  • Field3 (InitialDeficit) — real

ShapeCurves

  • Key (ID) — Integer — 기본 키 — NOT NULL
  • Key (CurveID) — Integer — 외래 키 → CurveInfos.Key — NOT NULL
  • Field (Depth) — real
  • Field2 (Width) — real

ShapeSpec_Arch

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (MaximumWidth) — real
  • Field2 (SizeCode)
  • Field (StadrardSize) — real

ShapeSpec_Custom

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (ShapeCurveID) — integer

ShapeSpec_Irregular

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (TransectCurveID) — integer

Shapespce_ModifiedBasketHandle

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (TopWidth) — real
  • Field (TopRadius) — real

Shapespce_Power

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (TopWidth) — real
  • Field (Power) — real

Shapespce_RectangularRound

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (TopWidth) — real
  • Field (BottomRadius) — real

Shapespce_RectangularTriangular

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (TopWidth) — real
  • Field (TriangleHeight) — real

SnowPack_DetailInfos

  • ID (SnowID) — integer — 외래 키 → SnowPacks.ID — NOT NULL
  • Field (snow_removal_depth) — real
  • Field2 (fraction_out_of_watershed) — real
  • Field3 (fraction_to_impervious_area) — real
  • Field4 (fraction_to_pervious_area) — real
  • Field5 (fraction_immediate_melt) — real
  • Field6 (fraction_to_other_subcatchment) — real
  • Field7 (SubCatchmentName) — text

SnowPacks

  • ID (SnowID) — integer — 기본 키 — NOT NULL
  • MinMeltCoeff_Plow — real
  • MaxMeltCoeff_Plow — real
  • BaseTemp_Plow — real
  • FractionFres_Plow — real
  • InitSnowDepth_Plow — real
  • InitFreeWater_Plow — real
  • MinMeltCoeff_Impe — real
  • MaxMeltCoeff_Impe — real
  • BaseTemp_Impe — real
  • FractionFres_Impe — real
  • InitSnowDepth_Impe — real
  • InitFreeWater_Impe — real
  • DepthAtFullCover_Impe — real
  • MinMeltCoeff_Perv — real
  • MaxMeltCoeff_Perv — real
  • BaseTemp_Perv — real
  • FractionFres_Perv — real
  • InitSnowDepth_Perv — real
  • InitFreeWater_Perv — real
  • DepthAtFullCover_Perv — real
  • FractionofImperviousArea — real

StorageCurves

  • Key (ID) — Integer — 기본 키 — NOT NULL
  • Key (CurveID) — Integer — 외래 키 → CurveInfos.Key — NOT NULL
  • Field (Depth) — real
  • Field2 (Area) — real

Subcatchment

  • Key (SubcatchmentID) — integer — 기본 키 — NOT NULL
  • Field (Name) — text
  • X — real
  • Y — real
  • Description — text
  • Tag — text
  • rain_gageID — integer
  • outletNodeID — integer
  • area — real
  • width — real
  • slope_percent — real
  • impervious_percent — real
  • n_impervious — real
  • n_pervious — real
  • dstore_impervious — text
  • dstore_pervious — real
  • zero_impervious_percent — real
  • subarea_routing — text
  • percent_routed — real
  • infiltration_data — text
  • groundwater — text
  • snow_pack (snow_packID) — integer
  • lid_controls — real
  • land_uses — real
  • initial_buildup — text
  • curb_length — real
  • n_pervious_pattern (n_pervious_patternID) — integer
  • dstore_pattern (dstore_patternID) — integer
  • infiltration_pattern (infiltration_patternID) — integer

TidalCurves

  • Key (ID) — Integer — 기본 키 — NOT NULL
  • Key (CurveID) — Integer — 외래 키 → CurveInfos.Key — NOT NULL
  • Field (HourofDay) — real
  • Field2 (Coefficient) — real

TimePattern

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Field (Name) — text
  • Field (Type) — integer
  • Field (index) — integer
  • Field (value) — real

TransectDetailInfo

  • Key (Seq) — Integer — 기본 키 — NOT NULL
  • Key (ID) — integer — 외래 키 → TransectInfo.Key — NOT NULL
  • Field (Station) — real
  • Field (Elevation) — real

TransectInfo

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Field (Name) — text
  • Field (Description) — text
  • Field (LeftBank) — real
  • Field (rightBank) — real
  • Field (Channel) — real
  • Field (Left) — real
  • Field (Right) — real
  • Field (Stations) — real
  • Field (Elevations) — real
  • Field (Meander) — real

UH_DetailInfos

  • Key (UnitID) — integer — 외래 키 → Unit Hydrograph Editor.Key — NOT NULL
  • All Month == 0 (MonthIndex) — integer
  • Field (UH_Short_R) — real
  • Field (UH_Short_T) — real
  • Field2 (UH_Short_K) — real
  • Field3 (UH_Medi_R) — real
  • Field4 (UH_Medi_T) — real
  • Field5 (UH_Medi_K) — real
  • Field6 (UH_Long_R) — real
  • Field7 (UH_Long_T) — real
  • Field8 (UH_Long_K) — real

Unit Hydrograph Editor (UnitHydrographs)

  • Key (UnitID) — integer — 기본 키 — NOT NULL
  • Field (UHGroupName) — text

VegetativeSwale

  • Key (LIDControlID) — integer — 외래 키 → LID Control Editor.Key — NOT NULL
  • Surface_BermHeight — real
  • Surface_VegetationVolumn — real
  • Surface_SurfaceRoughness — real
  • Surface_SurfaceSlope — real
  • Surface_SwaleSideSlope — real

WeirCurves

  • Key (ID) — Integer — 기본 키 — NOT NULL
  • Key (CurveID) — Integer — 외래 키 → CurveInfos.Key — NOT NULL
  • Field (Head) — real
  • Field2 (Coefficient) — real

initial_buildup_SettingInfo

  • Key (SubcatchmentID) — integer — 외래 키 → Subcatchment.Key — NOT NULL

vertices 정보 (Link_CoordinateInfo)

  • Key (LinkID) — integer — 외래 키 → 관로정보.Key — NOT NULL
  • Field (ID) — integer
  • Field (X) — real
  • Field (Y) — real
  • Field (Type) — integer
  • Field (step) — intefer

관로상세정보 (ConduitInfos)

  • Key (LinkID) — integer — 외래 키 → 관로정보.Key — NOT NULL
  • Field (Roughness) — real
  • Field (InitialFlow) — real
  • Field (MaximumFlow) — real
  • Field (EntryLossCoeff) — real
  • Field (ExitLossCoeff) — real
  • Field (AvgLossCoeff) — real
  • Field (SeepageLossRate) — real
  • Field (CulvertCode) — integer

관로정보 (LinkInfo)

  • Key (LinkID) — integer — 기본 키 — NOT NULL
  • LinkName — text
  • NodeInfos-NodeID에 FKey연결 (InletNodeID) — text
  • NodeInfos-NodeID에 FKey연결 (OutletNodeID) — text
  • Field (Description) — text
  • Field (Tag) — text
  • 바닥기준 (InletOffset) — real
  • 바닥기준 (OutletOffset) — real
  • Field (MaterialID) — integer
  • Field2 (MaxDepth) — real
  • Field (InputLength) — real
  • Field (DrawLength) — real
  • Field (FlapGate) — integer

관로형상 (ShapeSpec)

  • Key (LinkID) — integer — 외래 키 → 관로정보.Key — NOT NULL
  • ShapeType — integer
  • NumberofBarrels — integer
  • MaximumHeight — Real

관재질 정보(수정요망) (Link_MaterialInfo)

  • Key (MaterialID) — integer — 기본 키 — NOT NULL
  • (Name) — Text
  • Field

노드정보 (NodeInfos)

  • Key (NodeID) — integer — 기본 키 — NOT NULL
  • Field (Node) — text
  • Field (X) — real
  • Field (Y) — real
  • Field (Z) — real
  • Field (Description) — text
  • Field (Tag) — text
  • Field2 (InvertEl) — real
  • Field3 (MaxDepth) — real
  • Field (ManholeCode) — integer

도로수로 (Shapespce_Street)

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (Name) — text
  • request (RoadWidth) — real
  • request (CurbHeight) — real
  • request (CrossClope) — real
  • request (RoadRouhness) — real
  • request (OneSided) — real
  • request (TwoSided) — real
  • Field6 (GutterDepression) — real
  • Field7 (GutterWidth) — real
  • Field (BackingWidth) — real
  • Field2 (BackingSlope) — real
  • Field3 (BackingRouhness) — real

도로수로 (Streets)

  • Key (ID) — 기본 키 — NOT NULL
  • Field (Name) — text
  • request (RoadWidth) — real
  • request (CurbHeight) — real
  • request (CrossClope) — real
  • request (RoadRouhness) — real
  • request (OneSided) — real
  • request (TwoSided) — real
  • Field6 (GutterDepression) — real
  • Field7 (GutterWidth) — real
  • Field (BackingWidth) — real
  • Field2 (BackingSlope) — real
  • Field3 (BackingRouhness) — real

박스관 (ShapeSpec_CloseRectangular)

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (BottomWidth) — real

분기점 정보 (DividerInfos)

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Key (NodeID) — integer — 외래 키 → 노드정보.Key — NOT NULL
  • Field (InitialDepth) — real
  • Field (SurchargeDepth) — real
  • (PondedArea) — real
  • Field (DivertedLinkID) — Integer
  • Field2 (Type) — Integer
  • Field3 (CutoffFlow) — real
  • Field4 (Tabular_CurveID) — Integer
  • Field5 (Weir_MinFlow) — real
  • Field (Weir_MaxDepth) — real
  • Field (Weir_Coefficient) — real

사각형수로 (ShapeSpec_Rectangular)

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (BottomWidth) — real
  • Field2 (SideWallsRemoved) — integer

사다리꼴 수로 (Shapespce_Trapezoidal)

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (BottomWidth) — real
  • Field2 (LeftSlope) — real
  • Field3 (RightSlope) — real

삼각형수로 (Shapespce_Triangular)

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (TopWidth) — real

수직타원관 (ShapeSpec_VerticalElliptical)

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (MaximumWidth) — real
  • Field2 (SizeCode)
  • Field (StadrardSize) — real

수평타원관 (ShapeSpec_HorizontalElliptical)

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (MaximumWidth) — real
  • Field2 (SizeCode)
  • Field (StadrardSize) — real

시계열 (TimeSeries)

  • Key (ID) — integer — 기본 키 — NOT NULL
  • Field (Name) — text
  • Field (Description) — text
  • Field (FileName) — text
  • Field (Date) — text
  • Field (Time) — text
  • Field (Value) — real

압송관 (Shapespce_ForceMain)

  • Key (LinkID) — integer — 외래 키 → 관로형상.Key — NOT NULL
  • Field (Roughness) — real

오리피스정보 (OrificesInfos)

  • Key (LinkID) — integer — 외래 키 → 관로정보.Key — NOT NULL
  • Field (Type) — integer
  • Field2 (Height) — real
  • Field3 (Width) — real
  • Field4 (DischargeCoeff) — real
  • Field5 (TimetoOpenClose) — integer

외 20개 테이블