SchemaForge Studio™v2.0 Foundry Release

Visual ERD & Code-Inferred Joins • IBM-Grade Data Migrator • Navicat Data Grid • Zero-Downtime Lock Simulator

Flame Score: 141250Zero-Telemetry Local Air-Gap

Database Source:

Total Tables

Total Columns

138

Explicit FKs

Heuristic Links

Code Inferred

Database Schema Topology

comment_intent_scores

416 rows

INTEGER

comment_id

INTEGER?

post_id

INTEGER?

author_name

TEXT?

author_headline

TEXT?

context_summary

TEXT?

intent_category

TEXT?

business_value_score

INTEGER?

reasoning

TEXT?

recommended_action

TEXT?

evaluated_at

TEXT?

→ comments→ comments→ posts+15 more

comments

76 rows

INTEGER

comment_urn

TEXT

post_id

INTEGER

author_entity_id

INTEGER

comment_text

TEXT

is_clickjack

INTEGER?

impressions

INTEGER?

reactions_count

INTEGER?

created_at

TEXT?

last_scraped_at

TEXT?

→ posts→ entities← interactions+3 more

companies

259 rows

INTEGER

name

TEXT

size_bracket

TEXT?

industry

TEXT?

← entities→ comment_intent_scores

connections

758 rows

INTEGER

entity_id

INTEGER

degree

INTEGER?

connected_at

TEXT?

source

TEXT?

→ entities→ comment_intent_scores

content_gap_drafts

13 rows

INTEGER

source_intent_score_id

INTEGER?

author_name

TEXT?

author_headline

TEXT?

inquiry_summary

TEXT?

core_theme

TEXT?

universal_problem

TEXT?

solution_framework

TEXT?

drafted_post

TEXT?

status

TEXT?

created_at

TEXT?

→ comment_intent_scores

creator_analytics_snapshots

10 rows

INTEGER

timestamp

TEXT

start_date

TEXT

end_date

TEXT

total_impressions

INTEGER

growth_text

TEXT?

raw_json

TEXT

→ comment_intent_scores

crm_escalations

133 rows

INTEGER

name

TEXT?

company

TEXT?

headline

TEXT?

profile_url

TEXT?

interaction_count

INTEGER?

highest_score

INTEGER?

last_intent

TEXT?

suggested_inmail_draft

TEXT?

status

TEXT?

escalated_at

TEXT?

→ comment_intent_scores

direct_messages

4 rows

INTEGER

entity_id

INTEGER

direction

TEXT

sender_name

TEXT

message_text

TEXT

timestamp

TEXT

context_tags

TEXT?

→ entities→ comment_intent_scores

discovered_opportunities

3 rows

INTEGER

post_urn

TEXT?

post_url

TEXT?

author_name

TEXT?

author_headline

TEXT?

post_text

TEXT?

discovery_source

TEXT?

relevance_score

INTEGER?

proposed_comment

TEXT?

status

TEXT?

discovered_at

TEXT?

published_at

TEXT?

→ comment_intent_scores→ posts

entities

851 rows

INTEGER

linkedin_url

TEXT

name

TEXT

headline

TEXT?

seniority_level

TEXT?

company_id

INTEGER?

location_id

INTEGER?

first_seen_at

TEXT

last_seen_at

TEXT

← comments← connections← direct_messages+5 more

executive_intelligence_dossiers

1 rows

INTEGER

entity_id

INTEGER

name

TEXT

headline

TEXT?

profile_url

TEXT

relationship_tier

TEXT

prior_shared_context

TEXT?

specialized_domain_intelligence

TEXT?

affiliations_history

TEXT?

reconnection_strategy

TEXT?

reconnection_trigger_topics

TEXT?

status

TEXT

created_at

TEXT

last_updated_at

TEXT

→ entities→ comment_intent_scores

historical_comment_intelligence

20 rows

INTEGER

scraped_at

TEXT

author

TEXT?

relative_time

TEXT?

impressions

INTEGER?

reactions

INTEGER?

replies

INTEGER?

has_stats

INTEGER?

permalink

TEXT?

snippet

TEXT?

→ comment_intent_scores

interactions

48 rows

INTEGER

entity_id

INTEGER

post_id

INTEGER

interaction_type

TEXT

interaction_text

TEXT?

timestamp

TEXT

comment_id

INTEGER?

→ entities→ posts→ comments+1 more

locations

10 rows

INTEGER

city

TEXT?

region

TEXT?

country

TEXT?

← entities→ comment_intent_scores

post_commenters

0 rows

INTEGER

post_id

INTEGER?

name

TEXT?

headline

TEXT?

profile_url

TEXT?

comment_snippet

TEXT?

is_executive

INTEGER?

executive_tier

TEXT?

scraped_at

TEXT?

→ posts→ comment_intent_scores

posts

78 rows

INTEGER

urn

TEXT

title

TEXT

topic_cluster

TEXT?

group_id

TEXT?

published_at

TEXT?

impressions

INTEGER?

← comments← interactions← post_commenters+3 more

Multi-Modal Discovered Relationships (30)

Explicit constraints, fuzzy heuristics & AST code inferences

comments.post_idposts.id

Explicit FK (100%)

FOREIGN KEY (post_id) REFERENCES posts(id)

comments.author_entity_identities.id

Explicit FK (100%)

FOREIGN KEY (author_entity_id) REFERENCES entities(id)

connections.entity_identities.id

Explicit FK (100%)

FOREIGN KEY (entity_id) REFERENCES entities(id)

direct_messages.entity_identities.id

Explicit FK (100%)

FOREIGN KEY (entity_id) REFERENCES entities(id)

entities.company_idcompanies.id

Explicit FK (100%)

FOREIGN KEY (company_id) REFERENCES companies(id)

entities.location_idlocations.id

Explicit FK (100%)

FOREIGN KEY (location_id) REFERENCES locations(id)

executive_intelligence_dossiers.entity_identities.id

Explicit FK (100%)

FOREIGN KEY (entity_id) REFERENCES entities(id)

interactions.entity_identities.id

Explicit FK (100%)

FOREIGN KEY (entity_id) REFERENCES entities(id)

interactions.post_idposts.id

Explicit FK (100%)

FOREIGN KEY (post_id) REFERENCES posts(id)

interactions.comment_idcomments.id

Explicit FK (100%)

FOREIGN KEY (comment_id) REFERENCES comments(id)

post_commenters.post_idposts.id

Explicit FK (100%)

FOREIGN KEY (post_id) REFERENCES posts(id)

comment_intent_scores.idcomments.id

Heuristic Naming (94%)

Heuristic: column 'id' directly matches primary key of table 'comments'

comment_intent_scores.comment_idcomments.id

Heuristic Naming (92%)

Heuristic: column 'comment_id' references target table 'comments' primary key

comment_intent_scores.post_idposts.id

Heuristic Naming (92%)

Heuristic: column 'post_id' references target table 'posts' primary key

comments.idcomment_intent_scores.id

Heuristic Naming (94%)