To do List

Tables (13)

Untitled (Member)

  • Key (member_no) — Primary key — NOT NULL
  • Field (member_id)
  • Field (member_pw)
  • Field (member_name)
  • Field (member_phone)
  • Field (member_email)
  • Field (member_hobby)

Untitled (WishList)

  • Key (wishlist_no) — Primary key — NOT NULL
  • Key (member_no) — Foreign key → Untitled.Key — NOT NULL
  • Field (wishlist_topic)
  • Field (wishlist_date)
  • Field (wishlist_detail)

Untitled (WishList_category)

  • Key (categorylist_no) — Primary key — NOT NULL
  • Key (member_no) — Foreign key → Untitled.Key — NOT NULL
  • Key (wishlist_no) — Foreign key → Untitled.Key — NOT NULL
  • Key (wide_no) — Foreign key → Untitled.Key — NOT NULL
  • Key (narrow_no) — Foreign key → Untitled.Key — NOT NULL

Untitled (Board)

  • Key (board_no) — Primary key — NOT NULL
  • Key (member_no) — Foreign key → Untitled.Key — NOT NULL
  • Field (topic)
  • Field (content)
  • Field2 (readcount)
  • Field (likecount)

Untitled (ToDoList)

  • Key (todolist_no) — Primary key — NOT NULL
  • Key (wishlist_no) — Foreign key → Untitled.Key — NOT NULL
  • Field (content)
  • Field (detail)

Untitled (FriendList)

  • Key (friendlist_no) — Primary key — NOT NULL
  • Key (member_no) — Foreign key → Untitled.Key — NOT NULL
  • Field (member_id)

Untitled (Friend_rankboard)

  • Key (rankboard_no) — Primary key — NOT NULL
  • Key (friendlist_no) — Foreign key → Untitled.Key — NOT NULL
  • Key (wishlist_no) — Foreign key → Untitled.Key — NOT NULL
  • Field (award)

Untitled (Viewbox)

  • Key (viewbox_no) — Primary key — NOT NULL
  • Key (wishlist_no) — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no) — Foreign key → Untitled.Key — NOT NULL

Untitled (Viewbox_image)

  • Key (image_no) — Primary key — NOT NULL
  • Key (viewbox_no) — Foreign key → Untitled.Key — NOT NULL
  • Field (image_link)
  • Field (image_original_filename)

Untitled (Wide_category)

  • Key (wide_no) — Primary key — NOT NULL
  • Field (category1)

Untitled (Narrow_category)

  • Key (narrow_no) — Primary key — NOT NULL
  • Field (category1)

Untitled (Board_reply)

  • Key (reply_no) — Primary key — NOT NULL
  • Key (board_no) — Foreign key → Untitled.Key — NOT NULL
  • Field (member_id)
  • Field (content)
  • Field (writedate)

Untitled (ToDoList_detail)

  • Key (detail_no) — Primary key — NOT NULL
  • Key (todolist_no) — Foreign key → Untitled.Key — NOT NULL
  • Field (timetable)
  • Field (checklist)
  • Field2 (place)