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