Dbpatterns is a service that allows you to create, share, explore database models on the web.

Public Newsfeed

hasantayyar forked a pattern

HotelReservation

  • GUESTS
  • Guest_Id
  • Fname
  • Mname
  • Lname
  • ...
  • RESERVATION
  • Reservation_Code
  • Guest_Id
  • Date
  • Check-In_Date
  • ...
  • ROOMS
  • Room_No
  • RoomType_Code
  • Floor_No
  • IsOccupied
  • ...
  • ROOM_TYPES
  • RoomType_Code
  • RoomType_Name
  • Amenities
  • Capacity
  • ...

altermyway forked a pattern

HotelReservation

  • GUESTS
  • Guest_Id
  • Fname
  • Mname
  • Lname
  • ...
  • RESERVATION
  • Reservation_Code
  • Guest_Id
  • Date
  • Check-In_Date
  • ...
  • ROOMS
  • Room_No
  • RoomType_Code
  • Floor_No
  • IsOccupied
  • ...
  • ROOM_TYPES
  • RoomType_Code
  • RoomType_Name
  • Amenities
  • Capacity
  • ...

kabutino forked a pattern

Room Reservations

  • Room
  • id
  • name
  • description
  • height
  • ...
  • Resources
  • id
  • name
  • description
  • price
  • ...
  • PriceList
  • id
  • id_room
  • day
  • date
  • ...
  • Reservations
  • id
  • id_room
  • date
  • time_from
  • ...

pills created new pattern

RealTimeData

  • Flight
  • id
  • source
  • destination
  • departure_date
  • ...
  • Hotel
  • id
  • location
  • name
  • rating
  • ...
  • Rental Car
  • id
  • company_name
  • rate_per_day
  • location
  • ...
  • Destination
  • destination_id
  • city
  • best_price
  • flight
  • ...