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