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