Haera-table

Tables (3)

Untitled (list-item)

  • Key (list-item_id) — bigint(20) — Primary key — NOT NULL
  • list_key (list_id) — bigint(20) — Foreign key → list.list_key — NOT NULL
  • Field (todo_text) — varchar(400) — NOT NULL
  • Field (status) — bool — NOT NULL

list

  • list_key (list_id) — bigint(20) — Primary key — NOT NULL
  • user_key (user_id) — bigint(20) — Foreign key → user.user_key — NOT NULL
  • Field (inquiry_status) — tinyint — NOT NULL

user

  • user_key (user_id) — bigint(20) — Primary key — NOT NULL
  • email — varchar(100) — NOT NULL
  • password — varchar(100) — NOT NULL
  • nickname — varchar(25) — NOT NULL