nomikui-match

nomikuiのマッチングサービス

---
title: nomikui-DB
---
erDiagram

  Nomikui ||--o{ Entry : ""
  Nomikui ||--|| Restaurant : ""
  Nomikui ||--|| User : ""

  Restaurant ||--|| Area : ""
  Restaurant ||--|| Genre : ""
  Restaurant ||--o{ Tags : ""
  Restaurant ||--o{ Favorite :""

  User ||--o{ Favorite : ""
  User ||--o{ Entry : ""

  Nomikui {
    uuid id PK
    uuid restaurantid FK "店ID"
    uuid organizerid FK "主催者"
    timestamp conducted_at "開催日時"
    bool isopen "募集中か"
    stringNULL picture "関連画像"
    stringNULL comment "備考"
  }

  Entry {
    uuid userid PK "対象ユーザID"
    uuid nomikuiid PK "対象nomikuiID"
    bool ispresent "出席するかしないか"
    timestamp entried_at "応募日時"
  }

  Restaurant {
    uuid id PK
    string name "店名"
    uuid areaid FK "エリアid"
    uuid genreid FK "ジャンルid"
    timestamp registered_at "登録日時"
    stringNULL picture "関連画像"
    stringNULL comment "備考"
  }

  User {
    uuid id PK
    string name "ユーザ名"
    string traQid "認証済traQid"
  }

  Area {
    uuid id PK
    string areaname "エリア名"
  }

  Genre {
    uuid id PK 
    string genrename "ジャンル名"
  }

  Tags {
    uuid id PK
    uuid restaurantid FK "店ID"
    string content "タグ名"
  }

  Favorite {
    uuid userid PK "ユーザID"
    uuid restaurantid PK "店ID"
  }

Loading