|
Tables in NAPTF Database
Table Relationship
Table Definition
TABLE [distress] (
[Distress_No] [int] NOT NULL ,
[Distress_Type] [varchar] (50) NOT NULL ,
[Pavement_Type] [varchar] (20) NOT NULL
)
TABLE [dynamic_data] (
[SensorID] [int] NOT NULL ,
[EventNo] [int] NOT NULL ,
[StartTime] [varchar] (50) NULL ,
[StartVehiclePosition] [real] NULL ,
[EndTime] [varchar] (50) NULL ,
[EndVehiclePosition] [real] NULL ,
[OffsetLeft] [real] NULL ,
[OffsetRight] [real] NULL ,
[FilterFreq] [int] NULL ,
[Peak1Time] [varchar] (50) NULL ,
[Peak1] [real] NULL ,
[Peak2Time] [varchar] (50) NULL ,
[Peak2] [real] NULL ,
[Peak3Time] [varchar] (50) NULL ,
[Peak3] [real] NULL ,
[SensorRecord] [varchar] (8000) NULL ,
[SpuRefTime] [datetime] NOT NULL ,
[modified] [smalldatetime] NULL ,
[comments] [varchar] (200) NULL ,
[rowid] [int] NULL
)
TABLE [fwd] (
[FWDKey] [int] IDENTITY (1, 1) NOT NULL ,
[TestItem_ID] [varchar] (20) NOT NULL ,
[DateTime] [datetime] NOT NULL ,
[Station] [decimal](18, 0) NULL ,
[Offset] [decimal](18, 0) NOT NULL ,
[Load] [int] NOT NULL ,
[Loc1] [real] NULL ,
[Loc2] [real] NULL ,
[Loc3] [real] NULL ,
[Loc4] [real] NULL ,
[Loc5] [real] NULL ,
[Loc6] [real] NULL ,
[Defl0] [real] NULL ,
[Defl1] [real] NULL ,
[Defl2] [real] NULL ,
[Defl3] [real] NULL ,
[Defl4] [real] NULL ,
[Defl5] [real] NULL ,
[Defl6] [real] NULL ,
[AirTemp] [real] NULL ,
[PaveTemp] [real] NULL ,
[Comments] [varchar] (100) NULL ,
[rowid] [char] (10) NULL
)
TABLE [Gear] (
[GearParameter] [int] NOT NULL ,
[NorthCarriageTires] [tinyint] NOT NULL ,
[SouthCarriageTires] [tinyint] NOT NULL ,
[TireLoadNorth] [int] NOT NULL ,
[TireLoadSouth] [int] NOT NULL ,
[TirePressureNorth] [decimal](18, 0) NOT NULL ,
[TirePressureSouth] [decimal](18, 0) NOT NULL ,
[DualSpacingNorth] [decimal](18, 0) NULL ,
[DualSpacingSouth] [decimal](18, 0) NULL ,
[TandemSpacingNorth] [decimal](18, 0) NULL ,
[TandemSpacingSouth] [decimal](18, 0) NULL ,
[VehicleSpeed] [int] NOT NULL ,
[Comment] [varchar] (100) NULL
)
TABLE [MUX] (
[SensorID] [int] NOT NULL ,
[SensorName] [varchar] (50) NULL ,
[sensortype] [varchar] (50) NULL ,
[Mux] [smallint] NULL ,
[TestItemID] [varchar] (20) NULL ,
[Item] [varchar] (50) NULL ,
[Channel] [varchar] (4) NULL ,
[X_FT] [real] NULL ,
[X_IN] [real] NULL ,
[X_FRACT] [real] NULL ,
[LOCATION_X] [real] NULL ,
[Y_FT] [real] NULL ,
[Y_IN] [real] NULL ,
[Y_FRACT] [real] NULL ,
[LOCATION_Y] [real] NULL ,
[Z_FT] [real] NULL ,
[Z_IN] [real] NULL ,
[Z_FRACT] [real] NULL ,
[LOCATION_Z] [real] NULL ,
[Comments] [varchar] (100) NULL ,
[Modified] [smalldatetime] NULL
)
TABLE [pci_summary] (
[Survey_ID] [int] NOT NULL ,
[TestItem_ID] [varchar] (20) NOT NULL ,
[Survey_Date] [datetime] NOT NULL ,
[Sample_Area] [int] NOT NULL ,
[PCI] [int] NULL ,
[SCI] [int] NOT NULL
)
TABLE [pci_survey] (
[Survey_ID] [int] IDENTITY (1, 1) NOT NULL ,
[Distress_No] [int] NOT NULL ,
[Severity] [varchar] (20) NOT NULL ,
[Quantity] [int] NOT NULL ,
[Density] [int] NOT NULL ,
[Deduct_Load] [real] NULL ,
[Deduct_All] [real] NOT NULL
)
TABLE [SPUs] (
[SensorID] [int] NOT NULL ,
[SensorName] [varchar] (50) NULL ,
[SPU] [smallint] NULL ,
[CARD] [smallint] NULL ,
[TestItemID] [varchar] (20) NULL ,
[SCP] [varchar] (8) NULL ,
[SensorTYPE] [varchar] (50) NULL ,
[ITEM] [varchar] (50) NULL ,
[CHANNEL] [smallint] NULL ,
[STATUS] [smallint] NULL ,
[RANGE] [varchar] (50) NULL ,
[CAL_1] [real] NULL ,
[CAL_1_UNIT] [varchar] (50) NULL ,
[CAL_2] [real] NULL ,
[CAL_2_UNIT] [varchar] (50) NULL ,
[LOCATION_X] [real] NULL ,
[LOCATION_Y] [real] NULL ,
[LOCATION_Z] [real] NULL ,
[Comments] [varchar] (100) NULL ,
[Modified] [smalldatetime] NULL
)
TABLE [static_data] (
[SensorID] [int] NOT NULL ,
[date_time] [smalldatetime] NOT NULL ,
[reading] [real] NULL ,
[Modified] [smalldatetime] NULL ,
[comments] [varchar] (200) NULL ,
[rowid] [int] NULL
)
TABLE [test_item] (
[TestItemID] [varchar] (20) NOT NULL ,
[PavementType] [varchar] (20) NULL ,
[Subgrade] [varchar] (50) NULL ,
[Layer1] [varchar] (50) NULL ,
[Layer1Thick] [real] NULL ,
[Layer2] [varchar] (50) NULL ,
[Layer2Thick] [varchar] (20) NULL ,
[Layer3] [varchar] (50) NULL ,
[Layer3Thick] [real] NULL ,
[Layer4] [varchar] (50) NULL ,
[Layer4thick] [char] (10) NULL
)
TABLE [Track] (
[TrackNo] [int] NOT NULL ,
[TrackOffset_MM] [real] NULL ,
[Trackoffset_IN] [real] NULL ,
[CarriagePositionNorth] [real] NULL ,
[CarriagePositionSouth] [real] NULL ,
[Comment] [varchar] (100) NULL
)
TABLE [Traffic] (
[TrafficRowNo] [int] NOT NULL ,
[EventNo] [int] NOT NULL ,
[TrackNo] [int] NOT NULL ,
[EventStartTime] [datetime] NULL ,
[EventEndTime] [datetime] NULL ,
[AvVehicleLoads] [nvarchar] (50) NULL ,
[WanderPattern_LRS] [int] NULL ,
[WanderPattern_LFS] [int] NULL ,
[WanderPattern_LFC] [int] NULL ,
[WanderPattern_MFC] [int] NULL ,
[WanderPattern_MFS] [int] NULL ,
[WanderPattern_MRS] [int] NULL ,
[WanderPattern_HRS] [int] NULL ,
[WanderPattern_HFS] [int] NULL ,
[WanderPattern_HFC] [int] NULL ,
[Gearparameter] [int] NULL ,
[SequenceNo] [int] NULL ,
[Comment] [varchar] (100) NULL ,
[rowid] [int] NULL
)
TABLE [Wander] (
[SequenceNo] [int] NOT NULL ,
[TrackNo] [int] NULL ,
[TrackOffset_MM] [real] NULL ,
[Trackoffset_IN] [real] NULL ,
[CarriagePositionNorth] [real] NULL ,
[CarriagePositionSouth] [real] NULL ,
[TravelDirection] [char] (4) NOT NULL ,
[Comment] [varchar] (100) NULL
)
Last Update: 05/17/02
|