src/types/database.ts

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

export interface Database {
  public: {
    Tables: {
      users: {
        Row: {
          id: string
          email: string
          token: string
          status: number
          fname: string
          sname: string
          sex: number | null
          nickname: string | null
          birth_date: string | null
          photo_url: string | null
          lang: string
          created_at: string
          updated_at: string
        }
        Insert: {
          id?: string
          email: string
          token?: string
          status?: number
          fname: string
          sname: string
          sex?: number | null
          nickname?: string | null
          birth_date?: string | null
          photo_url?: string | null
          lang?: string
          created_at?: string
          updated_at?: string
        }
        Update: {
          id?: string
          email?: string
          token?: string
          status?: number
          fname?: string
          sname?: string
          sex?: number | null
          nickname?: string | null
          birth_date?: string | null
          photo_url?: string | null
          lang?: string
          created_at?: string
          updated_at?: string
        }
        Relationships: []
      }
      codes: {
        Row: {
          id: string
          code: string
          linked_to: string | null
          used: number | null
          user_id: string | null
          room_id: string | null
          pin_hash: string | null
          session_hash: string | null
          date_first: string | null
          date_last: string | null
          used_count: number
          created_at: string
        }
        Insert: {
          id?: string
          code: string
          linked_to?: string | null
          used?: number | null
          user_id?: string | null
          room_id?: string | null
          pin_hash?: string | null
          session_hash?: string | null
          date_first?: string | null
          date_last?: string | null
          used_count?: number
          created_at?: string
        }
        Update: {
          id?: string
          code?: string
          linked_to?: string | null
          used?: number | null
          user_id?: string | null
          room_id?: string | null
          pin_hash?: string | null
          session_hash?: string | null
          date_first?: string | null
          date_last?: string | null
          used_count?: number
          created_at?: string
        }
        Relationships: [
          {
            foreignKeyName: 'codes_linked_to_fkey',
            columns: ['linked_to'],
            referencedRelation: 'codes',
            referencedColumns: ['id']
          },
          {
            foreignKeyName: 'codes_room_id_fkey',
            columns: ['room_id'],
            referencedRelation: 'rooms',
            referencedColumns: ['id']
          },
          {
            foreignKeyName: 'codes_user_id_fkey',
            columns: ['user_id'],
            referencedRelation: 'users',
            referencedColumns: ['id']
          }
        ]
      }
      rooms: {
        Row: {
          id: string
          name: string | null
          description: string | null
          status: number
          date_created: string
          date_last_message: string | null
          updated_at: string
          creator_id: string | null
        }
        Insert: {
          id?: string
          name?: string | null
          description?: string | null
          status?: number
          date_created?: string
          date_last_message?: string | null
          updated_at?: string
          creator_id?: string | null
        }
        Update: {
          id?: string
          name?: string | null
          description?: string | null
          status?: number
          date_created?: string
          date_last_message?: string | null
          updated_at?: string
          creator_id?: string | null
        }
        Relationships: []
      }
      room_messages: {
        Row: {
          id: string
          room_id: string
          code_id: string
          user_id: string | null
          content: string
          image_url: string | null
          created_at: string
        }
        Insert: {
          id?: string
          room_id: string
          code_id: string
          user_id?: string | null
          content: string
          image_url?: string | null
          created_at?: string
        }
        Update: {
          id?: string
          room_id?: string
          code_id?: string
          user_id?: string | null
          content?: string
          image_url?: string | null
          created_at?: string
        }
        Relationships: [
          {
            foreignKeyName: 'room_messages_room_id_fkey',
            columns: ['room_id'],
            referencedRelation: 'rooms',
            referencedColumns: ['id']
          },
          {
            foreignKeyName: 'room_messages_code_id_fkey',
            columns: ['code_id'],
            referencedRelation: 'codes',
            referencedColumns: ['id']
          },
          {
            foreignKeyName: 'room_messages_user_id_fkey',
            columns: ['user_id'],
            referencedRelation: 'users',
            referencedColumns: ['id']
          }
        ]
      }
    }
    Views: Record<string, never>
    Functions: Record<string, never>
    Enums: Record<string, never>
    CompositeTypes: Record<string, never>
  }
}