MoAPP

Tables (7)

Family (family)

  • ID — LONG — Primary key — NOT NULL
  • Member_Number — INT
  • Family_Name — VARCHAR
  • Created_Date — DATE

Family_Member (family_member)

  • ID — LONG — Primary key — NOT NULL
  • User_ID — LONG — Foreign key → User.ID — NOT NULL
  • Family_ID — LONG — Foreign key → Family.ID — NOT NULL
  • Role — INT
  • Poke_Count — INT
  • Talk_Count — INT

Family_Schedule (family_schedule)

  • ID — LONG — Primary key — NOT NULL
  • Family_ID — LONG — Foreign key → Family.ID — NOT NULL
  • Schedule_Name — VARCHAR
  • Schedule_Date — DATE

Interactions (Interaction)

  • ID — LONG — Primary key — NOT NULL
  • dst_member_id (User_ID) — LONG — Foreign key → Family_Member.User_ID — NOT NULL
  • dst_member_id (asdf) — LONG
  • isChecked — BOOLEAN
  • interactionType (INT) — INT

Photo (photo)

  • ID — LONG — Primary key — NOT NULL
  • family_ID — LONG — Foreign key → Family.ID — NOT NULL
  • S3_Image_URL — VARCHAR
  • Name — VARCHAR
  • Created_Date — DATE

Post (post)

  • ID — Primary key — NOT NULL
  • Src_Member_ID — LONG — Foreign key → Family_Member.ID — NOT NULL
  • Title — VARCHAR
  • Context — VARCHAR
  • Created_Date — DATE

User (user)

  • ID — LONG — Primary key — NOT NULL
  • Email — VARCHAR
  • PW — VARCHAR
  • Username — VARCHAR
  • Nickname — VARCHAR
  • Age — INT
  • Gender — INT