P2: wedding_planner_version_6_erd.erd

File wedding_planner_version_6_erd.erd, 4.6 KB (added by 212093, 5 days ago)
Line 
1<diagram version="1" name="wedding_planner_version_6.erd" time="202602042350"><entities><data-source id="postgres-jdbc-19af0cca867-724ac79220b3f51b"><entity id="1" name="user" fq-name="public.&quot;user&quot;" order="0" x="140" y="300"><path name="public"/><path name="ivanivanovski"/></entity><entity id="2" name="wedding" fq-name="public.wedding" order="1" x="480" y="320"><path name="public"/><path name="ivanivanovski"/></entity><entity id="3" name="registrar_booking" fq-name="public.registrar_booking" order="2" x="480" y="0"><path name="public"/><path name="ivanivanovski"/></entity><entity id="4" name="registrar" fq-name="public.registrar" order="3" x="800" y="20"><path name="public"/><path name="ivanivanovski"/></entity><entity id="5" name="photographer_booking" fq-name="public.photographer_booking" order="4" x="780" y="200"><path name="public"/><path name="ivanivanovski"/></entity><entity id="6" name="photographer" fq-name="public.photographer" order="5" x="1040" y="220"><path name="public"/><path name="ivanivanovski"/></entity><entity id="7" name="band_booking" fq-name="public.band_booking" order="6" x="820" y="480"><path name="public"/><path name="ivanivanovski"/></entity><entity id="8" name="band" fq-name="public.band" order="7" x="1040" y="500"><path name="public"/><path name="ivanivanovski"/></entity><entity id="9" name="church" fq-name="public.church" order="8" x="720" y="720"><path name="public"/><path name="ivanivanovski"/></entity><entity id="10" name="priest" fq-name="public.priest" order="9" x="960" y="720"><path name="public"/><path name="ivanivanovski"/></entity><entity id="11" name="venue_booking" fq-name="public.venue_booking" order="10" x="480" y="560"><path name="public"/><path name="ivanivanovski"/></entity><entity id="12" name="venue" fq-name="public.venue" order="11" x="480" y="840"><path name="public"/><path name="ivanivanovski"/></entity><entity id="13" name="venue_type" fq-name="public.venue_type" order="12" x="720" y="943"><path name="public"/><path name="ivanivanovski"/></entity><entity id="14" name="attendance" fq-name="public.attendance" order="13" x="100" y="560"><path name="public"/><path name="ivanivanovski"/></entity><entity id="15" name="guest" fq-name="public.guest" order="14" x="140" y="840"><path name="public"/><path name="ivanivanovski"/></entity><entity id="16" name="event_rsvp" fq-name="public.event_rsvp" order="15" x="-100" y="700"><path name="public"/><path name="ivanivanovski"/></entity><entity id="17" name="event" fq-name="public.&quot;event&quot;" order="16" x="-80" y="60"><path name="public"/><path name="ivanivanovski"/></entity></data-source></entities><relations><relation name="fk_wedding_user" fq-name="public.wedding.fk_wedding_user" type="fk" pk-ref="1" fk-ref="2"/><relation name="registrar_booking_wedding_id_fkey" fq-name="public.registrar_booking.registrar_booking_wedding_id_fkey" type="fk" pk-ref="2" fk-ref="3"/><relation name="fk_bb_wedding" fq-name="public.band_booking.fk_bb_wedding" type="fk" pk-ref="2" fk-ref="7"/><relation name="fk_church_wedding" fq-name="public.church.fk_church_wedding" type="fk" pk-ref="2" fk-ref="9"/><relation name="fk_vb_wedding" fq-name="public.venue_booking.fk_vb_wedding" type="fk" pk-ref="2" fk-ref="11"/><relation name="fk_event_wedding" fq-name="public.&quot;event&quot;.fk_event_wedding" type="fk" pk-ref="2" fk-ref="17"/><relation name="registrar_booking_registrar_id_fkey" fq-name="public.registrar_booking.registrar_booking_registrar_id_fkey" type="fk" pk-ref="4" fk-ref="3"/><relation name="vfk_wedding_?" type="vfk" pk-ref="5" fk-ref="2"/><relation name="fk_pb_photographer" fq-name="public.photographer_booking.fk_pb_photographer" type="fk" pk-ref="6" fk-ref="5"/><relation name="fk_bb_band" fq-name="public.band_booking.fk_bb_band" type="fk" pk-ref="8" fk-ref="7"/><relation name="fk_priest_church" fq-name="public.priest.fk_priest_church" type="fk" pk-ref="9" fk-ref="10"/><relation name="fk_vb_venue" fq-name="public.venue_booking.fk_vb_venue" type="fk" pk-ref="12" fk-ref="11"/><relation name="fk_venue_type" fq-name="public.venue.fk_venue_type" type="fk" pk-ref="13" fk-ref="12"/><relation name="vfk_wedding_attendance_16627" type="vfk" pk-ref="14" fk-ref="2"/><relation name="fk_att_guest" fq-name="public.attendance.fk_att_guest" type="fk" pk-ref="15" fk-ref="14"/><relation name="fk_rsvp_guest" fq-name="public.event_rsvp.fk_rsvp_guest" type="fk" pk-ref="15" fk-ref="16"/><relation name="fk_att_event" fq-name="public.attendance.fk_att_event" type="fk" pk-ref="17" fk-ref="14"/><relation name="fk_rsvp_event" fq-name="public.event_rsvp.fk_rsvp_event" type="fk" pk-ref="17" fk-ref="16"/></relations></diagram>