todo-api
Tables (3)
Friend (친구)
- friend_id (Key) — bigint — Primary key — NOT NULL
- are_we_friend (Field3) — tinyint(1)
- from_member_id (Key2) — bigint — Foreign key → Member.member_id — NOT NULL
- to_member_id (Key3) — bigint — Foreign key → Member.member_id — NOT NULL
Member (멤버)
- member_id (Key) — bigint — Primary key — NOT NULL
- member_login_id (Field) — varchar(20)
- member_password (Field2) — varchar(20)
Todo (할 일)
- 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