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)