MyTodoList

Tables (4)

comment (Untitled4)

  • comment_idx (Key3) — int — Primary key — NOT NULL
  • user_idx (Key) — int — Foreign key → user.user_idx — NOT NULL
  • todolist_idx (Key2) — int — Foreign key → todolist.todolist_idx — NOT NULL
  • comment_content (Field) — varchar
  • comment_create_at (Field2) — timestamp

listDetail (Untitled3)

  • listDetail_idx (Key2) — int — Primary key — NOT NULL
  • todolist_idx (Key) — int — Foreign key → todolist.todolist_idx — NOT NULL
  • listDetail_content (Field) — varchar
  • is_completed (Field2) — boolean
  • listDetail_created_at (Field3) — timestamp

todolist (Untitled2)

  • todolist_idx (Key) — int — Primary key — NOT NULL
  • user_idx (Key2) — int — Foreign key → user.user_idx — NOT NULL
  • title (Field) — varchar
  • todolist_date (Field2) — date_format
  • is_public (Field3) — boolean
  • is_pw_protected (Field4) — boolean
  • todolist_pw (Field5) — nullable

user (Untitled)

  • user_idx (Key) — int — Primary key — NOT NULL
  • user_id (Field) — varchar
  • user_pw (Field2) — varchar
  • user_nickname (Field3) — varchar
  • user_intro (Field4) — varchar