Pupfluencer

Tables (10)

commentLikes

  • id — integer — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • UserId — integer — Foreign key → users.id — NOT NULL
  • CommentId — integer — Foreign key → comments.id — NOT NULL

comments

  • id — integer — Primary key — NOT NULL
  • target — integer — NOT NULL
  • comment — text — NOT NULL — ext NOT NUL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • UserId — integer — Foreign key → users.id — NOT NULL
  • PostId — integer — Foreign key → posts.id — NOT NULL

dogs

  • id — integer — Primary key — NOT NULL
  • name — character — NOT NULL
  • species — character — NOT NULL
  • weight — double — NOT NULL
  • birthday — date — NOT NULL
  • bringDate — date — NOT NULL
  • representative — boolean — NOT NULL
  • introduce — text — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • UserId — integer — Foreign key → users.id — NOT NULL
  • FileId — integer — Foreign key → files.id — NOT NULL

files

  • id — integer — Primary key — NOT NULL
  • contentUrl — text — NOT NULL
  • hash — text — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp

postFiles

  • id — integer — Primary key — NOT NULL
  • PostId — integer — Foreign key → posts.id
  • FileId — integer — Foreign key → files.id — NOT NULL

postLikes

  • id — integer — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • UserId — integer — Foreign key → users.id — NOT NULL
  • PostId — integer — Foreign key → posts.id — NOT NULL

posts

  • id — integer — Primary key — NOT NULL
  • title — text — NOT NULL
  • content — text — NOT NULL
  • category — text — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • UserId — integer — Foreign key → users.id — NOT NULL

todos

  • id — integer — Primary key — NOT NULL
  • content — text — NOT NULL
  • done — boolean — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • UserId — integer — Foreign key → users.id — NOT NULL

tokens

  • id — integer — Primary key — NOT NULL
  • token — text — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • UserId — integer — Foreign key → users.id — NOT NULL

users

  • id — integer — Primary key — NOT NULL
  • email — text — NOT NULL
  • password — text — NOT NULL
  • name — character
  • nickname — character
  • introduce — text
  • provider — character
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • FileId — integer — Foreign key → files.id