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