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