11

Tables (5)

categories

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • slug — VARCHAR(50) — NOT NULL
  • description — TEXT
  • order — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

comments

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • parent_id — BIGINT
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

likes

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

posts

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • category_id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_category_created

users

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email_verified_at — TIMESTAMP
  • remember_token — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP