Login | Datasets | Logout
Jump to... Home PLOT search PLANT search COMMUNITY search Simple search Manage datasets Tutorial About FAQ ------- Site map VegBranch Data dictionary ERD

detaildba_tabledescriptiontelephonewhere_tablenametelephone

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 for VegBank Table >>

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.