dbpatterns

seren created new pattern

VERİTABANI

• BEBEK
• BID
• AnneID
• Ad
• Soyad
• ...

• ANNE
• AID
• Ad
• Soyad
• Mail
• ...

• ETKINLIK
• EID
• AnneID
• EAdi
• EAciklama
• ...

• TAKIP
• TID
• BebekID
• Ay
• Boy
• ...

2 months, 1 week ago

rabbal created new pattern

Product Dynamic Field

• Products
• id
• name
• price
• ...

• SpecificationAttributes
• id
• name

• SpecificationOptions
• id
• name
• attribute_id

• Product_Option
• id
• Option_id
• product_id
• displayOrder
• ...

2 months, 1 week ago

aki263 created new pattern

test

• foo
• id
• bar

• bar
• id
• foo

2 months, 1 week ago

jrock2004 created new pattern

Android App Addicts

• apps
• id
• show
• name
• link
• ...

• providers
• id
• full_name
• short_name
• image
• ...

• shows
• id
• name
• description
• air_date
• ...

2 months, 2 weeks ago

itken created new pattern

word book

• None
• id
• name
• email
• password

• word
• id
• word

• memory
• id

2 months, 2 weeks ago

milad forked a pattern

OAuth Connections

• user
• username

• oauth_connection
• username
• rank
• provider_id
• provider_user_id
• ...

• oauth_provider
• id
• name

2 months, 3 weeks ago

milad forked a pattern

Blog

• post
• id
• title
• body
• createDate
• ...

• user
• id
• username
• password
• email
• ...

• comment
• id
• title
• body
• date
• ...

• tag
• id
• name

2 months, 3 weeks ago

milad forked a pattern

Product Decorator

• Product
• id
• name

• Decorator
• id
• product_id
• field_name
• field_value

2 months, 3 weeks ago

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.

3 months ago

leadegroot created new pattern

email contact for multiple levels of business

• person
• idPerson
• namePerson
• more person fields

• emailAddress
• idEmail
• txEmailAddress
• person_id
• businessRole_id
• ...

• business
• idBusiness
• nameBusiness
• more business fields
• id_businessChain

• businessChain
• idChain
• nameChain
• more chain fields

3 months ago

leylaKapi created new pattern

Cold calling

• Company
• id
• name
• user_id

• Person
• id
• first_name
• last_name
• user_id

• User
• id
• first_name
• email
• password

• List
• id
• name
• user_id
• is_active

3 months ago

321campbell created new pattern

Pop Up Office Space Reservations

• Guest
• First Name
• Last Name
• Email
• Phone Number
• ...

• Host
• Business Name
• Property Type
• Property Address
• Business Email

• Event
• Reservation Code
• Guest id
• Host Business id
• Address
• ...

• Space Booker
• Host Business id
• Guest id
• address
• Date
• ...

3 months, 1 week ago

HalitGrpnr created new pattern

GeziYorum Database

• User
• id
• name
• surname
• birthday
• ...

• Post
• id
• user_id
• message
• address
• ...

• Comment
• id
• user_id
• post_id
• comment

• Vote
• id
• votable_id
• voter_id

3 months, 1 week ago

Xuan forked a pattern

HotelReservation

• GUESTS
• Guest_Id
• Fname
• Mname
• Lname
• ...

• RESERVATION

• ROOMS
• Room_No
• RoomType_Code
• Floor_No
• IsOccupied
• ...

• ROOM_TYPES
• RoomType_Code
• RoomType_Name
• Amenities
• Capacity
• ...

3 months, 1 week ago

Xuan created new pattern

s

• foo
• id
• bar

• bar
• id
• foo

3 months, 1 week ago

Xuan commented on a pattern

~test

3 months, 1 week ago

muminoff created new pattern

vtcc

• users
• phone_number
• username
• member_since
• photo

• rooms
• id
• subject
• created_at

• room_members
• room_id
• user
• is_admin

• room_messages
• id
• room_id
• sender
• sent_time

3 months, 2 weeks ago

leadegroot commented on a pattern

An Event is created. It has one or more Sessions. Persons are Invited to an Event. They RSVP for a specific session. Their eventual attendance is confirmed (or not)

3 months, 2 weeks ago

leadegroot created new pattern

Event Attendance

• Event
• idEvent
• nmEvent
• descOccasion
• txLinkDocument

• EventSession
• idEventSession
• event_id
• nmSessionSpecific
• dateSession

• Person
• idPerson

• EventInvitation
• idInvitation
• event_id
• person_id
• eventSession_id
• ...

3 months, 2 weeks ago

jamesfoster85 commented on a pattern

Should we consider the location being a lat and long instead of string? It would give the ability to sort by country, search for local projects, etc. Possibly a feature to put in the icebox at least.

3 months, 3 weeks ago