devootttt
Tables (3)
follow
- id — BIGINT — Primary key — NOT NULL
- follower_id — BIGINT — NOT NULL
- followed_id — BIGINT — NOT NULL
- allowed — BOOLEAN — NOT NULL
- INDEX — `idx_follower_id`
- INDEX — `idx_followed_id`
notification
- id — BIGINT — Primary key — NOT NULL
- to_user_id — BIGINT — NOT NULL
- from_user_id — BIGINT — NOT NULL
- follow_id — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- has_read — BOOLEAN — NOT NULL
- INDEX — `idx_to_user_id`
- INDEX — `idx_follow_id`
- INDEX — `idx_from_user_id`
user
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- profileId — VARCHAR(15)
- nickname — VARCHAR(18)
- links — JSON
- isPublic — BOOLEAN
- imageUrl — VARCHAR(200)
- uid — VARCHAR(128) — NOT NULL
- tags — VARCHAR(100)
- createdAt — TIMESTAMP — NOT NULL
- isBlocked — BOOLEAN
- INDEX — `idx_profileid`
- INDEX — `idx_nickname`