sss

Tables (8)

api_logs

  • log_id — INT
  • user_id — INT
  • endpoint — VARCHAR(100) — NOT NULL
  • method — ENUM('GET', 'POST', 'PUT', 'DELETE', 'PATCH') — NOT NULL
  • request_data — JSON
  • response_code — INT
  • response_time — INT
  • created_at — TIMESTAMP

comments

  • comment_id — INT
  • post_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

post_tags

  • post_id — INT — Primary key — NOT NULL
  • tag_id — INT — Primary key — NOT NULL

posts

  • post_id — INT
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • user_id — INT — NOT NULL
  • status — ENUM('draft', 'published', 'archived')
  • view_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

roles

  • role_id — INT
  • name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(255)

tags

  • tag_id — INT
  • name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP

user_roles

  • user_id — INT — Primary key — NOT NULL
  • role_id — INT — Primary key — NOT NULL

users

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • full_name — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • last_login — TIMESTAMP
  • is_active — BOOLEAN