Advertisement
Guest User

DB tables

a guest
Apr 5th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
DOT 1.18 KB | None | 0 0
  1. digraph tablichki {
  2.     rankdir=LR;
  3.     node [shape=plaintext, fontname="Verdana", fontsize="12"];
  4.  
  5.     tblOrder [label=<
  6.         <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0">
  7.             <TR><TD BGCOLOR="deepskyblue">Order</TD></TR>
  8.             <TR><TD ALIGN="LEFT" PORT="pk">ID int PK</TD></TR>
  9.             <TR><TD ALIGN="LEFT" PORT="fkPerson">PersonID int</TD></TR>
  10.             <TR><TD ALIGN="LEFT">Price float</TD></TR>
  11.             <TR><TD ALIGN="LEFT" PORT="fkCity">CityID int</TD></TR>
  12.         </TABLE>
  13.     >];
  14.    
  15.     tblPerson [label=<
  16.         <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0">
  17.             <TR><TD BGCOLOR="deepskyblue">Person</TD></TR>
  18.             <TR><TD ALIGN="LEFT" PORT="pk">ID int PK</TD></TR>
  19.             <TR><TD ALIGN="LEFT">Name varchar</TD></TR>
  20.         </TABLE>
  21.     >];
  22.    
  23.     tblCity [label=<
  24.         <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0">
  25.             <TR><TD BGCOLOR="deepskyblue">City</TD></TR>
  26.             <TR><TD ALIGN="LEFT" PORT="pk">ID int PK</TD></TR>
  27.             <TR><TD ALIGN="LEFT">Name varchar</TD></TR>
  28.         </TABLE>
  29.     >];
  30.    
  31.     tblOrder:fkPerson -> tblPerson:pk;
  32.     tblOrder:fkCity -> tblCity:pk;
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement