sound-bind

Tables (13)

Untitled (user_password)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Field (pasword) — varchar(255)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (user_profile)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Field (email) — varchar(255)
  • Field (name) — varchar(255)
  • Field (nickname) — varchar(255)
  • Field (profile_url) — varchar(255)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (music)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Field (title) — varchar(255)
  • Field (user_nickname) — varchar(255)
  • Field (total_score) — double — NOT NULL
  • Field (score_average) — double — NOT NULL
  • Field2 (review_count) — int — NOT NULL
  • Field (likes) — int — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field (deleted_at) — datetime(6)

Untitled (music_genre)

  • Key (music_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (genre) — enum

Untitled (file_entity)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (music_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (file_url) — varchar(255)
  • Field (original_file_name) — varchar(255)
  • Field (saved_name) — varchar(255)
  • Field (file_type) — enum('IMAGE','MUSIC')
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (review)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Key (music_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (user_nickname) — varchar(255)
  • Field (user_image_url) — varchar(255)
  • Field (message) — varchar(255)
  • Field (score) — double — NOT NULL
  • Field (likes) — int — NOT NULL
  • Field (comment_num) — int — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field (deleted_at) — datetime(6)

Untitled (review_likes)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Field (flag) — bit(1) — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (comment)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Field (user_nickname) — varchar(255)
  • Field (message) — varchar(255)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field (deleted_at) — datetime(6)

Untitled (notification)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Field (message) — string
  • Field (link) — string
  • Field (is_checked) — boolean
  • Field (created_at) — iso_date
  • Field (updated_at) — iso_date

Untitled (point)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Field (amount) — int — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (sponsor)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (point_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (sender_id) — bigint — Foreign key → user.Key — NOT NULL
  • Key (receiver_id) — bigint — Foreign key → user.Key — NOT NULL
  • Field (point_amount) — int — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field (deleted_at) — datetime(6)

Untitled (point_charge)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (point_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Field (charge_type) — enum — NOT NULL
  • Field (original_amount) — int — NOT NULL
  • Field (point_amount) — int — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field (deleted_at) — datetime(6)

user

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (login_type) — enum('LOCAL','SOCIAL')
  • Field (role) — enum('ADMIN','GUEST','USER')
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)