Login | Datasets | Logout
 

VegBank Data Dictionary: Tables

  Search for a VegBank Table (enter a word, field name, etc.):    <<Hide search
Match any word
Match whole words only

   Search VegBank Fields Here

Show field labels | Show database names

DB Table Name telephone
Table Telephone
Notes Telephone numbers for the various individuals and organizations in the party table.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID TELEPHONE_ID no serial PK no Database generated identifier assigned to each unique telephone contact record.
Party PARTY_ID required Integer FK no This is the 'link' between a PARTY and an entry in the TELEPHONE table.
Phone Number phoneNumber required varchar (30) n/a no Telephone number.
Phone Type phoneType required varchar (20) n/a closed This is the type of telephone: home, work, fax, cell, secretary, other.