April 19th, 2012, 11:13 AM
I currently have a problem with inheritence. i have two types of members basic and full. i have to use advance postgreSQL techniques like, Arrays, Inheritence and Compisite types.
as both types have alot of the same information. member_id, first_name, last_name, address (which is compisite type) , contact number (array).
but still these two types need to be seperate as both pick activities. basic can pick up to 3 activites an no more, full can pick any amount.
so i decided to use inheritence, a parent table called members with all of the top information. then two child tables full_member and basic_member with the example in the paragraph above. but i need to decided were i shud says if a member is a full member or a basic member and be able to swap them between both types freely
im sorry this problem and explination is confusing any help would be greatly appricated.