System :: CODE / DB_CONFIG_V4

STATUS: OPERATIONAL // ENCRYPTION: AES-256

database

DB STATUS

CONNECTED

STABLE // 99.9% UPTIME

public

REGION

US-EAST-1

GCP_FIREBASE_CLUSTER

speed

LATENCY

24ms

-2ms

OPTIMIZED_ROUTING

schema

DATABASE_SCHEMA_TABLES

01

TABLE: Profiles

expand_more

Columns & Types

  • id uuid [PK]
  • updated_at timestamp
  • username text [UQ]
  • avatar_url text

Security Policies

CREATE POLICY "Public profiles are viewable by everyone." ON profiles FOR SELECT USING (true);

CREATE POLICY "Users can insert their own profile." ON profiles FOR INSERT WITH CHECK (auth.uid() = id);
02

TABLE: Links

expand_more

Structure

Relational mapping for social assets. Columns: id (uuid), profile_id (fkey), url (text), platform (enum), priority (int4). Row Level Security enabled for owner-only mutations.

03

TABLE: AI_Queue

expand_more

Processing Pipeline

High-throughput task buffer. Columns: task_id (uuid), status (processing_state), payload (jsonb), result_url (text), started_at (timestamp). Integrated with Edge Functions for real-time inference.

CODE