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