sketchwebapp

Tables (3)

Comment (댓글)

  • id (댓글uuid) — UUID — Primary key — NOT NULL
  • author (유저uuid) — UUID — Foreign key → User.id — NOT NULL
  • picture (그림uuid) — UUID — Foreign key → Picture.id — NOT NULL
  • comment (댓글내용) — STRING

Picture (그림)

  • id (그림uuid) — UUID — Primary key — NOT NULL
  • author (작성자) — UUID — Foreign key → User.id — NOT NULL
  • title (제목) — STRING
  • answer (정답) — STRING
  • objectData (객제정보) — STRING
  • imageData (그림정보) — STRING
  • commentNumber (댓글수) — NUMBER
  • isSolved (정답여부) — BOOLEAN

User (유저)

  • id (유저uuid) — UUID — Primary key — NOT NULL
  • user_id (유저id) — STRING
  • password (비밀번호) — STRING
  • salt (솔트) — STRING
  • name (닉네임) — STRING