-- Metadata status VARCHAR(50) DEFAULT 'draft', -- draft, pending_review, published, archived tags TEXT[], -- e.g., ['hope', 'recovery', 'domestic_violence']
-- Logic start_date DATE NOT NULL, end_date DATE, goal_type VARCHAR(50), -- 'donations', 'signatures', 'awareness' goal_target INTEGER, current_progress INTEGER DEFAULT 0,
-- Privacy & Consent display_name VARCHAR(100) DEFAULT 'Anonymous Survivor', is_anonymous BOOLEAN DEFAULT TRUE, consent_agreement_id UUID REFERENCES consent_forms(id), Rapelay Mods.rar
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), published_at TIMESTAMP WITH TIME ZONE ); CREATE TABLE awareness_campaigns ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), title VARCHAR(255) NOT NULL, description TEXT, -- Visuals banner_image_url TEXT, promotional_video_url TEXT,
-- Engagement view_count INTEGER DEFAULT 0, reaction_count INTEGER DEFAULT 0, -- Metadata status VARCHAR(50) DEFAULT 'draft', -- draft,
import React, { useState } from 'react'; import { Shield, AlertTriangle } from 'lucide-react'; const StorySubmissionForm = () => { const [story, setStory] = useState({ title: '', content: '', tags: [], isAnonymous: true });
const handleSubmit = async (e) => { e.preventDefault(); // API call to submit story }; -- Metadata status VARCHAR(50) DEFAULT 'draft'
return ( <form onSubmit={handleSubmit} className="space-y-6 p-6 bg-white rounded-lg shadow"> <div className="bg-blue-50 p-4 rounded border border-blue-200 flex gap-3"> <Shield className="text-blue-600" /> <div> <h4 className="font-bold text-blue-800">Your Safety Matters</h4> <p className="text-sm text-blue-700"> Your IP address is