// 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":"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_media":"media_id":w -> "media":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "news_media":"news_id":w -> "news":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "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"
  ];
  "news_media" [
    label=<
    <TABLE BORDER="2" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">news_media</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="type" COLSPAN="2" ALIGN="LEFT">type</TD><TD PORT="type.type" ALIGN="LEFT">smallint unsigned[5]</TD></TR>
      <TR><TD PORT="priority" COLSPAN="2" ALIGN="LEFT">priority</TD><TD PORT="priority.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 PORT="site_id" COLSPAN="2" ALIGN="LEFT">site_id</TD><TD PORT="site_id.type" ALIGN="LEFT">smallint[5]</TD></TR>
      <TR><TD PORT="internal" COLSPAN="2" ALIGN="LEFT">internal</TD><TD PORT="internal.type" ALIGN="LEFT">bit[0]</TD></TR>
      <TR><TD PORT="title" COLSPAN="2" ALIGN="LEFT">title</TD><TD PORT="title.type" ALIGN="LEFT">varchar[255]</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">&lt; 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">422 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">0 &gt;</TD></TR>
    </TABLE>>
    URL="news_media.html"
    tooltip="news_media"
  ];
}
