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