Patient name


Contents

Description

Attributes

Column Name Type Default Description
Primary Key patient_name_id int
Required preferred bit
Required patient_id patient.patient_id int
prefix varchar(50) NULL
given_name varchar(50) NULL
middle_name varchar(50) NULL
family_name_prefix varchar(50) NULL
family_name varchar(50) NULL
family_name2 varchar(50) NULL
family_name_suffix varchar(50) NULL
degree varchar(50) NULL
Required creator users.user_id int
Required date_created datetime 0000-00-00 00:00:00
Required voided bit
voided_by users.user_id int NULL
date_voided datetime NULL
void_reason varchar(255) NULL
changed_by int NULL
date_changed datetime NULL
Primary Key primary key, Required required