NABI Biz-Matching ERD

Tables (20)

ai_match_suggestions

  • id — uuid
  • event_id — uuid — Foreign key → events.id — NOT NULL
  • for_org_id — uuid — Foreign key → organizations.id — NOT NULL
  • target_org_id — uuid — Foreign key → organizations.id — NOT NULL
  • ai_score — numeric — NOT NULL
  • ai_score_reasons — jsonb
  • status — text — NOT NULL
  • created_at — timestamptz — NOT NULL

buyer_interest_keywords

  • buyer_profile_id — uuid — Foreign key → buyer_profiles.id — NOT NULL
  • keyword_id — uuid — Foreign key → keywords.id — NOT NULL

buyer_profiles

  • id — uuid
  • org_event_role_id — uuid — Foreign key → organization_event_roles.id — NOT NULL
  • budget_range — text
  • adoption_timeline — text
  • created_at — timestamptz — NOT NULL

conversation_channels

  • id — uuid
  • event_id — uuid — Foreign key → events.id — NOT NULL
  • org_a_id — uuid — Foreign key → organizations.id — NOT NULL
  • org_b_id — uuid — Foreign key → organizations.id — NOT NULL
  • opened_at — timestamptz — NOT NULL

event_organizers

  • id — uuid
  • event_id — uuid — Foreign key → events.id — NOT NULL
  • organizer_id — uuid — Foreign key → organizers.id — NOT NULL

events

  • id — uuid
  • name — text — NOT NULL
  • slug — text — NOT NULL
  • application_start — date
  • application_end — date
  • open_at — date
  • created_at — timestamptz — NOT NULL

exhibitor_keywords

  • exhibitor_profile_id — uuid — Foreign key → exhibitor_profiles.id — NOT NULL
  • keyword_id — uuid — Foreign key → keywords.id — NOT NULL

exhibitor_profiles

  • id — uuid
  • org_event_role_id — uuid — Foreign key → organization_event_roles.id — NOT NULL
  • booth — text
  • strength — text
  • exhibits — text
  • achievements — text
  • created_at — timestamptz — NOT NULL

interested_organizations

  • id — uuid
  • event_id — uuid — Foreign key → events.id — NOT NULL
  • owner_org_id — uuid — Foreign key → organizations.id — NOT NULL
  • target_org_id — uuid — Foreign key → organizations.id — NOT NULL
  • source — text
  • created_at — timestamptz — NOT NULL

keywords

  • id — uuid
  • label — text — NOT NULL
  • category — text

love_calls

  • id — uuid
  • meeting_id — uuid — Foreign key → meetings.id
  • event_id — uuid — Foreign key → events.id — NOT NULL
  • from_org_id — uuid — Foreign key → organizations.id — NOT NULL
  • to_org_id — uuid — Foreign key → organizations.id — NOT NULL
  • created_at — timestamptz — NOT NULL

meeting_participants

  • id — uuid
  • meeting_id — uuid — Foreign key → meetings.id — NOT NULL
  • member_id — uuid — Foreign key → members.id — NOT NULL

meeting_venues

  • id — uuid
  • event_id — uuid — Foreign key → events.id — NOT NULL
  • venue_type — text — NOT NULL
  • label — text — NOT NULL
  • created_at — timestamptz — NOT NULL

meetings

  • id — uuid
  • event_id — uuid — Foreign key → events.id — NOT NULL
  • exhibitor_org_id — uuid — Foreign key → organizations.id — NOT NULL
  • buyer_org_id — uuid — Foreign key → organizations.id — NOT NULL
  • venue_id — uuid — Foreign key → meeting_venues.id
  • matching_type — text — NOT NULL
  • ai_score — numeric
  • ai_score_reasons — jsonb
  • status — text — NOT NULL
  • requested_by — text
  • scheduled_start — timestamptz
  • scheduled_end — timestamptz
  • created_at — timestamptz — NOT NULL

members

  • id — uuid
  • organization_id — uuid — Foreign key → organizations.id — NOT NULL
  • name — text — NOT NULL
  • email — text — NOT NULL
  • title — text
  • created_at — timestamptz — NOT NULL

organization_event_roles

  • id — uuid
  • organization_id — uuid — Foreign key → organizations.id — NOT NULL
  • event_id — uuid — Foreign key → events.id — NOT NULL
  • is_exhibitor — boolean — NOT NULL
  • is_buyer — boolean — NOT NULL
  • buyer_subtype — text
  • created_at — timestamptz — NOT NULL

organizations

  • id — uuid
  • name — text — NOT NULL
  • description — text
  • founded — text
  • employees — text
  • created_at — timestamptz — NOT NULL

organizers

  • id — uuid
  • name — text — NOT NULL
  • email — text — NOT NULL
  • permission_level — text — NOT NULL
  • created_at — timestamptz — NOT NULL

post_meeting_reviews

  • id — uuid
  • meeting_id — uuid — Foreign key → meetings.id — NOT NULL
  • reviewer_org_id — uuid — Foreign key → organizations.id — NOT NULL
  • follow_up_intent — text
  • fit_rating — text
  • fit_reason — text
  • created_at — timestamptz — NOT NULL

visitors

  • id — uuid
  • event_id — uuid — Foreign key → events.id — NOT NULL
  • qr_token — text — NOT NULL
  • status — text — NOT NULL
  • converted_org_id — uuid — Foreign key → organizations.id
  • created_at — timestamptz — NOT NULL