Sparta ToDoList
Tables (3)
Card
- Key (id) — long — Primary key — NOT NULL
- Key (member_id) — long — Foreign key → Member.Key — NOT NULL
- Field (title) — string
- Field (content) — string
- Field (is_done) — boolean
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (is_deleted) — boolean
Comment
- Key (id) — long — Primary key — NOT NULL
- Key (member_id) — long — Foreign key → Member.Key — NOT NULL
- Key (cart_id) — long — Foreign key → Card.Key — NOT NULL
- Field (content) — string
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (is_deleted) — boolean
Member
- Key (id) — long — Primary key — NOT NULL
- Field (user_id) — string
- Field (password) — string
- Field (name) — string