dbschema.html

Main Layout

U Sqlite DbSchema Database Designer Interactive comments (mouse-over tips), zoom and pan. Structure AttachHardwareSpanKey AttachedToAttachHardware AttachmentSpanKey CivicStructureKey ClearanceSpanKey MidSpanStructureKey HardwareStructureKey StructureCollectionKey AttachHardware AttachHardwareKey AttachHardwareSpanKey AttachHardwareLength # AttachHardwareHeightAG # AttachHardwareDiameter # AttachHardwareNotes t AttachHardwareWidth # AttachHardwareShape t Attachments AttachmentKey # AttachmentSpanKey AttachmentType t SourceHeight # TargetHeight # WireDescription t WireOwner t WireSlack b WireNotes t AttachedToAttachHardware AttachedToCrossarm # InsulatorType t EccDist # EccAngle # HeightAbsolute b LashingWireIssue b SpecialMountingNotes t WireMeasuredBundle # MidSpanheight # CivicAddresses CivicAddressKey # CivicStructureKey CivicNumber t CivicStreet t CivicNotes t ClearancePoints ClearancePointKey # ClearanceSpanKey DistanceFromSource # ClearanceElevation # MeasuredHeightComm # ClearanceType t IsMaxSagPoint b MeasureHeightLowestPower # MeasuredHeightCommAbove # MeasuredHeightCommBelow # ClearanceNotes t ClearanceItemType t MidSpanStructureKey FieldProject CollectionKey CollectionID t schemaVersion # metric b NorthCorrectionRequired b Hardware HardwareKey # HardwareStructureKey HardwareDescription t HardwareDirection # HardwareQuantity # HardwareOwner t HardwareHeight # HardwareBottomHeight # HardwareNotes t Spans SpanKey SourceStructureKey # TargetStructureKey # SpanClearanceType t SpanType t SpanVegetation t SpanPictureBaseDirectory t SpanPicture1 t SpanPicture2 t SpanPicture3 t SpanPicture4 t SpanPicture5 t SpanPicture6 t SpanPicture7 t SpanPicture8 t SpanPicture9 t SpanPicture10 t SpanNotes t Structure StructureKey StructureCollectionKey Polenumber t PoleID t AltPoleID t PoleTagImage t PoleStampImage t PoleOwner t HeightAboveGround # PoleInspectionYear # AirTemperature # PoleHeight # InstallYear c AnchorEyes c AnchorRodSize c AnchorRodType c--more--

Tables

Default.AttachHardware
Default.Attachments
Default.CivicAddresses
Default.ClearancePoints
Default.FieldProject
Default.Hardware
Default.Spans
Default.Structure

Schema Default

Table AttachHardware

Idx	Field Name	Data Type	Description
*	AttachHardwareKey	INTEGER
	AttachHardwareSpanKey	INTEGER
	AttachHardwareLength	DOUBLE	Length of Attachment Hardware. Units in meters or feet, depending on units chosen
	AttachHardwareHeightAG	DOUBLE	Height of hardware above ground
	AttachHardwareDiameter	DOUBLE	Diameter/Height of Hardware. Units are cm or inches, depending on units selected
	AttachHardwareNotes	VARCHAR(255)	Any relevant notes about this Hardware
	AttachHardwareWidth	DOUBLE	Width of Attachment Hardware
	AttachHardwareShape	VARCHAR(255)	Shape of Attachment Hardware
Indexes
	pk_AttachHardware	ON AttachHardwareKey
Foreign Keys
	Fk_AttachHardware	(AttachHardwareSpanKey) → Spans(SpanKey)
Referring Foreign Keys
	Fk_Attachments	(AttachHardwareKey) ← Attachments(AttachedToAttachHardware)

Table Attachments

Idx	Field Name	Data Type	Description
*	AttachmentKey	INTEGER
	AttachmentSpanKey	INTEGER
	AttachmentType	VARCHAR(255)	Type of attachment: Communications, Power, etc..
	SourceHeight	DOUBLE	Height above groundline
	TargetHeight	DOUBLE	Height above groundline
	WireDescription	VARCHAR(255)	Description of wire attachment
	WireOwner	VARCHAR(255)	Name of the wire owner. Used to locate details based on wire description
	WireSlack	BOOLEAN DEFAULT false	Is wire slack?
	WireNotes	VARCHAR(255)	Any notes about description or otherwise about this wire
	AttachedToAttachHardware	INTEGER
	AttachedToCrossarm	INTEGER
	InsulatorType	VARCHAR(255)	Description of Insulator, if any
	EccDist	DOUBLE	Distance from side of pole. Units in meters or feet, depending on units chosen
	EccAngle	DOUBLE	Relative to the center of the pole, enter direction in degrees of wire support.
	HeightAbsolute	BOOLEAN DEFAULT true	Is the height absolute? That is, are crossarm and insulator heights already included in the value?
	LashingWireIssue	BOOLEAN DEFAULT false	Does this attachment have a lashing wire issue?
	SpecialMountingNotes	VARCHAR(255)	Any special notes about how this attachment is supported or connected.
	WireMeasuredBundle	DOUBLE	If taken, enter the diameter of the wire bundle measured. Units are cm or inches, depending on units chosen.
	MidSpanheight	DOUBLE	Measurement of wire at approximately mid-span, above groundline
Indexes
	pk_Attachments	ON AttachmentKey
Foreign Keys
	Fk_Attachments	(AttachedToAttachHardware) → AttachHardware(AttachHardwareKey)
	Fk_Attachments	(AttachmentSpanKey) → Spans(SpanKey)

Table CivicAddresses

Idx	Field Name	Data Type	Description
*	CivicAddressKey	INTEGER
	CivicStructureKey	INTEGER
	CivicNumber	VARCHAR(255)	Civic number of dwelling served
	CivicStreet	VARCHAR(255)	Street on which this civic address is located
	CivicNotes	VARCHAR(255)	Any specific notes about this specific civic address
Indexes
	pk_CivicAddresses	ON CivicAddressKey
Foreign Keys
	Fk_CivicAddresses	(CivicStructureKey) → Structure(StructureKey)

Table ClearancePoints

Idx	Field Name	Data Type	Description
*	ClearancePointKey	INTEGER
	ClearanceSpanKey	INTEGER
	DistanceFromSource	DOUBLE	Distance from Source Structure
	ClearanceElevation	DOUBLE	Elevation at Clearance Point
	MeasuredHeightComm	DOUBLE	Measured Height above groundline
	ClearanceType	VARCHAR(255)	Type of Clearance requirement (ex. Street, pedestrian, etc.)
	IsMaxSagPoint	BOOLEAN DEFAULT false	Is this point at the maximum sag point of the wire?
	MeasureHeightLowestPower	DOUBLE	Measured height of the lowest power wire at this point
	MeasuredHeightCommAbove	DOUBLE	Measured height of the Communications wire above
	MeasuredHeightCommBelow	DOUBLE	Measured height of the communications wire below
	ClearanceNotes	VARCHAR(255)	Notes
	ClearanceItemType	VARCHAR(255)	Used to identify specific items at this point (Splice case, slack loop, service tap...)
	MidSpanStructureKey	INTEGER
Indexes
	pk_ClearancePoints	ON ClearancePointKey
Foreign Keys
	Fk_ClearancePoints	(ClearanceSpanKey) → Spans(SpanKey)
	Fk_ClearancePoints	(MidSpanStructureKey) → Structure(StructureKey)

Table FieldProject

Idx	Field Name	Data Type	Description
*	CollectionKey	INTEGER
	CollectionID	VARCHAR(255)	Identifier for this collection (optional)
	schemaVersion	INTEGER DEFAULT 1	Version of schema that this collection is based upon
	metric	BOOLEAN DEFAULT true	Are all measurements in metric?
	NorthCorrectionRequired	BOOLEAN DEFAULT false	If a regular compass was used for hardware direction, a correction to true north is required.
Indexes
	pk_FieldProject	ON CollectionKey
Referring Foreign Keys
	Fk_Structure	(CollectionKey) ← Structure(StructureCollectionKey)

Table Hardware

Idx	Field Name	Data Type	Description
*	HardwareKey	INTEGER
	HardwareStructureKey	INTEGER
	HardwareDescription	VARCHAR(255)	Description of the hardware item
	HardwareDirection	DOUBLE	Direction in degrees of where the hardware item is pointing/facing. Assumption is that a compass was used.
	HardwareQuantity	INTEGER DEFAULT 1	Number of items
	HardwareOwner	VARCHAR(255)	Owner of the Hardware. Used to locate details of this item
	HardwareHeight	DOUBLE	Height of the Top Bolt holding this hardware item, above groundline
	HardwareBottomHeight	DOUBLE	Height of the lowest part of the hardware item, above groundline
	HardwareNotes	VARCHAR(255)	Any specific notes about this item, such as voltage, KVA rating, etc..
Indexes
	pk_Hardware	ON HardwareKey
Foreign Keys
	Fk_Hardware	(HardwareStructureKey) → Structure(StructureKey)

Table Spans

Idx	Field Name	Data Type	Description
*	SpanKey	INTEGER
	SourceStructureKey	INTEGER
	TargetStructureKey	INTEGER
	SpanClearanceType	VARCHAR(255)	Type of least demanding clearance requirement in span (ex. Street, pedestrian, etc..)
	SpanType	VARCHAR(255)	optional description of span
	SpanVegetation	VARCHAR(255)	Notes about vegetation management issues in this span
	SpanPictureBaseDirectory	VARCHAR(255)	Base directory or url where span pictures will be kept
	SpanPicture1	VARCHAR(255)
	SpanPicture2	VARCHAR(255)
	SpanPicture3	VARCHAR(255)
	SpanPicture4	VARCHAR(255)
	SpanPicture5	VARCHAR(255)
	SpanPicture6	VARCHAR(255)
	SpanPicture7	VARCHAR(255)
	SpanPicture8	VARCHAR(255)
	SpanPicture9	VARCHAR(255)
	SpanPicture10	VARCHAR(255)
	SpanNotes	VARCHAR(255)	Notes related to this span
Indexes
	pk_Spans	ON SpanKey
Referring Foreign Keys
	Fk_AttachHardware	(SpanKey) ← AttachHardware(AttachHardwareSpanKey)
	Fk_Attachments	(SpanKey) ← Attachments(AttachmentSpanKey)
	Fk_ClearancePoints	(SpanKey) ← ClearancePoints(ClearanceSpanKey)

Table Structure

Idx	Field Name	Data Type	Description
*	StructureKey	INTEGER
*	StructureCollectionKey	INTEGER	Database linkage field. Set to collectionKey being entered/loaded
	Polenumber	VARCHAR(255)	Set as the Survey Pole number
	PoleID	VARCHAR(255)	Set as the main pole number
	AltPoleID	VARCHAR(255)	Set as the Alt pole number
	PoleTagImage	VARCHAR(255)	Filename for the picture of the pole tag
	PoleStampImage	VARCHAR(255)	Filename for the picture of the pole stamp
	PoleOwner	VARCHAR(255)	Name of the Pole Owner
	HeightAboveGround	DOUBLE	Distance from groundline to top of the pole (meters or feet, depending on units selected)
	PoleInspectionYear	INTEGER	Year of last pole inspection (eg. 2009)
	AirTemperature	DOUBLE	Air temperature at day of field data collection (Celcius or Fahrenheit, depending on units selected)
	PoleNotes	VARCHAR(255)	Any notes you'd like to record about this pole. Other notes fields exist for specific purposes
	PoleDamageNotes	VARCHAR(255)	Note any damages to the pole such as woodpecker holes, chunks taken out of pole, fire damage, broken crossarm, etc.
	PoleSafetyNotes	VARCHAR(255)	Any specific note or caution related to public or worker safety for this pole.
	InfrastructureType	VARCHAR(255) DEFAULT "Pole"	Type of item collected. Default is Pole. Many other types available
	GLcircumference	DOUBLE DEFAULT 0	Circumference of pole at groundline (cm or inches, depending on units chosen)
	PoleDiameter	DOUBLE DEFAULT 0	Diameter of pole at groundline. Better measure than GLC if risers present. (cm or inches, depending on units chosen)
	PoleUsage	VARCHAR(255)	Optional Notes about how pole is used, such as Tangent Pole, Stub Pole, etc..
	PoleCondition	VARCHAR(255) DEFAULT "Good"	General comment about pole condition. Examples: Good, Poor, Damaged
	PoleTransfersRequired	VARCHAR(255)	If pole transfers are pending, describe the attachment and/or attachment Owner that has transfers pending.
	PowerVGroundPresent	BOOLEAN DEFAULT false	Is there a Hydro vertical ground present on this pole? (Yes/No)
	CommVGroundOwner	VARCHAR(255)	If there is a vertical ground used by one or more communication attachments, describe its condition and what is bonded to it.
	AllCommsBonded	BOOLEAN DEFAULT true	Are all communication attachments (messengers/hardware) bonded together? (yes/no) at this pole
	PoleLashingWireIssue	VARCHAR(255)	If there is a lashing wire issue at this pole, specify which span and the attachment owner here.
	SwitchHandleBonded	VARCHAR(255)	If there is a mechanical power transfer switch controlling primary wires on this pole, identify if the switch handle near ground level is bonded or grounded.
	AllPowerUGuardsBonded	VARCHAR(255)	If there are Uguards over conduit/riser/power cables and they are metal, record if all of them are bonded or otherwise grounded
	ACATagPresent	BOOLEAN DEFAULT false	ACA tag is an example of a pole marked for replacement. Is this pole marked for replacement? (yes/no)
	PoleVegetationMgmtReqd	VARCHAR(255)	If vegetation management is an issue at this pole, record the appropriate notes
	AllStreetLightBonded	VARCHAR(255)	If there are streetlights at this pole, record notes about whether they all appear bonded or otherwise grounded.
	PredefinedBoltHoles	BOOLEAN DEFAULT false	This is an indicator if holes for new potential attachments are supposed to use holes already created in the pole. Examples would be concrete or steel poles with manufactured holes at specific locations.
	GuyWireIssueAtPole	VARCHAR(255)	Record notes about any guy wire issues at the pole.
	RiserGuardIssue	VARCHAR(255)	Record notes of any riser guard issues at the pole
	DateCollected	DATE DEFAULT sysdate	Date of field data collection
	GISLongitude	DOUBLE	Assumed Datum/zone is WGS84 to convert long/lats to Collection Datum/zone entries
	GISLattitude	DOUBLE	Assumed Datum/zone is WGS84 to convert long/lats to Collection Datum/zone entries
	Elevation	DOUBLE	Elevation for the base of the pole, anchor rod, etc
	Street	VARCHAR(255)	Street or similar description of the route this structure is on
	PoleSpecies	VARCHAR(255)	Species of wooden pole, or pole manufacturer
	PoleClass	VARCHAR(255)	Class of pole or Type of anchor. Any supplementary details
	Pole Type	VARCHAR(255)	Examples: Wood, Concrete, Steel, etc..
	BasePictureDirectory	VARCHAR(255)	Base directory or url where pictures for this structure are located
	Picture1	VARCHAR(255)
	Picture2	VARCHAR(255)
	Picture3	VARCHAR(255)
	Picture4	VARCHAR(255)
	Picture5	VARCHAR(255)
	Picture6	VARCHAR(255)
	Picture7	VARCHAR(255)
	Picture8	VARCHAR(255)
	Picture9	VARCHAR(255)
	Picture10	VARCHAR(255)
	Picture11	VARCHAR(255)
	PoleHeight	DOUBLE	Height of pole marked on pole stamp, in feet.
	InstallYear	CHAR(255)	Manufactured pole date/year marked on pole stamp. For age purposes, this is also the assumed year of installation.
	AnchorEyes	CHAR(255)	If structure is an anchor, the number of guy wires supported by anchor rod.
	AnchorRodSize	CHAR(255)	If structure is an anchor, the diametewr of the anchor rod.
	AnchorRodType	CHAR(255)	If structure is an anchor, the type of anchor rod. Examples would be forged or threaded head; which can help determine anchor details.
Indexes
	pk_Structure	ON StructureKey
	sqlite_autoindex_Structure_2	ON StructureCollectionKey
Foreign Keys
	Fk_Structure	(StructureCollectionKey) → FieldProject(CollectionKey)
Referring Foreign Keys
	Fk_CivicAddresses	(StructureKey) ← CivicAddresses(CivicStructureKey)
	Fk_ClearancePoints	(StructureKey) ← ClearancePoints(MidSpanStructureKey)
	Fk_Hardware	(StructureKey) ← Hardware(HardwareStructureKey)

Created with the Personal Edition of HelpNDoc: Easily create Qt Help files