twofiveone

Tables (7)

backtrack

  • id (backtrack_id) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • title — varchar(100)
  • backtrack — JSON
  • created_at — Date

community

  • id (community_id) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • title — varchar(45)
  • description — varchar(300)
  • created_at — Date

community_comment

  • id (comment_id) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • community_id — INT — Foreign key → community.id — NOT NULL
  • comment — varchar(300)
  • created_at — Date

post

  • id (post_id) — INT — Primary key — NOT NULL
  • backtrack_id — INT — Foreign key → backtrack.id — NOT NULL
  • description — varchar(300)
  • image — varchar(500) — NOT NULL
  • created_at — Date
  • liked_users — JSON — NOT NULL

post_comment

  • id (comment_id) — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → post.id — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • comment — varchar(300)
  • created_at — Date

user

  • id (user_id) — INT — Primary key — NOT NULL
  • username — varchar(20)
  • nickname — varchar(30)
  • email — varchar(50)
  • password — varchar(255)
  • oauth_provider — varchar(30)
  • role — varchar(30)
  • activated — int — 1
  • liked_posts — JSON — NOT NULL

user_posts_post_users

  • id (user_id) — INT — Foreign key → user.id — NOT NULL
  • id (post_id) — INT — Foreign key → post.id — NOT NULL