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_tabledescriptionpartymemberwhere_tablenamepartyMember

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	partyMember
Table	Party Member
Notes	Allows parties to contain other parties within them, so that the children parties can have permissions of the parent parties.
Description	not implemented
Field DB Field Name Req'd? Data Type Misc Flag List? Definition Party Member ID partyMember_ID required serial PK no Database generated number to uniquely identify this record of this table. Main Party parentParty_ID required Integer FK no Link to the parent party to whom the child party here belongs. Sub-Party childParty_ID required Integer FK no Link to the child party who belongs to the parent listed in parentParty_ID. Role role_ID no Integer FK no Link to the role which defines the child's role in the parent party. Member Start memberStart required Date n/a no Start date for the child's membership in the parent party. Member Stop memberStop no Date n/a no Stop date for the child's membership in the parent party.