VeganCos
DroBeat DB ERD
Tables (20)
Untitled (follow)
- id (follower_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- id (followee_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
Untitled (phone_verification)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- Field (token) — VARCHAR(16) — NOT NULL
- Field (phone) — VARCHAR(255)
- Field (name) — VARCHAR(255)
- Field (birthday) — VARCHAR(255)
- Field (gender) — TINYINT(1)
- Field (createdate) — DATETIME — NOT NULL
Untitled (log_purchase)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Key (beat_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- Field (price) — INT(11)
- Field (type) — INT(7)
- Field (createdate) — DATETIME
Untitled (notification)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (type) — INT(7) — NOT NULL
- Field (text) — VARCHAR(255)
- Field (createdate) — DATETIME — NOT NULL
- Field (readdate) — DATETIME
Untitled (cash)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- id (handler_id) — VARCHAR(36) — Foreign key → client.id
- Key (type) — INT(7) — Foreign key → Untitled.Key — NOT NULL
- Key (status) — INT(7) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(255)
- Field (amount) — INT(11)
- Field (createdate) — DATETIME
- Field (handledate) — DATETIME
Untitled (log_cash)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Key (type) — INT(7) — Foreign key → Untitled.Key — NOT NULL
- Field (amount) — INT(11)
- Field (balance) — INT(11)
- Field (createdate) — DATETIME
Untitled (log_play)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- Key (beat_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (createdate) — DATETIME
Untitled (like)
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Key (beat_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
Untitled (bucket)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Key (beat_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
- Field (type) — INT(7)
- Field (price) — INT(11)
- Field (createdate) — DATETIME
- Field (deletedate) — DATETIME
Untitled (comment)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (parent_id) — VARCHAR(36)
- Field (type) — INT(7) — NOT NULL
- Field (text) — MEDIUMTEXT — NOT NULL
- Field (createdate) — DATETIME
- Field (modifydate) — DATETIME
- Field (deletedate) — DATETIME
Untitled (coproducer)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Key (beat_id) — VARCHAR(36) — Foreign key → Untitled.Key — NOT NULL
Untitled (tag)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- Field (parent_id) — VARCHAR(36)
- Field (name) — VARCHAR(255) — NOT NULL
- Field (type) — INT(7) — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
Untitled (beat)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (type) — INT(7) — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (image) — VARCHAR(36)
- Field (genre) — INT(7) — NOT NULL
- Field (genre_sub) — INT(7)
- Field (code) — VARCHAR(255)
- Field (bpm) — INT(3) — NOT NULL
- Field (description) — MEDIUMTEXT
- Field (download_available) — TINYINT(1) — NOT NULL
- Field (file_free) — VARCHAR(36) — NOT NULL
- Field (file_samplepack) — VARCHAR(36)
- Field (file_mp3) — VARCHAR(36)
- Field (file_wav) — VARCHAR(36)
- Field (signiture) — VARCHAR(36)
- Field (cost_primary) — INT(11)
- Field (cost_premium) — INT(11)
- Field (adminselectdate) — DATETIME
- Field (createdate) — DATETIME — NOT NULL
- Field (modifydate) — DATETIME
- Field (deletedate) — DATETIME
Untitled (file)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- Key (filepath_id) — INT(7) — Foreign key → Untitled.Key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (parentid) — VARCHAR(36) — NOT NULL
- Field (type) — INT(7) — NOT NULL
- Field (path) — VARCHAR(255) — NOT NULL
- Field (name_original) — VARCHAR(255) — NOT NULL
- Field (name) — VARCHAR(255)
- Field (size) — INT(11)
- Field (createdate) — DATETIME — NOT NULL
Untitled (message)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Key (type) — INT(7) — Foreign key → Untitled.Key — NOT NULL
- Field (reader_id) — VARCHAR(36)
- Field (text) — MEDIUMTEXT
- Field (read) — TINYINT(1)
- Field (senddate) — DATETIME — NOT NULL
Untitled (report)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (target_user_id) — VARCHAR(36) — NOT NULL
- Field (target_id) — VARCHAR(36) — NOT NULL
- Field (reason) — INT(7) — NOT NULL
- Field (type) — INT(7) — NOT NULL
- Field (reason_text) — MEDIUMTEXT
- Field (status) — INT(7) — NOT NULL
- id (handler_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (handle_method) — INT(7)
- Field (createdate) — DATETIME — NOT NULL
- Field (handledate) — DATETIME
- Field (deletedate) — DATETIME
Untitled (code)
- Key (code) — INT(7) — Primary key — NOT NULL
- Key (code_master) — INT(4) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (data) — VARCHAR(255)
- Field (createdate) — DATETIME — NOT NULL
Untitled (code_master)
- Key (code_master) — INT(4) — Primary key — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (use) — TINYINT(1) — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
Untitled (log_login)
- Key (id) — VARCHAR(36) — Primary key — NOT NULL
- id (user_id) — VARCHAR(36) — Foreign key → client.id — NOT NULL
- Field (version) — VARCHAR(20)
- Field (remote_addr) — VARCHAR(255) — NOT NULL
- Field (createdate) — DATETIME — NOT NULL
client (user)
- id — VARCHAR(36) — Primary key — NOT NULL
- Field (email) — VARCHAR(255) — NOT NULL
- Field (password) — VARCHAR(255) — NOT NULL
- Field (name) — VARCHAR(255) — NOT NULL
- Field (phone) — VARCHAR(255)
- Field (birthday) — VARCHAR(255)
- Field (name_artist) — VARCHAR(255) — NOT NULL
- Field (signature) — VARCHAR(36) — NOT NULL
- Field (image) — VARCHAR(36)
- Field (create_ip) — VARCHAR(255) — NOT NULL
- Field (role) — INT(7) — NOT NULL
- Field (cash) — INT(11)
- Field (bank) — INT(7)
- Field (account) — VARCHAR(255)
- Field (account_name) — VARCHAR(255)
- Field (facebook) — VARCHAR(255)
- Field (instagram) — VARCHAR(255)
- Field (soundcloud) — VARCHAR(255)
- Field (youtube) — VARCHAR(255)
- Field (twitter) — VARCHAR(255)
- Field (bg_profile) — VARCHAR(36)
- Field (region) — INT(7)
- Field (introduction) — MEDIUMTEXT
- Field (createdate) — DATETIME — NOT NULL
- Field (deletedate) — DATETIME
- Field (bandate) — DATETIME
- Field (unregister_reason) — INT(7)
- Field (unregister_text) — MEDIUMTEXT