name_entities

-1 rows


Description

Table to hold different personal or organizational names

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('name_entities_id_seq'::regclass)
name_entity_identifiers.name_entity_id name_entitie_identifiers_name_entity_id_fkeyR
record_contributors.name_entity_id record_contributors_name_entity_id_fkeyR
record_creators.name_entity_id record_creators_name_entity_id_fkeyR
full_name text 2147483647 null
name_type text 2147483647 'Personal'::text

datacite:nameType
family_name text 2147483647 √ null
given_name text 2147483647 √ null
created_at timestamp 29,6 now()
updated_at timestamp 29,6 now()

Indexes

Constraint Name Type Sort Column(s)
name_entities_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
name_entities_name_type_check ((name_type = ANY (ARRAY['Personal'::text, 'Organizational'::text])))

Relationships

Close relationships within degrees of separation