whateat

Tables (10)

USER_ATTENDANCE (Untitled7)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → member.Key — NOT NULL
  • date (Field)
  • is_success (Field2)
  • streak_count (Field3)

User_Quest (Untitled3)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → member.Key — NOT NULL
  • Key (Key3) — Foreign key → quest.Key — NOT NULL
  • reward (Field)
  • status (Field2)
  • started_at (Field3)
  • completed_at (Field4)

User_level (Untitled6)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → member.Key — NOT NULL
  • required_exp (Field)
  • bagde_name (Field2)
  • reword_point (Field3)

User_receipt (Untitled5)

  • Key — Primary key — NOT NULL
  • Key (Key3) — Foreign key → member.Key — NOT NULL
  • Key (Key2) — Foreign key → receipt.Key — NOT NULL

frige_item (Untitled10)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → refrigerator.Key — NOT NULL
  • Key (Key22) — Foreign key → refrigerator.Key — NOT NULL
  • Key (Key3) — Foreign key → ingredient.Key — NOT NULL
  • storage_type (냉동/대파/실온)
  • quantity (Field)
  • unit (g/ml/개)
  • expiration_date (Field2)
  • in_favorite (Field3)
  • create_at (Field4)

ingredient (Untitled9)

  • Key — Primary key — NOT NULL
  • name (Field)
  • default_unit (Field2)
  • image_url (Field3)

member (Untitled)

  • Key — Primary key — NOT NULL
  • 로그인 타입 (loginType)
  • level (Field)
  • email (Field2)
  • password (Field3)
  • nickname (Field4)
  • exp (Field5)
  • totalPoint (Field6)
  • create_at (Field7)

quest (Untitled2)

  • Key — Primary key — NOT NULL
  • title (Field)
  • description (Field2)
  • difficulty (Field3)
  • exp_reward (Field4)
  • point_reward (Field5)
  • is_daily (Field6)
  • created_at (Field7)

receipt (Untitled8)

  • Key — Primary key — NOT NULL
  • title (Field)
  • description (Field2)
  • difficult (Field3)
  • thumbnail_url (Field4)

refrigerator (Untitled4)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → member.Key — NOT NULL
  • name (Field)
  • create_at (Field2)