PHONE table

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

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

• LINKID – The ID of the item the phone number is for.

• 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.