erd

Tables (3)

Member

  • Key (id) — Long — Primary key — NOT NULL
  • Field (username) — varchar
  • Field2 (password) — varchar
  • Field3 (nickname)
  • Field (profileImg)
  • Field (point)
  • Field (create_date)
  • Field (modify_date)
  • Field (provider_type_code) — varchar

Question

  • id — Primary key — NOT NULL
  • Field (name)
  • Field2 (difficulty)
  • Field3 (content)
  • Field (create_date)
  • Field (modify_date)
  • Field (type)
  • Key (member_id) — Long — Foreign key → Member.Key — NOT NULL

Untitled (Answer)

  • Key (id) — Primary key — NOT NULL
  • Field (create_date)
  • Field (modify_date)
  • Field (word1)
  • Field (word2)
  • Field (word3)
  • Field (content)
  • Field (result)