---
# System prepended metadata

title: 卒業制作データーベース構造

---

# 卒業制作データーベース構造

- item(作成した食べ物をすべて管理)[１品]
    - id: auto(number)
    - create_number: number (写真の順番)
    - image: array(string)
    - detail: string
    - price: number
    - create_seen: timestamp
    - update_seen: timestamp
    - tags: Array(number)
    - genre: number
    - user_id: number

- user(ユーザー情報)
    - id: auto(UUID)
    - name: string
    - image: string 
    - uniqueID: string
    - detail: string
    - create_seen: timestamp

- follow(フォローフォロバ)
    - id: auto(number)
    - follow_id: number
    - following_id: number

- like(いいね)
    - id: auto(number)
    - user_id: number
    - post_id: number

- bookmark(ブックマーク)
    - id: auto(number)
    - user_id: number
    - post_id: number

- daylight_hour(朝、昼、夜)
    - id: number
    - name: string

- post(投稿)[１食]
    - id: auto(number)
    - name: string
    - image: array(string)
    - detail: string
    - price: number
    - create_seen: timestamp
    - update_seen: timestamp
    - menu_id: number
    - menu_day: number
    - daylight_hours: number
    - isMenu: boolean
    - tags: Array(number)
    - genre: number
    - user_id: number

- made_post(作ったボタンを押したときに出る奴)
    - id: number
    - post_id: number
    - create_seen: timestamp
    - image: string
    - comment: string

- post_comment(投稿に対するコメント)
    - id: number
    - post_id: number
    - comment: string
    - create_seen: timestamp

- menu[献立]
    - id: number
    - post_id: Array(number)
    - all_price: number
    - tags: Array(number)
    - genre: number
    - user_id: number

- tag
    - id: number
    - name: string

- genre
    - id: number
    - name: string

- food
    - id: number
    - name: string
    - price: number
