todo api

Tables (5)

Friend_with (Untitled5)

  • member_id (Key) — bigint — Foreign key → Member.member_id — NOT NULL
  • member_id (Key2) — bigint — Foreign key → Member.member_id — NOT NULL

Member (Untitled)

  • member_id (Key) — bigint — Primary key — NOT NULL
  • Field — varchar(20)

Member (Untitled3)

  • member_id (Key) — bigint — Primary key — NOT NULL
  • member_login_id (Field) — varchar(15)
  • member_pw (Field2) — varchar(15)

Todo (Untitled2)

  • todo_id (Key) — bigint — Primary key — NOT NULL
  • todo_is_checked (Field2) — tinyint(1)
  • todo_content (Field) — varchar(200)
  • member_id (Key2) — bigint — Foreign key → Member.member_id — NOT NULL

Todo

  • todo_id (Key) — Primary key — NOT NULL
  • todo_is_checked (Field) — tinyint(1)
  • todo_content (Field2) — varchar(200)
  • Field3
  • member_id (Key2) — Foreign key → Member.member_id — NOT NULL