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)