mysql - Social network - Privacy levels - database schema -

i creating user profiles , have few questions relating schema privacy levels:

for profile details -> there multiple fields on facebook - birthday, gender, location, interests, relationships, user's full name etc. database point of view - how done? using mysql first thing can privacy levels work in mysql or need non relational db? then, assign privacy field level this:

object table -> profile field 1, profile field 2,.....
privacy lookup table -> friends = 1, friend of friend = 2, = 3, blocked list = 4,...
user object table -> profile field 1 has privacy lookup 1 (which means field 2 set friends only)?

the above works fixed list privacy level if have non list privacy levels example: want block person x, y & z , allow user named see it, there no fixed levels this, how represent @ schema level?

this filed level privacy @ higher object level individual photos, individual videos, etc. general suggestions on db use / basic schema guide me on how design out?

thanks.

what can implement entity relationship modeling let unlimited list of privacy.

you can have tables thise :

privacy id    varchar(36) label text()  isprivacyactivated privacyid      varchar(36) isactivated    boolean  userprivacy userid   varchar(36) privacyid varchar(36) 

this way can implements features stated above easily.

hope help,