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

Public Newsfeed

sm873x created new pattern

Work Database

  • Employees
  • employee_id (PK)
  • first_name
  • last_name
  • email
  • ...
  • Team Member
  • project_id
  • employee_id
  • Projects
  • id (PK)
  • client_id (FK)
  • project_name
  • started_on
  • ...
  • Clients
  • id (PK)
  • project_id (FK)
  • company_name
  • client_rep
  • ...

kenanpol created new pattern

ArxivingSystem

  • Users
  • UserID
  • FirstName
  • LastName
  • Email
  • ...
  • Affiliations
  • UserID
  • University
  • Department
  • Position
  • Contact_Info
  • UserID
  • Address
  • City
  • Country
  • ...
  • Social_Profiles
  • UserID
  • Twitter
  • Github
  • Website
  • ...

bobderrico80 created new pattern

Yadaguru

  • Users
  • id
  • phoneNumber
  • confirmCode
  • confirmCodeExpires
  • ...
  • Schools
  • id
  • userId
  • name
  • dueDate
  • ...
  • Reminders
  • id
  • schoolId
  • timeframe
  • dueDate
  • ...
  • BaseReminders
  • id
  • name
  • categoryId
  • message
  • ...

emre created new pattern

BiMarkup

  • BiMarkup
  • lead_date_ranges
  • basket_value_ranges
  • version
  • is_active
  • ...
  • BiMarkupItem
  • category
  • lead_date_to
  • lead_date_from
  • basket_value_to
  • ...
  • BiMarkupCategory
  • category_code
  • hotels

emre created new pattern

BiMarkup

  • bimarkup_lead_date_ranges
  • id
  • bimarkup_id
  • leaddaterange_id
  • bimarkup_basket_value_ranges
  • id
  • bimarkup_id
  • basketvaluerange_id
  • bimarkup_items
  • id
  • bimarkup_id
  • bimarkupitem_id
  • bimarkup
  • id
  • version
  • is_active
  • created_at

hsyncmn created new pattern

twitter

  • user
  • user_id
  • email
  • password
  • name
  • ...
  • Tweet
  • tweet_id
  • user_id
  • text
  • tw_date
  • ...
  • message
  • ms_id
  • user_id
  • text
  • ms_date
  • ...
  • photo
  • photo_id
  • user_id
  • text
  • ph_text
  • ...