Extended Contacts

Extended contact information for actors (phone, email, address, social media).

ahgContactPlugin
All Schemas
11
contact_information
5
contact_information_extended
11
contact_information_i18n
Entity Relationship Diagram
Open Full Size
Extended Contacts ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
contact_information_FK_1 contact_information actor_id actor id
fk_contact_info_ext contact_information_extended contact_information_id contact_information id
contact_information_i18n_FK_1 contact_information_i18n id contact_information id
contact_information
21 columns 11 rows
Column Type Nullable Default Extra Comment
FK actor_id int NOT NULL -
contact_type varchar(50) NULL primary
valid_from date NULL -
valid_to date NULL -
primary_contact tinyint NULL -
contact_person varchar(1024) NULL -
street_address text NULL -
website varchar(1024) NULL -
email varchar(255) NULL -
telephone varchar(255) NULL -
fax varchar(255) NULL -
postal_code varchar(255) NULL -
country_code varchar(255) NULL -
longitude float NULL -
FK latitude float NULL -
created_at datetime NOT NULL -
updated_at datetime NOT NULL -
source_culture varchar(16) NOT NULL -
PK id int NOT NULL - auto_increment
serial_number int NOT NULL 0
contact_note text NULL -
contact_information_extended
14 columns 5 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ contact_information_id int NOT NULL -
title varchar(100) NULL - Mr, Mrs, Dr, Prof, etc.
role varchar(255) NULL - Job title/position
department varchar(255) NULL - Department/Division
cell varchar(255) NULL - Mobile/Cell phone
id_number varchar(50) NULL - ID/Passport number
alternative_email varchar(255) NULL - Secondary email
alternative_phone varchar(255) NULL - Secondary phone
preferred_contact_method varchar(35) NULL - email, phone, cell, fax, mail
language_preference varchar(16) NULL - Preferred communication language
notes text NULL - Additional notes
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
contact_information_i18n
6 columns 11 rows
Column Type Nullable Default Extra Comment
contact_type varchar(1024) NULL -
city varchar(1024) NULL -
region varchar(1024) NULL -
note text NULL -
PK id int NOT NULL -
PK culture varchar(16) NOT NULL -
Notes

Log in to add notes.

Legend
PK Primary Key FK Foreign Key / Index UQ Unique Constraint
Table structures are read live from the database. Row counts reflect current data.