DevPulse
Tables (4)
Contents
- id — integer — Primary key — NOT NULL
- content_type — varchar(50) — NOT NULL
- content_detail — json — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- views — integer
- bookmark_users — json
Question
- id — integer — Primary key — NOT NULL
- question — varchar(100) — NOT NULL
- question_type — varchar(100) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- published_at — timestamp
- answers — json
- bookmark_users — json
User
- id — integer — Primary key — NOT NULL
- uid — varchar(20) — NOT NULL
- email — varchar(100) — NOT NULL
- password — varchar(255)
- username — varchar(100) — NOT NULL
- provider — varchar(10)
- provider_id — varchar(10)
- role — varchar(100) — NOT NULL
- active — varchar(50) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- bookmark_contents — json
- bookmark_question — json
Visitors
- id — integer — Primary key — NOT NULL
- date — timestamp — NOT NULL
- count — integer
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- users — json