export type Category = {
  id: string;
  slug: string;
  name: string;
  description: string | null;
  image_url: string | null;
  sort_order: number;
  is_active: boolean;
};

export type Product = {
  id: string;
  category_id: string;
  name: string;
  description: string | null;
  unit: string | null;
  price: number | null;
  image_url: string | null;
  is_featured: boolean;
  is_active: boolean;
  sort_order: number;
};

export type Settings = {
  id: string;
  brand_name: string;
  tagline: string;
  hero_title: string;
  hero_subtitle: string;
  about_title: string;
  about_body: string;
  phone: string;
  whatsapp: string;
  email: string;
  address: string;
  working_hours: string;
  instagram: string;
  facebook: string;
  map_embed_url: string;
};

export type Message = {
  id: string;
  name: string;
  phone: string;
  email: string | null;
  subject: string | null;
  body: string;
  is_read: boolean;
  created_at: string;
};

export type Database = {
  categories: Category[];
  products: Product[];
  settings: Settings;
  messages: Message[];
};