backend

Tables (11)

login_log

  • id — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — NOT NULL
  • loginTime — DATETIME — NOT NULL
  • logoutTime — DATETIME
  • INDEX — idx_login_user_time

media_favorites

  • mediaId — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • INDEX — idx_media_fav_user_time

media_likes

  • mediaId — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • INDEX — idx_media_likes_user_time

media_reports

  • id — BIGINT — Primary key — NOT NULL
  • mediaId — BIGINT — NOT NULL
  • reporterUserId — BIGINT — NOT NULL
  • reason — VARCHAR(255) — NOT NULL
  • status — ENUM('new','processed') — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • processedAt — DATETIME
  • processedByUserId — BIGINT
  • INDEX — idx_reports_status_time
  • INDEX — idx_reports_media

media_tags

  • mediaId — BIGINT — Primary key — NOT NULL
  • tagId — BIGINT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • INDEX — idx_media_tags_tag

planet_media

  • id — BIGINT — Primary key — NOT NULL
  • planetId — BIGINT — NOT NULL
  • type — ENUM('image','video') — NOT NULL
  • url — VARCHAR(1024) — NOT NULL
  • originalName — VARCHAR(255)
  • mimeType — VARCHAR(100)
  • sizeBytes — BIGINT — NOT NULL
  • description — TEXT
  • locationName — VARCHAR(255)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • INDEX — idx_media_planet

planet_tags

  • planetId — BIGINT — Primary key — NOT NULL
  • tagId — BIGINT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • INDEX — idx_planet_tags_tag

planets

  • id — BIGINT — Primary key — NOT NULL
  • starId — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • thumbnailMediaId — BIGINT
  • sortOrder — INT — NOT NULL
  • isDeleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • INDEX — idx_planets_star

stars

  • id — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • INDEX — idx_stars_user

tags

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • createdAt — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • passwordHash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • liveIn — VARCHAR(100)
  • role — ENUM('USER','ADMIN') — NOT NULL
  • status — ENUM('ACTIVE','SUSPENDED','BANNED') — NOT NULL
  • penaltyEndAt — DATETIME
  • reportCount — BIGINT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL