todo api

Tables (3)

Friend (Untitled3)

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

Member (Untitled)

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

Todo (Untitled2)

  • todo_id (Key) — bigint — Primary key — NOT NULL
  • todo_content (Field) — varchar(200)
  • todo_is_checked (Field2) — tinyint(1)
  • member_id (Key2) — bigint — Foreign key → Member.member_id — NOT NULL
  • todo_start_time (Field3) — date
  • todo_deadline (Field4) — date
  • todo_importance (Field5) — varchar(3)
  • todo_post_evaluation (Field6) — tinyint
  • todo_review (Field7) — varchar(200)