argos 해커톤

테이블 (5)

Calender (Untitled5)

  • random_integer (calender_id) — 기본 키 — NOT NULL
  • string (family_id) — 외래 키 → family.string — NOT NULL
  • random_integer (member_id) — 외래 키 → Member.random_integer — NOT NULL
  • date
  • double (success_rate)

Cheer (Untitled4)

  • random_integer (cheer_id) — 기본 키 — NOT NULL
  • randon_integer (todo_id) — 외래 키 → Todo.randon_integer — NOT NULL
  • random_integer (member_id)
  • mp3 (voice)

Member (Untitled2)

  • random_integer (member_id) — 기본 키 — NOT NULL
  • string (family_id) — 외래 키 → family.string — NOT NULL
  • string (name)
  • string (role)
  • mp3 (my_voice)
  • image (profile_image)

Todo (Untitled3)

  • randon_integer (todo_id) — 기본 키 — NOT NULL
  • random_integer (member_id) — 외래 키 → Member.random_integer — NOT NULL
  • string (todo)
  • string (todo_type) — workout or nutrition(enum)
  • List<string> (datetime)
  • tinyint (success_flag)
  • image (certifying_image)

family (Untitled)

  • string (family_id) — 기본 키 — NOT NULL
  • string (password)