catissue_participant_aud

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 null
REV BIGINT 19 null
os_revisions.REV FK_hs8crr2d3nwca17qqfli82ymR
REVTYPE TINYINT 3 √ null
LAST_NAME VARCHAR 255 √ null
lastName_MOD BIT 1 √ null
FIRST_NAME VARCHAR 255 √ null
firstName_MOD BIT 1 √ null
MIDDLE_NAME VARCHAR 255 √ null
middleName_MOD BIT 1 √ null
BIRTH_DATE DATETIME 19 √ null
birthDate_MOD BIT 1 √ null
GENDER VARCHAR 255 √ null
gender_MOD BIT 1 √ null
GENOTYPE VARCHAR 255 √ null
sexGenotype_MOD BIT 1 √ null
ethnicities_MOD BIT 1 √ null
SOCIAL_SECURITY_NUMBER VARCHAR 255 √ null
uid_MOD BIT 1 √ null
ACTIVITY_STATUS VARCHAR 255 √ null
activityStatus_MOD BIT 1 √ null
DEATH_DATE DATETIME 19 √ null
deathDate_MOD BIT 1 √ null
VITAL_STATUS VARCHAR 255 √ null
vitalStatus_MOD BIT 1 √ null
EMPI_ID VARCHAR 255 √ null
empi_MOD BIT 1 √ null
pmis_MOD BIT 1 √ null
races_MOD BIT 1 √ null
SOURCE VARCHAR 16 √ null
source_MOD BIT 1 √ null
GENDER_ID BIGINT 19 √ null
VITAL_STATUS_ID BIGINT 19 √ null
EMAIL_ADDRESS VARCHAR 255 √ null
emailAddress_Mod BIT 1 √ null
PHONE_NUMBER VARCHAR 32 √ null
phoneNumber_MOD BIT 1 √ null
EMAIL_OPT_IN BIT 1 √ null
emailOptIn_MOD BIT 1 √ null
TEXT_OPT_IN BIT 1 √ null
textOptIn_MOD BIT 1 √ null
TEXT_OPT_IN_CONSENT BIT 1 √ null
textOptInConsent_MOD BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc IDENTIFIER + REV
FK_hs8crr2d3nwca17qqfli82ym Performance Asc REV

Relationships

Close relationships within degrees of separation