table - sn_publications_publication_contact_m2m «Publication Recipients» - erm4sn

Derivation Hierarchy

sn_publications_publication_contact_m2m
«Publication Recipients»

Targeted Communications

Subclasses:: No Subclasses
Siblings:: No Siblings

Table Details

Name:: sn_publications_publication_contact_m2m
Label:: Publication Recipients (en)

Created On:: 2022.09.17 02:16:31
Created By:: system

Updated On:: 2022.09.17 02:55:17
Updated By:: system

Column Updated On:: 2022.09.17 02:16:31
Column Updated By:: system

Scope Name:: Targeted Communications
Scope:: sn_publications

Listing:: open
Dictionary:: open

Columns

+	Status	Name	Label	Datatype	Length	Scope	Reference	Included By
		email_address	Email Address	email	1024	Targeted Communications		sn_publications_publication_contact_m2m
	M D	name	Name	string_full_utf8	255	Targeted Communications		sn_publications_publication_contact_m2m
	M	publication	Publication	reference	32	Targeted Communications	sn_publications_publication	sn_publications_publication_contact_m2m
		sys_created_by	Created by	string	40	Global		sn_publications_publication_contact_m2m
		sys_created_on	Created	glide_date_time	40	Global		sn_publications_publication_contact_m2m
	K	sys_id	Sys ID	GUID	32	Targeted Communications		sn_publications_publication_contact_m2m
		sys_mod_count	Updates	integer	40	Global		sn_publications_publication_contact_m2m
		sys_updated_by	Updated by	string	40	Global		sn_publications_publication_contact_m2m
		sys_updated_on	Updated	glide_date_time	40	Global		sn_publications_publication_contact_m2m
		type	Type	choice[choice]	40	Targeted Communications		sn_publications_publication_contact_m2m
		user	User	reference	32	Targeted Communications	sys_user	sn_publications_publication_contact_m2m
		viewed_article	Viewed Article	boolean	40	Targeted Communications		sn_publications_publication_contact_m2m
		viewed_attachment	Viewed Attachment	boolean	40	Targeted Communications		sn_publications_publication_contact_m2m

P

Passive

M

Mandatory

D

Display Value

K

Key

U

Unique

X

Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column	Current Environment	Washington	Vancouver	Uta	Tokyo (Vanilla)	Sandiego
consumer	missing	missing			missing	missing

Diagram sn_publications_publication_contact_m2m «Publication Recipients» / Targeted Communications (sn_publications)

shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out