// 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_tag":"media_id":w -> "media":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "entity_tag":"news_id":w -> "news":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "entity_tag":"person_id":w -> "person":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "entity_tag":"tag_option_id":w -> "tag_option":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "media":"photographer_id":w -> "person":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "news":"image2_id":w -> "media":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "news":"image_id":w -> "media":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "news":"journalist_id":w -> "person":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "entity_tag" [
    label=<
    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">entity_tag</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="media_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">media_id</TD><TD PORT="media_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD PORT="tag_item_id" COLSPAN="2" ALIGN="LEFT">tag_item_id</TD><TD PORT="tag_item_id.type" ALIGN="LEFT">tinyint unsigned[3]</TD></TR>
      <TR><TD PORT="tag_item_type" COLSPAN="2" ALIGN="LEFT">tag_item_type</TD><TD PORT="tag_item_type.type" ALIGN="LEFT">tinyint unsigned[3]</TD></TR>
      <TR><TD PORT="tag_option_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">tag_option_id</TD><TD PORT="tag_option_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD PORT="person_id" COLSPAN="2" BGCOLOR="#f4f7da" ALIGN="LEFT">person_id</TD><TD PORT="person_id.type" ALIGN="LEFT">int unsigned[10]</TD></TR>
      <TR><TD PORT="tag_item_value" COLSPAN="2" ALIGN="LEFT">tag_item_value</TD><TD PORT="tag_item_value.type" ALIGN="LEFT">varchar[150]</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; 4</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">141 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</TD></TR>
    </TABLE>>
    URL="entity_tag.html"
    tooltip="entity_tag"
  ];
  "media" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">media</TD></TR>
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
      <TR><TD PORT="type" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">type</TD></TR>
      <TR><TD PORT="site_id" COLSPAN="3" ALIGN="LEFT">site_id</TD></TR>
      <TR><TD PORT="photographer_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">photographer_id</TD></TR>
      <TR><TD PORT="title" COLSPAN="3" ALIGN="LEFT">title</TD></TR>
      <TR><TD PORT="search_title" COLSPAN="3" ALIGN="LEFT">search_title</TD></TR>
      <TR><TD PORT="des" COLSPAN="3" ALIGN="LEFT">des</TD></TR>
      <TR><TD PORT="repos" COLSPAN="3" ALIGN="LEFT">repos</TD></TR>
      <TR><TD PORT="entity" COLSPAN="3" ALIGN="LEFT">entity</TD></TR>
      <TR><TD PORT="original_filename" COLSPAN="3" ALIGN="LEFT">original_filename</TD></TR>
      <TR><TD PORT="original_size" COLSPAN="3" ALIGN="LEFT">original_size</TD></TR>
      <TR><TD PORT="original_format" COLSPAN="3" ALIGN="LEFT">original_format</TD></TR>
      <TR><TD PORT="original_width" COLSPAN="3" ALIGN="LEFT">original_width</TD></TR>
      <TR><TD PORT="original_height" COLSPAN="3" ALIGN="LEFT">original_height</TD></TR>
      <TR><TD PORT="original_bitrate" COLSPAN="3" ALIGN="LEFT">original_bitrate</TD></TR>
      <TR><TD PORT="duration" COLSPAN="3" ALIGN="LEFT">duration</TD></TR>
      <TR><TD PORT="owner" COLSPAN="3" ALIGN="LEFT">owner</TD></TR>
      <TR><TD PORT="personals" COLSPAN="3" ALIGN="LEFT">personals</TD></TR>
      <TR><TD PORT="places" COLSPAN="3" ALIGN="LEFT">places</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="modifier" COLSPAN="3" ALIGN="LEFT">modifier</TD></TR>
      <TR><TD PORT="modified" COLSPAN="3" ALIGN="LEFT">modified</TD></TR>
      <TR><TD PORT="deleted" COLSPAN="3" ALIGN="LEFT">deleted</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4,909 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">11 &gt;</TD></TR>
    </TABLE>>
    URL="media.html"
    tooltip="media"
  ];
  "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"
  ];
  "person" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">person</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="gender" COLSPAN="3" ALIGN="LEFT">gender</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="prefix_name" COLSPAN="3" ALIGN="LEFT">prefix_name</TD></TR>
      <TR><TD PORT="print_name" COLSPAN="3" ALIGN="LEFT">print_name</TD></TR>
      <TR><TD PORT="search_title" COLSPAN="3" ALIGN="LEFT">search_title</TD></TR>
      <TR><TD PORT="journalist" COLSPAN="3" ALIGN="LEFT">journalist</TD></TR>
      <TR><TD PORT="photographer" COLSPAN="3" ALIGN="LEFT">photographer</TD></TR>
      <TR><TD PORT="initial" COLSPAN="3" ALIGN="LEFT">initial</TD></TR>
      <TR><TD PORT="job_title" COLSPAN="3" ALIGN="LEFT">job_title</TD></TR>
      <TR><TD PORT="b_date" COLSPAN="3" ALIGN="LEFT">b_date</TD></TR>
      <TR><TD PORT="biography" COLSPAN="3" ALIGN="LEFT">biography</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="cell_phone" COLSPAN="3" ALIGN="LEFT">cell_phone</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">1 row</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4 &gt;</TD></TR>
    </TABLE>>
    URL="person.html"
    tooltip="person"
  ];
  "tag_option" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">tag_option</TD></TR>
      <TR><TD PORT="id" COLSPAN="3" BGCOLOR="#bed1b8" ALIGN="LEFT">id</TD></TR>
      <TR><TD PORT="item_id" COLSPAN="3" BGCOLOR="#f4f7da" ALIGN="LEFT">item_id</TD></TR>
      <TR><TD PORT="site_id" COLSPAN="3" ALIGN="LEFT">site_id</TD></TR>
      <TR><TD PORT="option_order" COLSPAN="3" ALIGN="LEFT">option_order</TD></TR>
      <TR><TD PORT="title" COLSPAN="3" ALIGN="LEFT">title</TD></TR>
      <TR><TD PORT="title2" COLSPAN="3" ALIGN="LEFT">title2</TD></TR>
      <TR><TD PORT="active" COLSPAN="3" ALIGN="LEFT">active</TD></TR>
      <TR><TD PORT="score" COLSPAN="3" ALIGN="LEFT">score</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">&lt; 1</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">4 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 &gt;</TD></TR>
    </TABLE>>
    URL="tag_option.html"
    tooltip="tag_option"
  ];
}
