PHONE table

PHONE – This table is used to store phone numbers for various objects in the Track-IT pro database.

Ÿ      ID – The unique ID for the phone number. (PK)

Ÿ      LINKID – The ID of the item the phone number is for. (FK)

Ÿ      LINKTYPE – The type of item the phone number is for.

Ÿ      NUMBER – The phone number.

Ÿ      DESC – A description for the phone number.

Ÿ      DISPLAY – Whether the item is the default displayed phone number for an object.