Table ptms..TripDistances

Column Name Type Length Nullable Description Relationships

Identity ID int identity No

PICKUP varchar 50 Yes

PADDRESS varchar 50 Yes

PCITY varchar 20 Yes

PSTATE varchar 2 Yes

PZIPCODE varchar 5 Yes

PZEXT varchar 4 Yes

PGISX numeric Yes

PGISY numeric Yes

DESTINATION varchar 50 Yes

DADDRESS varchar 50 Yes

DCITY varchar 20 Yes

DSTATE varchar 2 Yes

DZIPCODE varchar 5 Yes

DZEXT varchar 4 Yes

DGISX numeric Yes

DGISY numeric Yes

MILES numeric Yes

CLTID varchar 10 Yes

Timestamp datetime Yes

PickupID numeric Yes

PickupSource varchar 1 Yes

DestinationID numeric Yes

DestinationSource varchar 1 Yes

Indexes on this table

Index Name Index Description Index Keys

PK_TripDistances clustered, unique, primary key located on PRIMARY ID

Index Name	Index Description	Index Keys
PK_TripDistances	clustered, unique, primary key located on PRIMARY	ID