stores chat rooms: - `id` (primary key) - `name` (unique, 1-100 characters) - `description` (optional) - `created_by` (foreign key to users) - `created_at`