| 1 | <?xml version="1.0" encoding="UTF-8"?>
|
|---|
| 2 | <diagram version="1" name="Relational Diagram BookSwap">
|
|---|
| 3 | <entities>
|
|---|
| 4 | <data-source id="postgres-jdbc-1945480447f-7b9491fdb370e622">
|
|---|
| 5 | <entity id="1" name="appuser" fq-name="public.appuser">
|
|---|
| 6 | <path name="public"/>
|
|---|
| 7 | <path name="postgres"/>
|
|---|
| 8 | </entity>
|
|---|
| 9 | <entity id="2" name="book" fq-name="public.book">
|
|---|
| 10 | <path name="public"/>
|
|---|
| 11 | <path name="postgres"/>
|
|---|
| 12 | </entity>
|
|---|
| 13 | <entity id="3" name="bookisbn" fq-name="public.bookisbn">
|
|---|
| 14 | <path name="public"/>
|
|---|
| 15 | <path name="postgres"/>
|
|---|
| 16 | </entity>
|
|---|
| 17 | <entity id="4" name="bookrequest" fq-name="public.bookrequest">
|
|---|
| 18 | <path name="public"/>
|
|---|
| 19 | <path name="postgres"/>
|
|---|
| 20 | </entity>
|
|---|
| 21 | <entity id="5" name="friendrequest" fq-name="public.friendrequest">
|
|---|
| 22 | <path name="public"/>
|
|---|
| 23 | <path name="postgres"/>
|
|---|
| 24 | </entity>
|
|---|
| 25 | <entity id="6" name="genre" fq-name="public.genre">
|
|---|
| 26 | <path name="public"/>
|
|---|
| 27 | <path name="postgres"/>
|
|---|
| 28 | </entity>
|
|---|
| 29 | <entity id="7" name="library" fq-name="public."library"">
|
|---|
| 30 | <path name="public"/>
|
|---|
| 31 | <path name="postgres"/>
|
|---|
| 32 | </entity>
|
|---|
| 33 | <entity id="8" name="message" fq-name="public.message">
|
|---|
| 34 | <path name="public"/>
|
|---|
| 35 | <path name="postgres"/>
|
|---|
| 36 | </entity>
|
|---|
| 37 | <entity id="9" name="notification" fq-name="public.notification">
|
|---|
| 38 | <path name="public"/>
|
|---|
| 39 | <path name="postgres"/>
|
|---|
| 40 | </entity>
|
|---|
| 41 | <entity id="10" name="report" fq-name="public.report">
|
|---|
| 42 | <path name="public"/>
|
|---|
| 43 | <path name="postgres"/>
|
|---|
| 44 | </entity>
|
|---|
| 45 | <entity id="11" name="review" fq-name="public.review">
|
|---|
| 46 | <path name="public"/>
|
|---|
| 47 | <path name="postgres"/>
|
|---|
| 48 | </entity>
|
|---|
| 49 | <entity id="12" name="transaction" fq-name="public."transaction"">
|
|---|
| 50 | <path name="public"/>
|
|---|
| 51 | <path name="postgres"/>
|
|---|
| 52 | </entity>
|
|---|
| 53 | <entity id="13" name="transactionbook" fq-name="public.transactionbook">
|
|---|
| 54 | <path name="public"/>
|
|---|
| 55 | <path name="postgres"/>
|
|---|
| 56 | </entity>
|
|---|
| 57 | <entity id="14" name="usernotification" fq-name="public.usernotification">
|
|---|
| 58 | <path name="public"/>
|
|---|
| 59 | <path name="postgres"/>
|
|---|
| 60 | </entity>
|
|---|
| 61 | <entity id="15" name="wishlist" fq-name="public.wishlist">
|
|---|
| 62 | <path name="public"/>
|
|---|
| 63 | <path name="postgres"/>
|
|---|
| 64 | </entity>
|
|---|
| 65 | </data-source>
|
|---|
| 66 | </entities>
|
|---|
| 67 | <relations>
|
|---|
| 68 | <relation name="bookrequest_ownerid_fkey" fq-name="public.bookrequest.bookrequest_ownerid_fkey" type="fk" pk-ref="1" fk-ref="4"/>
|
|---|
| 69 | <relation name="bookrequest_requesterid_fkey" fq-name="public.bookrequest.bookrequest_requesterid_fkey" type="fk" pk-ref="1" fk-ref="4"/>
|
|---|
| 70 | <relation name="friendrequest_receiverid_fkey" fq-name="public.friendrequest.friendrequest_receiverid_fkey" type="fk" pk-ref="1" fk-ref="5"/>
|
|---|
| 71 | <relation name="friendrequest_senderid_fkey" fq-name="public.friendrequest.friendrequest_senderid_fkey" type="fk" pk-ref="1" fk-ref="5"/>
|
|---|
| 72 | <relation name="library_userid_fkey" fq-name="public."library".library_userid_fkey" type="fk" pk-ref="1" fk-ref="7"/>
|
|---|
| 73 | <relation name="message_receiverid_fkey" fq-name="public.message.message_receiverid_fkey" type="fk" pk-ref="1" fk-ref="8"/>
|
|---|
| 74 | <relation name="message_senderid_fkey" fq-name="public.message.message_senderid_fkey" type="fk" pk-ref="1" fk-ref="8"/>
|
|---|
| 75 | <relation name="report_reporteduserid_fkey" fq-name="public.report.report_reporteduserid_fkey" type="fk" pk-ref="1" fk-ref="10"/>
|
|---|
| 76 | <relation name="report_reportinguserid_fkey" fq-name="public.report.report_reportinguserid_fkey" type="fk" pk-ref="1" fk-ref="10"/>
|
|---|
| 77 | <relation name="review_giverid_fkey" fq-name="public.review.review_giverid_fkey" type="fk" pk-ref="1" fk-ref="11"/>
|
|---|
| 78 | <relation name="review_receiverid_fkey" fq-name="public.review.review_receiverid_fkey" type="fk" pk-ref="1" fk-ref="11"/>
|
|---|
| 79 | <relation name="transaction_borrowerid_fkey" fq-name="public."transaction".transaction_borrowerid_fkey" type="fk" pk-ref="1" fk-ref="12"/>
|
|---|
| 80 | <relation name="transaction_lenderid_fkey" fq-name="public."transaction".transaction_lenderid_fkey" type="fk" pk-ref="1" fk-ref="12"/>
|
|---|
| 81 | <relation name="usernotification_userid_fkey" fq-name="public.usernotification.usernotification_userid_fkey" type="fk" pk-ref="1" fk-ref="14"/>
|
|---|
| 82 | <relation name="wishlist_userid_fkey" fq-name="public.wishlist.wishlist_userid_fkey" type="fk" pk-ref="1" fk-ref="15"/>
|
|---|
| 83 | <relation name="bookisbn_bookid_fkey" fq-name="public.bookisbn.bookisbn_bookid_fkey" type="fk" pk-ref="2" fk-ref="3"/>
|
|---|
| 84 | <relation name="bookrequest_bookid_fkey" fq-name="public.bookrequest.bookrequest_bookid_fkey" type="fk" pk-ref="2" fk-ref="4"/>
|
|---|
| 85 | <relation name="genre_bookid_fkey" fq-name="public.genre.genre_bookid_fkey" type="fk" pk-ref="2" fk-ref="6"/>
|
|---|
| 86 | <relation name="library_bookid_fkey" fq-name="public."library".library_bookid_fkey" type="fk" pk-ref="2" fk-ref="7"/>
|
|---|
| 87 | <relation name="transactionbook_bookid_fkey" fq-name="public.transactionbook.transactionbook_bookid_fkey" type="fk" pk-ref="2" fk-ref="13"/>
|
|---|
| 88 | <relation name="wishlist_bookid_fkey" fq-name="public.wishlist.wishlist_bookid_fkey" type="fk" pk-ref="2" fk-ref="15"/>
|
|---|
| 89 | <relation name="notification_bookrequestid_fkey" fq-name="public.notification.notification_bookrequestid_fkey" type="fk" pk-ref="4" fk-ref="9"/>
|
|---|
| 90 | <relation name="transaction_requestid_fkey" fq-name="public."transaction".transaction_requestid_fkey" type="fk" pk-ref="4" fk-ref="12"/>
|
|---|
| 91 | <relation name="notification_friendrequestid_fkey" fq-name="public.notification.notification_friendrequestid_fkey" type="fk" pk-ref="5" fk-ref="9"/>
|
|---|
| 92 | <relation name="bookrequest_inventoryid_fkey" fq-name="public.bookrequest.bookrequest_inventoryid_fkey" type="fk" pk-ref="7" fk-ref="4"/>
|
|---|
| 93 | <relation name="transaction_inventoryid_fkey" fq-name="public."transaction".transaction_inventoryid_fkey" type="fk" pk-ref="7" fk-ref="12"/>
|
|---|
| 94 | <relation name="notification_messageid_fkey" fq-name="public.notification.notification_messageid_fkey" type="fk" pk-ref="8" fk-ref="9"/>
|
|---|
| 95 | <relation name="usernotification_notificationid_fkey" fq-name="public.usernotification.usernotification_notificationid_fkey" type="fk" pk-ref="9" fk-ref="14"/>
|
|---|
| 96 | <relation name="notification_transactionid_fkey" fq-name="public.notification.notification_transactionid_fkey" type="fk" pk-ref="12" fk-ref="9"/>
|
|---|
| 97 | <relation name="review_transactionid_fkey" fq-name="public.review.review_transactionid_fkey" type="fk" pk-ref="12" fk-ref="11"/>
|
|---|
| 98 | <relation name="transaction_swaptransactionid_fkey" fq-name="public."transaction".transaction_swaptransactionid_fkey" type="fk" pk-ref="12" fk-ref="12"/>
|
|---|
| 99 | <relation name="transactionbook_transactionid_fkey" fq-name="public.transactionbook.transactionbook_transactionid_fkey" type="fk" pk-ref="12" fk-ref="13"/>
|
|---|
| 100 | </relations>
|
|---|
| 101 | </diagram> |
|---|
