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`