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

Public Newsfeed

leadegroot created new pattern

Questionaires

  • Questionaire
  • idQuestionaire
  • nmQuestionaire
  • Question
  • idQuestion
  • questionaire_id
  • txQuestionPreamble
  • txQuestion
  • ...
  • QuestionHistory
  • idQuestionHistory
  • dtEntryHistory
  • user_id
  • question_id
  • ...
  • user
  • idUser

rabbal created new pattern

PrivateMessage

  • Conversations
  • Id
  • Subject
  • CreatedOn
  • IsSeen
  • ...
  • Messages
  • Id
  • Body
  • UserAgent
  • IsRead
  • ...
  • Users
  • Id
  • UserName
  • DisplayName
  • HashPassword
  • ...
  • Attachments
  • Id
  • FileName
  • ContentType
  • Extension
  • ...

rabbal created new pattern

Blog

  • Posts
  • Id
  • Title
  • Body
  • PublishedOn
  • ...
  • Comments
  • Id
  • Body
  • CreatorName
  • Parent_Id
  • ...
  • Attachments
  • Id
  • FileName
  • AttachedOn
  • Size
  • ...
  • Users
  • Id
  • UserName
  • HashPasswod
  • DisplayName
  • ...

milad forked a pattern

Product Dynamic Field

  • Products
  • id
  • name
  • price
  • ...
  • Attributes
  • id
  • name
  • AttributeOptions
  • id
  • name
  • attribute_id
  • Product_Option
  • id
  • attributeOption_id
  • product_id
  • displayOrder

milad forked a pattern

Blog

  • post
  • id
  • title
  • body
  • createDate
  • ...
  • user
  • id
  • username
  • password
  • email
  • ...
  • comment
  • id
  • title
  • body
  • date
  • ...
  • tag
  • id
  • name

leadegroot commented on a pattern

A Business may be part of a Chain (group of business under one brand). Chains and Businesses have Roles (Jobs, positions, titles). People fill those roles. An Emailaddress may go to a Person or it may go to a Role.