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