# This file just holds the schema, nothing more.

$schema = {
  person => {
    fields => {
      name => { type => 'varchar(50)' },
      birthdate => { type => 'date' },
    },
    key => 'id',
  },
  address => {
    fields => {
      name => { type => 'varchar(50)' },
      street => { type => 'varchar(100)' },
      city => { type => 'varchar(50)' },
      state => { type => 'varchar(20)' },
      zip => { type => 'varchar(10)' },
    },
  },
  lives_at => {
    refs => {
      person_id => { table => 'person', key => 'id' },
      address_id => { table => 'address' },
    },
  },
  book => {
    fields => {
      title => { type => 'varchar(100)' },
      date_published => { type => 'date' },
    },
  },
#  author => {
#    refs => {
#      person_id => { type => 'reference', table => 'person' },
#      book_id => { type => 'reference', table => 'book' },
#    },
#  },
  owns_book => {
    refs => {
      person_id => { type => 'reference', table => 'person' },
      book_id => { type => 'reference', table => 'book' },
    },
  },
};