terrastories_dump_analysis

📊 CORE DOMAIN TABLES:
==================================================

🏷️  COMMUNITIES:
   • id bigint NOT NULL
   • name character varying
   • locale character varying
   • country character varying
   • created_at timestamp without time zone NOT NULL
   • updated_at timestamp without time zone NOT NULL
   • beta boolean DEFAULT false
   • public boolean DEFAULT false NOT NULL
   • slug character varying
   • description text

🏷️  USERS:
   • id bigint NOT NULL
   • email character varying
   • encrypted_password character varying DEFAULT ''::character varying NOT NULL
   • reset_password_token character varying
   • reset_password_sent_at timestamp without time zone
   • remember_created_at timestamp without time zone
   • sign_in_count integer DEFAULT 0 NOT NULL
   • current_sign_in_at timestamp without time zone
   • last_sign_in_at timestamp without time zone
   • current_sign_in_ip character varying
   ... and 8 more columns

🏷️  STORIES:
   • id bigint NOT NULL
   • title character varying
   • desc text
   • created_at timestamp without time zone NOT NULL
   • updated_at timestamp without time zone NOT NULL
   • permission_level integer
   • date_interviewed timestamp without time zone
   • language character varying
   • interview_location_id integer
   • interviewer_id integer
   ... and 2 more columns

🏷️  PLACES:
   • id bigint NOT NULL
   • name character varying
   • type_of_place character varying
   • created_at timestamp without time zone NOT NULL
   • updated_at timestamp without time zone NOT NULL
   • lat numeric(10,6)
   • long numeric(10,6)
   • region character varying
   • description character varying
   • community_id integer

🏷️  SPEAKERS:
   • id bigint NOT NULL
   • name character varying
   • created_at timestamp without time zone NOT NULL
   • updated_at timestamp without time zone NOT NULL
   • birthdate timestamp without time zone
   • birthplace_id integer
   • speaker_community character varying
   • community_id integer

🏷️  THEMES:
   • id bigint NOT NULL
   • active boolean DEFAULT false NOT NULL
   • created_at timestamp without time zone NOT NULL
   • updated_at timestamp without time zone NOT NULL
   • mapbox_style_url character varying
   • mapbox_access_token character varying
   • center_lat numeric(10,6)
   • center_long numeric(10,6)
   • sw_boundary_lat numeric(10,6)
   • sw_boundary_long numeric(10,6)
   ... and 10 more columns

🔗 RELATIONSHIP TABLES:
==================================================
• places_stories
  - id bigint NOT NULL
  - story_id bigint NOT NULL
  - place_id bigint NOT NULL
• speaker_stories
  - id bigint NOT NULL
  - speaker_id bigint NOT NULL
  - story_id bigint NOT NULL

📱 MEDIA TABLES (ActiveStorage):
==================================================
• active_storage_attachments
• active_storage_blobs
• active_storage_variant_records

🔗 FOREIGN KEY RELATIONSHIPS:
==================================================

🎯 TYPESCRIPT MIGRATION INSIGHTS:
==================================================

📋 Recommended TypeScript Types:

// Communities entity
interface Communities {
  id: number;
  name?: string;
  locale?: string;
  country?: string;
  created_at: Date;
  // ... other fields
}

// Users entity
interface Users {
  id: number;
  email?: string;
  encrypted_password: string;
  reset_password_token?: string;
  reset_password_sent_at?: Date;
  // ... other fields
}

// Stories entity
interface Stories {
  id: number;
  title?: string;
  desc?: string;
  created_at: Date;
  updated_at: Date;
  // ... other fields
}

// Places entity
interface Places {
  id: number;
  name?: string;
  type_of_place?: string;
  created_at: Date;
  updated_at: Date;
  // ... other fields
}

// Speakers entity
interface Speakers {
  id: number;
  name?: string;
  created_at: Date;
  updated_at: Date;
  birthdate?: Date;
  // ... other fields
}

// Themes entity
interface Themes {
  id: number;
  active: boolean;
  created_at: Date;
  updated_at: Date;
  mapbox_style_url?: string;
  // ... other fields
}

🗺️ MIGRATION PRIORITY:
==================================================
1. Core entities: Community, User, Story, Place, Speaker
2. Relationship tables: story_places, story_speakers
3. Media system: ActiveStorage → new media handling
4. Theme
5. Feature flags (flipper_*)