duty_visit_external_contact

id pk type=uuid, required duty_visit_id duty_visit

FK ⌄

type=uuid, required external_contact_id external_contact

FK ⌄

type=uuid, required contact_role enum: HOST | GUEST | COUNTERPART | SPEAKER | VISITOR | LIAISON | OTHER NULL HOST GUEST COUNTERPART SPEAKER VISITOR LIAISON OTHER type=contact_role_enum, nullable met_via_org_id organization

FK ⌄

type=uuid, nullable remarks type=text, nullable