toto api

Tables (3)

Friend

  • friend_id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → Member.member_id — NOT NULL
  • friend_member_id (Key3) — bigint — Foreign key → Member.member_id — NOT NULL

Member

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

Todo

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