types_db.ts

export type Json =
  | string
  | number
  | boolean
  | null
  | { [key: string]: Json | undefined }
  | Json[]

export type Database = {
  // Allows to automatically instantiate createClient with right options
  // instead of createClient<Database, { PostgrestVersion: 'XX' }>(URL, KEY)
  __InternalSupabase: {
    PostgrestVersion: "13.0.5"
  }
  public: {
    Tables: {
      board_type: {
        Row: {
          allow_host: boolean
          allow_member: boolean
          board_type: string
        }
        Insert: {
          allow_host?: boolean
          allow_member?: boolean
          board_type: string
        }
        Update: {
          allow_host?: boolean
          allow_member?: boolean
          board_type?: string
        }
        Relationships: []
      }
      categories_major: {
        Row: {
          category_major_name: string
          category_major_slug: string
          major_id: string
        }
        Insert: {
          category_major_name: string
          category_major_slug: string
          major_id?: string
        }
        Update: {
          category_major_name?: string
          category_major_slug?: string
          major_id?: string
        }
        Relationships: []
      }
      categories_sub: {
        Row: {
          category_sub_name: string
          category_sub_slug: string
          major_id: string
          sub_id: string
        }
        Insert: {
          category_sub_name: string
          category_sub_slug: string
          major_id: string
          sub_id?: string
        }
        Update: {
          category_sub_name?: string
          category_sub_slug?: string
          major_id?: string
          sub_id?: string
        }
        Relationships: [
          {
            foreignKeyName: "categories_sub_major_id_fkey"
            columns: ["major_id"]
            isOneToOne: false
            referencedRelation: "categories_major"
            referencedColumns: ["major_id"]
          },
        ]
      }
      direct_chats: {
        Row: {
          chat_id: string
          created_at: string
          created_by: string | null
          group_id: string
          host_id: string
          member_id: string
          updated_at: string
          user_high: string | null
          user_low: string | null
        }
        Insert: {
          chat_id?: string
          created_at?: string
          created_by?: string | null
          group_id: string
          host_id: string
          member_id: string
          updated_at?: string
          user_high?: string | null
          user_low?: string | null
        }
        Update: {
          chat_id?: string
          created_at?: string
          created_by?: string | null
          group_id?: string
          host_id?: string
          member_id?: string
          updated_at?: string
          user_high?: string | null
          user_low?: string | null
        }
        Relationships: [
          {
            foreignKeyName: "direct_chats_created_by_fkey"
            columns: ["created_by"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
          {
            foreignKeyName: "direct_chats_group_id_fkey"
            columns: ["group_id"]
            isOneToOne: false
            referencedRelation: "groups"
            referencedColumns: ["group_id"]
          },
          {
            foreignKeyName: "direct_chats_host_id_fkey"
            columns: ["host_id"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
          {
            foreignKeyName: "direct_chats_member_id_fkey"
            columns: ["member_id"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
        ]
      }
      direct_messages: {
        Row: {
          chat_id: string
          content: string
          created_at: string
          message_id: string
          sender_id: string
          updated_at: string
        }
        Insert: {
          chat_id: string
          content: string
          created_at?: string
          message_id?: string
          sender_id: string
          updated_at?: string
        }
        Update: {
          chat_id?: string
          content?: string
          created_at?: string
          message_id?: string
          sender_id?: string
          updated_at?: string
        }
        Relationships: [
          {
            foreignKeyName: "direct_messages_chat_id_fkey"
            columns: ["chat_id"]
            isOneToOne: false
            referencedRelation: "direct_chats"
            referencedColumns: ["chat_id"]
          },
          {
            foreignKeyName: "direct_messages_sender_id_fkey"
            columns: ["sender_id"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
        ]
      }
      direct_participants: {
        Row: {
          chat_id: string
          joined_at: string | null
          last_read_at: string | null
          left_at: string | null
          user_id: string
        }
        Insert: {
          chat_id: string
          joined_at?: string | null
          last_read_at?: string | null
          left_at?: string | null
          user_id: string
        }
        Update: {
          chat_id?: string
          joined_at?: string | null
          last_read_at?: string | null
          left_at?: string | null
          user_id?: string
        }
        Relationships: [
          {
            foreignKeyName: "direct_participants_chat_id_fkey"
            columns: ["chat_id"]
            isOneToOne: false
            referencedRelation: "direct_chats"
            referencedColumns: ["chat_id"]
          },
          {
            foreignKeyName: "direct_participants_user_id_fkey"
            columns: ["user_id"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
        ]
      }
      group_daily_reads: {
        Row: {
          post_id: string
          read_at: string
          user_id: string
        }
        Insert: {
          post_id: string
          read_at?: string
          user_id: string
        }
        Update: {
          post_id?: string
          read_at?: string
          user_id?: string
        }
        Relationships: [
          {
            foreignKeyName: "group_daily_reads_post_id_fkey"
            columns: ["post_id"]
            isOneToOne: false
            referencedRelation: "group_posts"
            referencedColumns: ["post_id"]
          },
        ]
      }
      group_favorites: {
        Row: {
          created_at: string
          favorite: boolean | null
          group_id: string
          id: string
          updated_at: string
          user_id: string
        }
        Insert: {
          created_at?: string
          favorite?: boolean | null
          group_id: string
          id?: string
          updated_at?: string
          user_id: string
        }
        Update: {
          created_at?: string
          favorite?: boolean | null
          group_id?: string
          id?: string
          updated_at?: string
          user_id?: string
        }
        Relationships: [
          {
            foreignKeyName: "group_favorites_group_id_fkey"
            columns: ["group_id"]
            isOneToOne: false
            referencedRelation: "groups"
            referencedColumns: ["group_id"]
          },
          {
            foreignKeyName: "group_favorites_user_id_fkey"
            columns: ["user_id"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
        ]
      }
      group_members: {
        Row: {
          group_id: string
          member_id: string
          member_joined_at: string
          member_role: Database["public"]["Enums"]["member_role_enum"]
          member_status: Database["public"]["Enums"]["member_status_enum"]
          user_id: string | null
        }
        Insert: {
          group_id: string
          member_id?: string
          member_joined_at?: string
          member_role?: Database["public"]["Enums"]["member_role_enum"]
          member_status?: Database["public"]["Enums"]["member_status_enum"]
          user_id?: string | null
        }
        Update: {
          group_id?: string
          member_id?: string
          member_joined_at?: string
          member_role?: Database["public"]["Enums"]["member_role_enum"]
          member_status?: Database["public"]["Enums"]["member_status_enum"]
          user_id?: string | null
        }
        Relationships: [
          {
            foreignKeyName: "group_members_group_id_fkey"
            columns: ["group_id"]
            isOneToOne: false
            referencedRelation: "groups"
            referencedColumns: ["group_id"]
          },
          {
            foreignKeyName: "group_members_user_id_fkey"
            columns: ["user_id"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
        ]
      }
      group_post_likes: {
        Row: {
          created_at: string
          post_id: string
          user_id: string
        }
        Insert: {
          created_at?: string
          post_id: string
          user_id: string
        }
        Update: {
          created_at?: string
          post_id?: string
          user_id?: string
        }
        Relationships: [
          {
            foreignKeyName: "group_post_likes_post_id_fkey"
            columns: ["post_id"]
            isOneToOne: false
            referencedRelation: "group_posts"
            referencedColumns: ["post_id"]
          },
        ]
      }
      group_post_reads: {
        Row: {
          post_id: string
          read_at: string
          user_id: string
        }
        Insert: {
          post_id: string
          read_at?: string
          user_id: string
        }
        Update: {
          post_id?: string
          read_at?: string
          user_id?: string
        }
        Relationships: [
          {
            foreignKeyName: "group_post_reads_post_id_fkey"
            columns: ["post_id"]
            isOneToOne: false
            referencedRelation: "group_posts"
            referencedColumns: ["post_id"]
          },
        ]
      }
      group_posts: {
        Row: {
          board_type: string
          group_id: string
          post_body_md: string | null
          post_created_at: string
          post_id: string
          post_title: string
          user_id: string | null
          view_count: number
        }
        Insert: {
          board_type: string
          group_id: string
          post_body_md?: string | null
          post_created_at?: string
          post_id?: string
          post_title: string
          user_id?: string | null
          view_count?: number
        }
        Update: {
          board_type?: string
          group_id?: string
          post_body_md?: string | null
          post_created_at?: string
          post_id?: string
          post_title?: string
          user_id?: string | null
          view_count?: number
        }
        Relationships: [
          {
            foreignKeyName: "group_posts_board_type_fkey"
            columns: ["board_type"]
            isOneToOne: false
            referencedRelation: "board_type"
            referencedColumns: ["board_type"]
          },
          {
            foreignKeyName: "group_posts_group_id_fkey"
            columns: ["group_id"]
            isOneToOne: false
            referencedRelation: "groups"
            referencedColumns: ["group_id"]
          },
          {
            foreignKeyName: "group_posts_user_id_fkey"
            columns: ["user_id"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
        ]
      }
      group_review_tags: {
        Row: {
          review_id: string
          tag_code: string
        }
        Insert: {
          review_id: string
          tag_code: string
        }
        Update: {
          review_id?: string
          tag_code?: string
        }
        Relationships: [
          {
            foreignKeyName: "group_review_tags_review_id_fkey"
            columns: ["review_id"]
            isOneToOne: false
            referencedRelation: "group_reviews"
            referencedColumns: ["review_id"]
          },
          {
            foreignKeyName: "group_review_tags_tag_code_fkey"
            columns: ["tag_code"]
            isOneToOne: false
            referencedRelation: "review_tag_dict"
            referencedColumns: ["tag_code"]
          },
        ]
      }
      group_reviews: {
        Row: {
          author_id: string
          created_at: string
          group_id: string
          pros_text: string | null
          rating: number
          review_id: string
          updated_at: string
        }
        Insert: {
          author_id: string
          created_at?: string
          group_id: string
          pros_text?: string | null
          rating: number
          review_id?: string
          updated_at?: string
        }
        Update: {
          author_id?: string
          created_at?: string
          group_id?: string
          pros_text?: string | null
          rating?: number
          review_id?: string
          updated_at?: string
        }
        Relationships: [
          {
            foreignKeyName: "group_reviews_group_id_fkey"
            columns: ["group_id"]
            isOneToOne: false
            referencedRelation: "groups"
            referencedColumns: ["group_id"]
          },
        ]
      }
      group_schedule: {
        Row: {
          group_id: string
          schedule_created_at: string
          schedule_end_at: string | null
          schedule_id: string
          schedule_place_name: string | null
          schedule_start_at: string
          schedule_title: string | null
          user_id: string | null
        }
        Insert: {
          group_id: string
          schedule_created_at?: string
          schedule_end_at?: string | null
          schedule_id?: string
          schedule_place_name?: string | null
          schedule_start_at?: string
          schedule_title?: string | null
          user_id?: string | null
        }
        Update: {
          group_id?: string
          schedule_created_at?: string
          schedule_end_at?: string | null
          schedule_id?: string
          schedule_place_name?: string | null
          schedule_start_at?: string
          schedule_title?: string | null
          user_id?: string | null
        }
        Relationships: [
          {
            foreignKeyName: "group_schedule_group_id_fkey"
            columns: ["group_id"]
            isOneToOne: false
            referencedRelation: "groups"
            referencedColumns: ["group_id"]
          },
          {
            foreignKeyName: "group_schedule_user_id_fkey"
            columns: ["user_id"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
        ]
      }
      groups: {
        Row: {
          approved: boolean
          created_by: string | null
          curriculum: Json | null
          favorite: boolean | null
          group_capacity: number | null
          group_content: string | null
          group_created_at: string
          group_end_day: string
          group_id: string
          group_region: string | null
          group_region_any: boolean
          group_short_intro: string | null
          group_slug: string | null
          group_start_day: string
          group_title: string
          group_updated_at: string
          image_urls: string[] | null
          major_id: string | null
          status: Database["public"]["Enums"]["group_status_enum"]
          sub_id: string | null
        }
        Insert: {
          approved?: boolean
          created_by?: string | null
          curriculum?: Json | null
          favorite?: boolean | null
          group_capacity?: number | null
          group_content?: string | null
          group_created_at?: string
          group_end_day: string
          group_id?: string
          group_region?: string | null
          group_region_any?: boolean
          group_short_intro?: string | null
          group_slug?: string | null
          group_start_day: string
          group_title: string
          group_updated_at?: string
          image_urls?: string[] | null
          major_id?: string | null
          status?: Database["public"]["Enums"]["group_status_enum"]
          sub_id?: string | null
        }
        Update: {
          approved?: boolean
          created_by?: string | null
          curriculum?: Json | null
          favorite?: boolean | null
          group_capacity?: number | null
          group_content?: string | null
          group_created_at?: string
          group_end_day?: string
          group_id?: string
          group_region?: string | null
          group_region_any?: boolean
          group_short_intro?: string | null
          group_slug?: string | null
          group_start_day?: string
          group_title?: string
          group_updated_at?: string
          image_urls?: string[] | null
          major_id?: string | null
          status?: Database["public"]["Enums"]["group_status_enum"]
          sub_id?: string | null
        }
        Relationships: [
          {
            foreignKeyName: "groups_created_by_fkey"
            columns: ["created_by"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
          {
            foreignKeyName: "groups_major_id_fkey"
            columns: ["major_id"]
            isOneToOne: false
            referencedRelation: "categories_major"
            referencedColumns: ["major_id"]
          },
          {
            foreignKeyName: "groups_sub_id_fkey"
            columns: ["sub_id"]
            isOneToOne: false
            referencedRelation: "categories_sub"
            referencedColumns: ["sub_id"]
          },
        ]
      }
      notifications: {
        Row: {
          created_at: string | null
          group_id: string | null
          id: string
          is_read: boolean | null
          message: string | null
          target_id: string | null
          title: string | null
          type: string
          user_id: string
        }
        Insert: {
          created_at?: string | null
          group_id?: string | null
          id?: string
          is_read?: boolean | null
          message?: string | null
          target_id?: string | null
          title?: string | null
          type: string
          user_id: string
        }
        Update: {
          created_at?: string | null
          group_id?: string | null
          id?: string
          is_read?: boolean | null
          message?: string | null
          target_id?: string | null
          title?: string | null
          type?: string
          user_id?: string
        }
        Relationships: []
      }
      post_reports: {
        Row: {
          post_id: string
          report_avatar_url: string | null
          report_created_at: string
          report_detail_etc: string | null
          report_id: string
          report_reason: Database["public"]["Enums"]["report_reason_enum"]
          report_reviewed_at: string | null
          report_status: Database["public"]["Enums"]["report_status_enum"]
          user_id: string | null
        }
        Insert: {
          post_id: string
          report_avatar_url?: string | null
          report_created_at?: string
          report_detail_etc?: string | null
          report_id?: string
          report_reason: Database["public"]["Enums"]["report_reason_enum"]
          report_reviewed_at?: string | null
          report_status?: Database["public"]["Enums"]["report_status_enum"]
          user_id?: string | null
        }
        Update: {
          post_id?: string
          report_avatar_url?: string | null
          report_created_at?: string
          report_detail_etc?: string | null
          report_id?: string
          report_reason?: Database["public"]["Enums"]["report_reason_enum"]
          report_reviewed_at?: string | null
          report_status?: Database["public"]["Enums"]["report_status_enum"]
          user_id?: string | null
        }
        Relationships: [
          {
            foreignKeyName: "post_reports_post_id_fkey"
            columns: ["post_id"]
            isOneToOne: false
            referencedRelation: "group_posts"
            referencedColumns: ["post_id"]
          },
          {
            foreignKeyName: "post_reports_user_id_fkey"
            columns: ["user_id"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
        ]
      }
      review_likes: {
        Row: {
          created_at: string
          review_id: string
          user_id: string
        }
        Insert: {
          created_at?: string
          review_id: string
          user_id: string
        }
        Update: {
          created_at?: string
          review_id?: string
          user_id?: string
        }
        Relationships: [
          {
            foreignKeyName: "review_likes_review_id_fkey"
            columns: ["review_id"]
            isOneToOne: false
            referencedRelation: "group_reviews"
            referencedColumns: ["review_id"]
          },
        ]
      }
      review_tag_dict: {
        Row: {
          label: string
          tag_code: string
        }
        Insert: {
          label: string
          tag_code: string
        }
        Update: {
          label?: string
          tag_code?: string
        }
        Relationships: []
      }
      user_careers: {
        Row: {
          career_id: string
          career_image_url: string | null
          company_name: string
          created_at: string | null
          end_date: string
          original_file_name: string | null
          profile_id: string | null
          start_date: string
          updated_at: string | null
        }
        Insert: {
          career_id?: string
          career_image_url?: string | null
          company_name: string
          created_at?: string | null
          end_date: string
          original_file_name?: string | null
          profile_id?: string | null
          start_date: string
          updated_at?: string | null
        }
        Update: {
          career_id?: string
          career_image_url?: string | null
          company_name?: string
          created_at?: string | null
          end_date?: string
          original_file_name?: string | null
          profile_id?: string | null
          start_date?: string
          updated_at?: string | null
        }
        Relationships: [
          {
            foreignKeyName: "user_careers_profile_id_fkey"
            columns: ["profile_id"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
        ]
      }
      user_delete_logs: {
        Row: {
          delete_feedback: string | null
          delete_id: string
          delete_reason: string | null
          deleted_at: string
          ip_addr: unknown
          log_key: string
          user_agent: string | null
          user_id: string | null
        }
        Insert: {
          delete_feedback?: string | null
          delete_id?: string
          delete_reason?: string | null
          deleted_at?: string
          ip_addr?: unknown
          log_key: string
          user_agent?: string | null
          user_id?: string | null
        }
        Update: {
          delete_feedback?: string | null
          delete_id?: string
          delete_reason?: string | null
          deleted_at?: string
          ip_addr?: unknown
          log_key?: string
          user_agent?: string | null
          user_id?: string | null
        }
        Relationships: [
          {
            foreignKeyName: "user_delete_logs_user_id_fkey"
            columns: ["user_id"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
        ]
      }
      user_inquiries: {
        Row: {
          inquiry_answer: string | null
          inquiry_answered_at: string | null
          inquiry_created_at: string
          inquiry_detail: string
          inquiry_file_urls: Json | null
          inquiry_id: string
          inquiry_main_type: string
          inquiry_status: Database["public"]["Enums"]["inquiry_status_enum"]
          inquiry_sub_type: string
          user_id: string
        }
        Insert: {
          inquiry_answer?: string | null
          inquiry_answered_at?: string | null
          inquiry_created_at?: string
          inquiry_detail: string
          inquiry_file_urls?: Json | null
          inquiry_id?: string
          inquiry_main_type: string
          inquiry_status?: Database["public"]["Enums"]["inquiry_status_enum"]
          inquiry_sub_type: string
          user_id: string
        }
        Update: {
          inquiry_answer?: string | null
          inquiry_answered_at?: string | null
          inquiry_created_at?: string
          inquiry_detail?: string
          inquiry_file_urls?: Json | null
          inquiry_id?: string
          inquiry_main_type?: string
          inquiry_status?: Database["public"]["Enums"]["inquiry_status_enum"]
          inquiry_sub_type?: string
          user_id?: string
        }
        Relationships: [
          {
            foreignKeyName: "user_inquiries_user_id_fkey"
            columns: ["user_id"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
        ]
      }
      user_interests: {
        Row: {
          category_sub_id: string | null
          created_at: string
          interest_id: string
          user_id: string
        }
        Insert: {
          category_sub_id?: string | null
          created_at?: string
          interest_id?: string
          user_id: string
        }
        Update: {
          category_sub_id?: string | null
          created_at?: string
          interest_id?: string
          user_id?: string
        }
        Relationships: [
          {
            foreignKeyName: "user_interests_category_sub_id_fkey"
            columns: ["category_sub_id"]
            isOneToOne: false
            referencedRelation: "categories_sub"
            referencedColumns: ["sub_id"]
          },
          {
            foreignKeyName: "user_interests_user_id_fkey"
            columns: ["user_id"]
            isOneToOne: false
            referencedRelation: "user_profiles"
            referencedColumns: ["user_id"]
          },
        ]
      }
      user_profiles: {
        Row: {
          agree_email: boolean | null
          agree_push: boolean | null
          agree_sms: boolean | null
          agree_updated_at: string
          avatar_url: string | null
          created_at: string
          email: string
          is_active: boolean
          name: string
          nickname: string
          user_id: string
        }
        Insert: {
          agree_email?: boolean | null
          agree_push?: boolean | null
          agree_sms?: boolean | null
          agree_updated_at?: string
          avatar_url?: string | null
          created_at?: string
          email: string
          is_active?: boolean
          name: string
          nickname: string
          user_id: string
        }
        Update: {
          agree_email?: boolean | null
          agree_push?: boolean | null
          agree_sms?: boolean | null
          agree_updated_at?: string
          avatar_url?: string | null
          created_at?: string
          email?: string
          is_active?: boolean
          name?: string
          nickname?: string
          user_id?: string
        }
        Relationships: []
      }
    }
    Views: {
      [_ in never]: never
    }
    Functions: {
      auto_close_expired_groups: { Args: never; Returns: undefined }
      create_notification: {
        Args: {
          p_group_id?: string
          p_message: string
          p_target_id?: string
          p_title: string
          p_type: string
          p_user_id: string
        }
        Returns: string
      }
      ensure_both_participants: {
        Args: { p_chat_id: string }
        Returns: undefined
      }
      get_all_notifications: {
        Args: { p_user_id: string }
        Returns: {
          created_at: string
          group_id: string
          last_message: string
          message: string
          sender_nickname: string
          target_id: string
          title: string
          type: string
          unread: number
        }[]
      }
      get_chat_notifications: {
        Args: { p_user_id: string }
        Returns: {
          chat_id: string
          group_id: string
          group_title: string
          last_message: string
          sender_nickname: string
          unread: number
        }[]
      }
      get_unread_counts: {
        Args: never
        Returns: {
          chat_id: string
          unread: number
        }[]
      }
      is_group_host: {
        Args: { p_group_id: string; p_user_id: string }
        Returns: boolean
      }
      is_group_member: {
        Args: { p_group_id: string; p_user_id: string }
        Returns: boolean
      }
      is_member_of_post: {
        Args: { p_post_id: string; p_user_id: string }
        Returns: boolean
      }
      leave_direct_chat: {
        Args: { p_chat_id: string }
        Returns: {
          both_users_left: boolean
          is_cleaned: boolean
        }[]
      }
      mark_chat_read: { Args: { p_chat_id: string }; Returns: undefined }
      mark_notifications_read: {
        Args: { p_user_id: string }
        Returns: undefined
      }
      rejoin_counterpart: {
        Args: { p_chat_id: string; p_sender: string }
        Returns: undefined
      }
      unaccent: { Args: { "": string }; Returns: string }
    }
    Enums: {
      group_kind_enum: "study" | "hobby" | "sports" | "volunteer" | "etc"
      group_status_enum: "recruiting" | "closed" | "finished"
      inquiry_status_enum: "pending" | "answered" | "closed"
      member_role_enum: "host" | "member"
      member_status_enum: "applied" | "approved" | "rejected" | "left"
      report_reason_enum:
        | "spam"
        | "abuse"
        | "inappropriate"
        | "advertisement"
        | "etc"
      report_status_enum: "open" | "in_progress" | "closed"
    }
    CompositeTypes: {
      [_ in never]: never
    }
  }
}

type DatabaseWithoutInternals = Omit<Database, "__InternalSupabase">

type DefaultSchema = DatabaseWithoutInternals[Extract<keyof Database, "public">]

export type Tables<
  DefaultSchemaTableNameOrOptions extends
    | keyof (DefaultSchema["Tables"] & DefaultSchema["Views"])
    | { schema: keyof DatabaseWithoutInternals },
  TableName extends DefaultSchemaTableNameOrOptions extends {
    schema: keyof DatabaseWithoutInternals
  }
    ? keyof (DatabaseWithoutInternals[DefaultSchemaTableNameOrOptions["schema"]]["Tables"] &
        DatabaseWithoutInternals[DefaultSchemaTableNameOrOptions["schema"]]["Views"])
    : never = never,
> = DefaultSchemaTableNameOrOptions extends {
  schema: keyof DatabaseWithoutInternals
}
  ? (DatabaseWithoutInternals[DefaultSchemaTableNameOrOptions["schema"]]["Tables"] &
      DatabaseWithoutInternals[DefaultSchemaTableNameOrOptions["schema"]]["Views"])[TableName] extends {
      Row: infer R
    }
    ? R
    : never
  : DefaultSchemaTableNameOrOptions extends keyof (DefaultSchema["Tables"] &
        DefaultSchema["Views"])
    ? (DefaultSchema["Tables"] &
        DefaultSchema["Views"])[DefaultSchemaTableNameOrOptions] extends {
        Row: infer R
      }
      ? R
      : never
    : never

export type TablesInsert<
  DefaultSchemaTableNameOrOptions extends
    | keyof DefaultSchema["Tables"]
    | { schema: keyof DatabaseWithoutInternals },
  TableName extends DefaultSchemaTableNameOrOptions extends {
    schema: keyof DatabaseWithoutInternals
  }
    ? keyof DatabaseWithoutInternals[DefaultSchemaTableNameOrOptions["schema"]]["Tables"]
    : never = never,
> = DefaultSchemaTableNameOrOptions extends {
  schema: keyof DatabaseWithoutInternals
}
  ? DatabaseWithoutInternals[DefaultSchemaTableNameOrOptions["schema"]]["Tables"][TableName] extends {
      Insert: infer I
    }
    ? I
    : never
  : DefaultSchemaTableNameOrOptions extends keyof DefaultSchema["Tables"]
    ? DefaultSchema["Tables"][DefaultSchemaTableNameOrOptions] extends {
        Insert: infer I
      }
      ? I
      : never
    : never

export type TablesUpdate<
  DefaultSchemaTableNameOrOptions extends
    | keyof DefaultSchema["Tables"]
    | { schema: keyof DatabaseWithoutInternals },
  TableName extends DefaultSchemaTableNameOrOptions extends {
    schema: keyof DatabaseWithoutInternals
  }
    ? keyof DatabaseWithoutInternals[DefaultSchemaTableNameOrOptions["schema"]]["Tables"]
    : never = never,
> = DefaultSchemaTableNameOrOptions extends {
  schema: keyof DatabaseWithoutInternals
}
  ? DatabaseWithoutInternals[DefaultSchemaTableNameOrOptions["schema"]]["Tables"][TableName] extends {
      Update: infer U
    }
    ? U
    : never
  : DefaultSchemaTableNameOrOptions extends keyof DefaultSchema["Tables"]
    ? DefaultSchema["Tables"][DefaultSchemaTableNameOrOptions] extends {
        Update: infer U
      }
      ? U
      : never
    : never

export type Enums<
  DefaultSchemaEnumNameOrOptions extends
    | keyof DefaultSchema["Enums"]
    | { schema: keyof DatabaseWithoutInternals },
  EnumName extends DefaultSchemaEnumNameOrOptions extends {
    schema: keyof DatabaseWithoutInternals
  }
    ? keyof DatabaseWithoutInternals[DefaultSchemaEnumNameOrOptions["schema"]]["Enums"]
    : never = never,
> = DefaultSchemaEnumNameOrOptions extends {
  schema: keyof DatabaseWithoutInternals
}
  ? DatabaseWithoutInternals[DefaultSchemaEnumNameOrOptions["schema"]]["Enums"][EnumName]
  : DefaultSchemaEnumNameOrOptions extends keyof DefaultSchema["Enums"]
    ? DefaultSchema["Enums"][DefaultSchemaEnumNameOrOptions]
    : never

export type CompositeTypes<
  PublicCompositeTypeNameOrOptions extends
    | keyof DefaultSchema["CompositeTypes"]
    | { schema: keyof DatabaseWithoutInternals },
  CompositeTypeName extends PublicCompositeTypeNameOrOptions extends {
    schema: keyof DatabaseWithoutInternals
  }
    ? keyof DatabaseWithoutInternals[PublicCompositeTypeNameOrOptions["schema"]]["CompositeTypes"]
    : never = never,
> = PublicCompositeTypeNameOrOptions extends {
  schema: keyof DatabaseWithoutInternals
}
  ? DatabaseWithoutInternals[PublicCompositeTypeNameOrOptions["schema"]]["CompositeTypes"][CompositeTypeName]
  : PublicCompositeTypeNameOrOptions extends keyof DefaultSchema["CompositeTypes"]
    ? DefaultSchema["CompositeTypes"][PublicCompositeTypeNameOrOptions]
    : never

export const Constants = {
  public: {
    Enums: {
      group_kind_enum: ["study", "hobby", "sports", "volunteer", "etc"],
      group_status_enum: ["recruiting", "closed", "finished"],
      inquiry_status_enum: ["pending", "answered", "closed"],
      member_role_enum: ["host", "member"],
      member_status_enum: ["applied", "approved", "rejected", "left"],
      report_reason_enum: [
        "spam",
        "abuse",
        "inappropriate",
        "advertisement",
        "etc",
      ],
      report_status_enum: ["open", "in_progress", "closed"],
    },
  },
} as const