toyproject_x
Tables (6)
comment
- id — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- authorId — INT — Foreign key → user.id — NOT NULL
- tweetId — INT — Foreign key → tweet.id — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
follow
- id — INT — Primary key — NOT NULL
- followerId — INT — Foreign key → user.id — NOT NULL
- followingId — INT — Foreign key → user.id — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
like
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → user.id — NOT NULL
- tweetId — INT — Foreign key → tweet.id — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
tweet
- id — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- authorId — INT — Foreign key → user.id — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
tweet_image
- id — INT — Primary key — NOT NULL
- tweetId — INT — Foreign key → tweet.id — NOT NULL
- url — VARCHAR(255) — NOT NULL
user
- id — INT — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- refreshTokenHash — VARCHAR(255)
- bio — TEXT
- profileImage — VARCHAR(255)
- headerImage — VARCHAR(255)
- createdAt — DATETIME(6) — NOT NULL
- updatedAt — DATETIME(6) — NOT NULL