todo

Tables (4)

Friend (Untitled3)

  • friendId (friend's ID) — bigint — Primary key — NOT NULL
  • is_followed (Follow?) — bool

Todo (Untitled)

  • todo_id (할일 아이디) — bigint — Primary key — NOT NULL
  • todo_content (할일 내용) — varchar(200)
  • todo_isChecked (할 일 체크여부) — bool
  • userId (UserID) — bigint — Foreign key → User.userId — NOT NULL

User (Untitled2)

  • userId (UserID) — bigint — Primary key — NOT NULL
  • userEmail (UserEmail) — varchar(30)
  • userPassword (UserPassword) — varchar(30)

User-Friend (Untitled4)

  • User-Friend — bigint — Primary key — NOT NULL
  • userId (UserID) — bigint — Foreign key → User.userId — NOT NULL
  • friendId (friend's ID) — bigint — Foreign key → Friend.friendId — NOT NULL