Gryllo
Tables (8)
User (Untitled)
- id — integer — Primary key — NOT NULL
- 소개 (bio) — varchar(255)
- 가입일 (createDate) — datetime(6)
- 이메일 (email) — varchar(255) — NOT NULL
- 이름 (name) — varchar(255) — NOT NULL
- 비밀번호 (password) — varchar(255) — NOT NULL
- 프로필사진 (profileImage) — varchar(255)
- 권한 (role) — varchar(255)
- 유저이름 (username) — varchar(255) — NOT NULL
chatting (Untitled8)
- id — integer — Primary key — NOT NULL
- 작성일 (createDate) — datetime — NOT NULL
- 내용 (meggage) — varchar(255) — NOT NULL
- 보낸사람 (fromUserId) — integer — Foreign key → User.id — NOT NULL
- 받은사람 (toUserId) — integer — Foreign key → User.id — NOT NULL
comment (Untitled3)
- id — integer — Primary key — NOT NULL
- 게시글 (ImageId) — Integer — Foreign key → image.id — NOT NULL
- 유저정보 (userId) — integer — Foreign key → User.id — NOT NULL
- id (id2) — integer — Foreign key → image.작성자 — NOT NULL
- 내용 (content) — varchar(255) — NOT NULL
- createDate (Field2) — datetime — NOT NULL
follow (Untitled7)
- id — integer — Primary key — NOT NULL
- 작성일 (createdate) — datetime — NOT NULL
- 보낸사람 (fromUserId) — integer — Foreign key → User.id — NOT NULL
- 받은사람 (toUserId) — integer — Foreign key → User.id — NOT NULL
image (Untitled4)
- id — Integer — Primary key — NOT NULL
- 작성자 (userId) — integer — Foreign key → User.id — NOT NULL
- 내용 (caption) — varchar(255) — NOT NULL
- 작성일 (createDate) — datetime — NOT NULL
- 장소 (location) — varchar(255)
- 사진주소 (ImageUrl) — varchar(255) — NOT NULL
like (Untitled6)
- id — integer — Primary key — NOT NULL
- 아이디 (userId) — integer — Foreign key → User.id — NOT NULL
- 게시글정보 (ImageId) — Integer — Foreign key → image.id — NOT NULL
- id (id2) — integer — Foreign key → image.작성자 — NOT NULL
- 작성일 (createDate) — datetime — NOT NULL
noti (Untitled2)
- id — integer — Primary key — NOT NULL
- 시간 (createDate) — NOT NULL
- 알람유형 (notiType) — varchar(255) — NOT NULL
- 보낸사람 (fromUserId) — integer — Foreign key → User.id — NOT NULL
- 받는사람 (toUserId) — integer — Foreign key → User.id — NOT NULL
tag (Untitled5)
- id — integer — Primary key — NOT NULL
- 게시글 (ImageId) — Integer — Foreign key → image.id — NOT NULL
- id (id2) — integer — Foreign key → image.작성자 — NOT NULL
- 작성일 (createDate) — datetime — NOT NULL
- 이름 (name) — varchar(255) — NOT NULL