// dot 2.28.0 on Windows 10 10.0
// SchemaSpy rev 590
digraph "oneDegreeRelationshipsDiagram" {
  graph [
    rankdir="RL"
    bgcolor="#f7f7f7"
    label="\nGenerated by SchemaSpy"
    labeljust="l"
    nodesep="0.18"
    ranksep="0.46"
    fontname="Helvetica"
    fontsize="11"
  ];
  node [
    fontname="Helvetica"
    fontsize="11"
    shape="plaintext"
  ];
  edge [
    arrowsize="0.8"
  ];
  "user_role":"role_id":w -> "role":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "user_role":"user_id":w -> "user_profile":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "role" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">role</TD></TR>
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
      <TR><TD PORT="title" COLSPAN="3" ALIGN="LEFT">title</TD></TR>
      <TR><TD PORT="site_ids" COLSPAN="3" ALIGN="LEFT">site_ids</TD></TR>
      <TR><TD PORT="permissions_ids" COLSPAN="3" ALIGN="LEFT">permissions_ids</TD></TR>
      <TR><TD PORT="menu_ids" COLSPAN="3" ALIGN="LEFT">menu_ids</TD></TR>
      <TR><TD PORT="place_ids" COLSPAN="3" ALIGN="LEFT">place_ids</TD></TR>
      <TR><TD PORT="site_id" COLSPAN="3" ALIGN="LEFT">site_id</TD></TR>
      <TR><TD PORT="active" COLSPAN="3" ALIGN="LEFT">active</TD></TR>
      <TR><TD PORT="creator" COLSPAN="3" ALIGN="LEFT">creator</TD></TR>
      <TR><TD PORT="created" COLSPAN="3" ALIGN="LEFT">created</TD></TR>
      <TR><TD PORT="modified" COLSPAN="3" ALIGN="LEFT">modified</TD></TR>
      <TR><TD PORT="modifier" COLSPAN="3" ALIGN="LEFT">modifier</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">6 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
    </TABLE>>
    URL="role.html"
    tooltip="role"
  ];
  "user_profile" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">user_profile</TD></TR>
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
      <TR><TD PORT="site_id" COLSPAN="3" ALIGN="LEFT">site_id</TD></TR>
      <TR><TD PORT="access_level" COLSPAN="3" ALIGN="LEFT">access_level</TD></TR>
      <TR><TD PORT="user_config_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">user_config_id</TD></TR>
      <TR><TD PORT="topic_ids" COLSPAN="3" ALIGN="LEFT">topic_ids</TD></TR>
      <TR><TD PORT="region_ids" COLSPAN="3" ALIGN="LEFT">region_ids</TD></TR>
      <TR><TD PORT="username" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">username</TD></TR>
      <TR><TD PORT="password" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">password</TD></TR>
      <TR><TD PORT="national_code" COLSPAN="3" ALIGN="LEFT">national_code</TD></TR>
      <TR><TD PORT="salt" COLSPAN="3" ALIGN="LEFT">salt</TD></TR>
      <TR><TD PORT="first_name" COLSPAN="3" ALIGN="LEFT">first_name</TD></TR>
      <TR><TD PORT="last_name" COLSPAN="3" ALIGN="LEFT">last_name</TD></TR>
      <TR><TD PORT="search_title" COLSPAN="3" ALIGN="LEFT">search_title</TD></TR>
      <TR><TD PORT="country" COLSPAN="3" ALIGN="LEFT">country</TD></TR>
      <TR><TD PORT="city" COLSPAN="3" ALIGN="LEFT">city</TD></TR>
      <TR><TD PORT="address" COLSPAN="3" ALIGN="LEFT">address</TD></TR>
      <TR><TD PORT="cell_number" COLSPAN="3" ALIGN="LEFT">cell_number</TD></TR>
      <TR><TD PORT="phone_number" COLSPAN="3" ALIGN="LEFT">phone_number</TD></TR>
      <TR><TD PORT="email" COLSPAN="3" ALIGN="LEFT">email</TD></TR>
      <TR><TD PORT="website" COLSPAN="3" ALIGN="LEFT">website</TD></TR>
      <TR><TD PORT="created" COLSPAN="3" ALIGN="LEFT">created</TD></TR>
      <TR><TD PORT="modified" COLSPAN="3" ALIGN="LEFT">modified</TD></TR>
      <TR><TD PORT="creator" COLSPAN="3" ALIGN="LEFT">creator</TD></TR>
      <TR><TD PORT="modifier" COLSPAN="3" ALIGN="LEFT">modifier</TD></TR>
      <TR><TD PORT="active" COLSPAN="3" ALIGN="LEFT">active</TD></TR>
      <TR><TD PORT="avatar" COLSPAN="3" ALIGN="LEFT">avatar</TD></TR>
      <TR><TD PORT="password_expired" COLSPAN="3" ALIGN="LEFT">password_expired</TD></TR>
      <TR><TD PORT="active_from" COLSPAN="3" ALIGN="LEFT">active_from</TD></TR>
      <TR><TD PORT="active_to" COLSPAN="3" ALIGN="LEFT">active_to</TD></TR>
      <TR><TD PORT="last_login_date" COLSPAN="3" ALIGN="LEFT">last_login_date</TD></TR>
      <TR><TD PORT="last_password_change" COLSPAN="3" ALIGN="LEFT">last_password_change</TD></TR>
      <TR><TD PORT="last_login_ip" COLSPAN="3" ALIGN="LEFT">last_login_ip</TD></TR>
      <TR><TD PORT="failed_login_date" COLSPAN="3" ALIGN="LEFT">failed_login_date</TD></TR>
      <TR><TD PORT="failed_login_count" COLSPAN="3" ALIGN="LEFT">failed_login_count</TD></TR>
      <TR><TD PORT="failed_login_ip" COLSPAN="3" ALIGN="LEFT">failed_login_ip</TD></TR>
      <TR><TD PORT="status" COLSPAN="3" ALIGN="LEFT">status</TD></TR>
      <TR><TD PORT="staus" COLSPAN="3" ALIGN="LEFT">staus</TD></TR>
      <TR><TD PORT="config" COLSPAN="3" ALIGN="LEFT">config</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">9 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">9 &gt;</TD></TR>
    </TABLE>>
    URL="user_profile.html"
    tooltip="user_profile"
  ];
  "user_role" [
    label=<
    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">user_role</TD></TR>
      <TR><TD PORT="id" COLSPAN="2" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD><TD PORT="id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD PORT="user_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">user_id</TD><TD PORT="user_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD PORT="role_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">role_id</TD><TD PORT="role_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD PORT="site_id" COLSPAN="2" ALIGN="LEFT">site_id</TD><TD PORT="site_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD PORT="active" COLSPAN="2" ALIGN="LEFT">active</TD><TD PORT="active.type" ALIGN="LEFT">bit[0]</TD></TR>
      <TR><TD PORT="creator" COLSPAN="2" ALIGN="LEFT">creator</TD><TD PORT="creator.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD PORT="created" COLSPAN="2" ALIGN="LEFT">created</TD><TD PORT="created.type" ALIGN="LEFT">timestamp[19]</TD></TR>
      <TR><TD PORT="modified" COLSPAN="2" ALIGN="LEFT">modified</TD><TD PORT="modified.type" ALIGN="LEFT">timestamp[19]</TD></TR>
      <TR><TD PORT="modifier" COLSPAN="2" ALIGN="LEFT">modifier</TD><TD PORT="modifier.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">11 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</TD></TR>
    </TABLE>>
    URL="user_role.html"
    tooltip="user_role"
  ];
}
