This week the focus was on completing a basic database schema for my web based mockup tool. The idea is to use this schema for my dashboard and other web based products.

I am designing the schema for mysql but I think it would be good to switch to sqlite instead. But atleast the schema is done and created on my local xampp.

Working on the PHP based member API.

Here are the list of tables

xcategory
xgroup
xgroup_category_map
xmembership_plan
xmembership_plan_detail
xobject
xobject_category_map
xobject_share
xobject_type
xplan_subscription
xprivilege
xrole
xrole_privilege_map
xuser
xuser_group_map

Posted in Pre-release