Skip to content

Instantly share code, notes, and snippets.

@lukemorton

lukemorton/table-definitions.markdown

Created January 13, 2011 13:51
Show Gist options
  • Save lukemorton/777871 to your computer and use it in GitHub Desktop.
Save lukemorton/777871 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
table-definitions.markdown

Denormalised

Orders

  • id
  • created
  • updated
  • building name
  • flat number
  • house number
  • street
  • city
  • county
  • country
  • status

Order Items

  • id
  • item_id
  • price

Normalised

Orders

  • id
  • created
  • updated
  • address_id
  • status_id

Order_Statuses

  • id
  • status

Order_Addresses

  • id
  • building name
  • flat number
  • house number
  • street
  • city
  • county
  • country

Order_Items

  • order_id
  • item_id
  • price_paid
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment