What is Leisure Bible?

Leisure Bible manages 5 data types including marketplace reports. Helps you organize, track, and share your work in 1 place for teams and solo users.

Database Schema & ERD

41 entities across 7 domain groups — click any entity to expand fields

Legend:PK Primary KeyFK Foreign Key (→ target)D Denormalised (computed/cached)All entities also have: created_date, updated_date

No duplication: Listing referenced by ID everywhere — never copied. User entity reused across all domains.

Geocoding consolidated: RoutePlanner and all map features use geocodeAddress() from listingService — single Nominatim caller.

Denormed fields: average_rating, review_count, listing_count are cached counts — update via service layer after mutations.

Listing.created_by_id→User.idOwner of the directory listing

Review.listing_id→Listing.idReviews belong to listings

Booking.listing_id→Listing.idBookings belong to listings

Booking.user_id→User.idGuest identity

BookingConfig.listing_id→Listing.id1:1 config per listing

BookingAvailability.listing_id→Listing.idMany availability records per listing

BookingAvailability.booking_id→Booking.idLinks blocked dates to booking

LeadEnquiry.converted_booking_id→Booking.idLead → Booking conversion tracking

BusinessSubscription.business_id→Listing.idSubscription is for a listing

BusinessSubscription.owner_id→User.idSubscription owner

AdCampaign.business_id→Listing.idCampaign runs for a business

TeamMember.business_id→Listing.idTeam belongs to a business

MarketplaceListing.seller_id→User.idSeller identity

MarketplaceListing.store_id→MarketplaceStore.idOptional dealer store link

MarketplaceEnquiry.listing_id→MarketplaceListing.idEnquiry thread per classified ad

Answer.question_id→Question.idAnswer belongs to a Q&A question

ContentSaved.content_id→ContentArticle.idType-discriminated (content_type field)

ContentArticle.related_listing_ids[]→Listing.idContent linked to directory listings

ClaimRequest.listing_id→Listing.idClaim request for a listing

Notification.user_id→User.idIn-app notification for a user

Core Platform4 entities

Reviews & Community9 entities

Bookings3 entities

Business Hub9 entities

Marketplace7 entities

Content Hub5 entities

Platform / Comms4 entities