Project3

// Use DBML to define your database structure
// Docs: https://dbml.dbdiagram.io/docs

Table User {
  user_id integer [primary key]
  user_name string
  hero_name string
  level integer
  title string
  coin integer
  age integer
  background_id integer
  character_id integer
}

Table Diary {
  diary_id integer [primary key]
  contents string 
  user_id integer
  created_at timestamp
}

Table Quest {
  quest_id integer [primary key]
  contents string
  is_complete bool
  progress_time time
  complete_time time
  user_id integer
  type string
  created_at timestamp
}

Table Item {
  item_id integer [primary key]
  item_name string
  itme_price integer 
  itme_type enum
}

Table Receipt {
  receipt_id integer [primary key]
  user_id integer
  item_id integer
}


Ref: Diary.diary_id > User.user_id // many-to-one

Ref: Receipt.user_id > User.user_id

Ref: Receipt.item_id > Item.item_id

Ref: Quest.quest_id > User.user_id // many-to-one