dbo.activity_participants - Activities

Columns

		Name	Data type	Attributes	References	Description	Sensitive	Information type
	1	activity_participant_id	int	Identity
Identity
	2	activity_id	int		dbo.activities
References: dbo.activities
	3	role_code	varchar(50)		dbo.activity_participant_roles
References: dbo.activity_participant_roles
	4	contact_id	int		dbo.contacts
References: dbo.contacts
	5	company_id	int		dbo.companies
References: dbo.companies
	6	name	varchar(150)
	7	email	varchar(100)				Confidential - GDPR	Contact Info
	8	created_by	nvarchar(100)			Login of user who created row
Login of user who created row
	9	created_date	datetime	Default: getdate()
Default: getdate()
	10	modified_by	nvarchar(100)			Login of user who last modified row
Login of user who last modified row
	11	modification_date	datetime	Default: getdate()		Date and time of row last modification
Date and time of row last modification Default: getdate()

Relations

Foreign table	Primary table	Join	Title / Name / Description
dbo.activity_participants	dbo.activities	dbo.activity_participants.activity_id = dbo.activities.activity_id	FK_activity_participants_activity
dbo.activity_participants.activity_id = dbo.activities.activity_id Name: FK_activity_participants_activity
dbo.activity_participants	dbo.activity_participant_roles	dbo.activity_participants.role_code = dbo.activity_participant_roles.role_code	FK_activity_participants_role
dbo.activity_participants.role_code = dbo.activity_participant_roles.role_code Name: FK_activity_participants_role
dbo.activity_participants	dbo.companies	dbo.activity_participants.company_id = dbo.companies.company_id	FK_activity_participants_company
dbo.activity_participants.company_id = dbo.companies.company_id Name: FK_activity_participants_company
dbo.activity_participants	dbo.contacts	dbo.activity_participants.contact_id = dbo.contacts.contact_id	FK_activity_participants_contact
dbo.activity_participants.contact_id = dbo.contacts.contact_id Name: FK_activity_participants_contact

Unique keys

	Key name	Columns	Description
	PK_activity_participants_tab	activity_participant_id

Uses

Name
dbo.activity_participants
dbo.activities
dbo.activity_participant_roles
dbo.companies
dbo.contacts

Exported: 2019-02-04 23:17, Last imported: 2018-02-28 01:29