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