// 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"
  ];
  "entity_audit_log":"user_id":w -> "user_profile":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "entity_audit_log" [
    label=<
    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">entity_audit_log</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="date" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">date</TD><TD PORT="date.type" ALIGN="LEFT">datetime[19]</TD></TR>
      <TR><TD PORT="action_code" COLSPAN="2" ALIGN="LEFT">action_code</TD><TD PORT="action_code.type" ALIGN="LEFT">tinyint unsigned[3]</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="entity_class" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">entity_class</TD><TD PORT="entity_class.type" ALIGN="LEFT">varchar[30]</TD></TR>
      <TR><TD PORT="entity_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">entity_id</TD><TD PORT="entity_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD PORT="entity_title" COLSPAN="2" ALIGN="LEFT">entity_title</TD><TD PORT="entity_title.type" ALIGN="LEFT">varchar[200]</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">7,685 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</TD></TR>
    </TABLE>>
    URL="entity_audit_log.html"
    tooltip="entity_audit_log"
  ];
  "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"
  ];
}
