// 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"
  ];
  "news":"locker_id":w -> "user_profile":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "news":"recipient_id":w -> "user_profile":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "news_transition_log":"from_user_id":w -> "user_profile":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "news_transition_log":"news_id":w -> "news":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "news_transition_log":"to_user_id":w -> "user_profile":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "news" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">news</TD></TR>
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
      <TR><TD PORT="code" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">code</TD></TR>
      <TR><TD PORT="doc_num" COLSPAN="3" ALIGN="LEFT">doc_num</TD></TR>
      <TR><TD PORT="language" COLSPAN="3" ALIGN="LEFT">language</TD></TR>
      <TR><TD PORT="flags" COLSPAN="3" ALIGN="LEFT">flags</TD></TR>
      <TR><TD PORT="site_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">site_id</TD></TR>
      <TR><TD PORT="type_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">type_id</TD></TR>
      <TR><TD PORT="topic_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">topic_id</TD></TR>
      <TR><TD PORT="sub_topic_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">sub_topic_id</TD></TR>
      <TR><TD PORT="journalist_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">journalist_id</TD></TR>
      <TR><TD PORT="headline" COLSPAN="3" ALIGN="LEFT">headline</TD></TR>
      <TR><TD PORT="short_headline" COLSPAN="3" ALIGN="LEFT">short_headline</TD></TR>
      <TR><TD PORT="search_title" COLSPAN="3" ALIGN="LEFT">search_title</TD></TR>
      <TR><TD PORT="kicker" COLSPAN="3" ALIGN="LEFT">kicker</TD></TR>
      <TR><TD PORT="subhead" COLSPAN="3" ALIGN="LEFT">subhead</TD></TR>
      <TR><TD PORT="lead" COLSPAN="3" ALIGN="LEFT">lead</TD></TR>
      <TR><TD PORT="redirect_url" COLSPAN="3" ALIGN="LEFT">redirect_url</TD></TR>
      <TR><TD PORT="publish_date" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">publish_date</TD></TR>
      <TR><TD PORT="start_date" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">start_date</TD></TR>
      <TR><TD PORT="end_date" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">end_date</TD></TR>
      <TR><TD PORT="status" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">status</TD></TR>
      <TR><TD PORT="recipient_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">recipient_id</TD></TR>
      <TR><TD PORT="creator" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">creator</TD></TR>
      <TR><TD PORT="created" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">created</TD></TR>
      <TR><TD PORT="modifier" COLSPAN="3" ALIGN="LEFT">modifier</TD></TR>
      <TR><TD PORT="modified" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">modified</TD></TR>
      <TR><TD PORT="locker_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">locker_id</TD></TR>
      <TR><TD PORT="locked" COLSPAN="3" ALIGN="LEFT">locked</TD></TR>
      <TR><TD PORT="source_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">source_id</TD></TR>
      <TR><TD PORT="note" COLSPAN="3" ALIGN="LEFT">note</TD></TR>
      <TR><TD PORT="event_date" COLSPAN="3" ALIGN="LEFT">event_date</TD></TR>
      <TR><TD PORT="has_comment" COLSPAN="3" ALIGN="LEFT">has_comment</TD></TR>
      <TR><TD PORT="comment_approval" COLSPAN="3" ALIGN="LEFT">comment_approval</TD></TR>
      <TR><TD PORT="comment_headline" COLSPAN="3" ALIGN="LEFT">comment_headline</TD></TR>
      <TR><TD PORT="invisible_top" COLSPAN="3" ALIGN="LEFT">invisible_top</TD></TR>
      <TR><TD PORT="body_wcount" COLSPAN="3" ALIGN="LEFT">body_wcount</TD></TR>
      <TR><TD PORT="body_html_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">body_html_id</TD></TR>
      <TR><TD PORT="body_plain_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">body_plain_id</TD></TR>
      <TR><TD PORT="image_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">image_id</TD></TR>
      <TR><TD PORT="image2_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">image2_id</TD></TR>
      <TR><TD PORT="region_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">region_id</TD></TR>
      <TR><TD PORT="active" COLSPAN="3" ALIGN="LEFT">active</TD></TR>
      <TR><TD PORT="score_ed" COLSPAN="3" ALIGN="LEFT">score_ed</TD></TR>
      <TR><TD PORT="score_eic" COLSPAN="3" ALIGN="LEFT">score_eic</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 13</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">5,597 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">13 &gt;</TD></TR>
    </TABLE>>
    URL="news.html"
    tooltip="news"
  ];
  "news_transition_log" [
    label=<
    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">news_transition_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="news_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">news_id</TD><TD PORT="news_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD PORT="date" COLSPAN="2" ALIGN="LEFT">date</TD><TD PORT="date.type" ALIGN="LEFT">datetime[19]</TD></TR>
      <TR><TD PORT="from_user_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">from_user_id</TD><TD PORT="from_user_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD PORT="to_user_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">to_user_id</TD><TD PORT="to_user_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD PORT="from_state" COLSPAN="2" ALIGN="LEFT">from_state</TD><TD PORT="from_state.type" ALIGN="LEFT">tinyint unsigned[3]</TD></TR>
      <TR><TD PORT="to_state" COLSPAN="2" ALIGN="LEFT">to_state</TD><TD PORT="to_state.type" ALIGN="LEFT">tinyint unsigned[3]</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 3</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">5,104 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</TD></TR>
    </TABLE>>
    URL="news_transition_log.html"
    tooltip="news_transition_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"
  ];
}
