J F W

making web application programming easier is possible

HOW TO : CORE

database schema

The classes that perform the authentication and authorization process need a database like this:


    users (users)
  1. user_id: user unique id
  2. user_name: the username
  3. user_password: the password
  4. user_desc: user description
    usergroup (groups)
  1. group_id: group unique id
  2. group_name: group name
  3. group_desc: group description
    user_group (relation users/usergroup)
  1. user_id: user unique id
  2. group_id: group unique id
    service (services/actions)
  1. service_id: service/action unique id
  2. service_name: service unique name
  3. service_desc: service description
  4. service_free: bypass authorization if 1
    user_service (relation users/service)
  1. user_id: user unique id
  2. service_id: service/action unique id
    service_group (relation service/usergroup)
  1. service_id: service/action unique id
  2. group_id: group unique id
    language (languages)
  1. language_id: language unique id
  2. language: language description
  3. code: language code
    menu (menus and relation menu/service)
  1. menu_id: menu unique id
  2. menu_name: menu name
  3. menu_order: menu order
  4. menu_parent: the menu_id of the parent menu
  5. service_id: service/action unique id
  6. visible: set menu visibility
  7. stick: menu always visible
    menu_locale (relation menu/language)
  1. menu_id: menu unique id
  2. language_id: language unique id
  3. menu_name: the menu name relative of the language
  4. menu_desc: the menu description relative of the language


This is the sql script for creating the database under MySQL for schema jfw and user jfw: