todo

Tables (4)

FOLLOW (Untitled3)

  • followIdx (Key) — Primary key — NOT NULL
  • toUser (Key3) — Primary key — NOT NULL
  • fromUser (Key4) — Foreign key → USER.userIdx — NOT NULL

LIKE (Untitled4)

  • likeIdx (Key) — Primary key — NOT NULL
  • userIdx (Key2) — Foreign key → USER.userIdx — NOT NULL
  • postIdx (Key3) — Foreign key → POST.postIdx — NOT NULL

POST (Untitled2)

  • postIdx (Key) — Primary key — NOT NULL
  • userIdx (Key3) — Foreign key → USER.userIdx — NOT NULL
  • title (Field)
  • description (Field2)
  • shared (Field3)
  • startDate (Field4)
  • endDate (Field5)
  • completed (Field6) — bool
  • like (Field7)

USER (Untitled)

  • userIdx (Key) — Primary key — NOT NULL
  • email (Field)
  • password (Field2)
  • name (Field3)
  • profileImage (Field9)
  • status (Field4)
  • created_at (Field5)
  • updated_at (Field7)
  • login_at (Field6)
  • login_cnt (Field8)