death 
Logical Entity Name  death 
Default Table Name  death 
Physical Only  NO 
Do Not Generate  False 
Owner  dbo 
Definition 
 
Note 
 
PreSQL   
DDL Code  CREATE TABLE dbo.death(
     eventid            int              IDENTITY(1,1),
     individid          nvarchar(11)     NULL,
     observeid          nvarchar(12)     NULL,
     dth_date           datetime         NULL,
     dth_reasonid       int              NULL,
     dth_reason         ntext            NULL,
     dth_placeid        int              NULL,
     dth_otherplace     ntext            NULL,
     dth_age            float            NULL,
     individidGuid      varchar(36)      NULL,
     EID                varchar(36)      NULL,
     COD                varchar(10)      NULL,
     CONSTRAINT PK__death__2DC8B11114F38B78 PRIMARY KEY CLUSTERED (eventid),
     CONSTRAINT FK_death_dic_DeathPlace FOREIGN KEY (dth_placeid)
     REFERENCES dbo.dic_DeathPlace(DeathPlaceID),
     CONSTRAINT FK_death_dic_DeathReason FOREIGN KEY (dth_reasonid)
     REFERENCES dbo.dic_DeathReason(dth_ReasonID),
     CONSTRAINT Refindividual24 FOREIGN KEY (individid)
     REFERENCES dbo.individual(individid),
     CONSTRAINT Refobservation39 FOREIGN KEY (observeid)
     REFERENCES dbo.observation(observeid)
)
TEXTIMAGE_ON PRIMARY

go
 
PostSQL   

death Columns 
ColumnName  Domain  Datatype  NULL  Definition 
eventid(PK)    int  NO 
 
individid(FK)    nvarchar(11)  YES 
 
observeid(FK)    nvarchar(12)  YES 
 
dth_date    datetime  YES 
 
dth_reasonid(FK)    int  YES 
 
dth_reason    ntext  YES 
 
dth_placeid(FK)    int  YES 
 
dth_otherplace    ntext  YES 
 
dth_age    float  YES 
 
individidGuid    varchar(36)  YES 
 
EID    varchar(36)  YES 
 
COD    varchar(10)  YES 
 

death Primary and Unique Keys 
Key Name  Key Type  Keys 
PK__death__2DC8B11114F38B78  PrimaryKey  eventid 

death Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
individual  Non-Identifying  Zero or One to Zero or More        individid  NO  NO 
observation  Non-Identifying  Zero or One to Zero or More        observeid  NO  NO 
dic_DeathPlace  Non-Identifying  Zero or One to Zero or More  FK_death_dic_DeathPlace      dth_placeid  NO  NO 
dic_DeathReason  Non-Identifying  Zero or One to Zero or More  FK_death_dic_DeathReason      dth_reasonid  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 

death Check Constraints 
Check Constraint Name  CheckConstraint 

death Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group  PRIMARY 

death Growth Metrics 
TABLE METRIC  TABLE METRIC VALUE 
Current Row Count  0 
Growth  Static 
Growth Type  N/A 
Growth Period  N/A 
Maximum Rows  0 

death Object Permissions 

User/Role Name  Grantee Type  Permission Type  Action Type  Is Action Extended  Is System 
death Security Types 
Name  Current Value 

death Bound Attachments 
Name  Current Value 

death Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.death 		 NO       
Physical (Microsoft SQL Server)
dbo.death 		 NO       

death Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  death 
Physical (Microsoft SQL Server)  Main Model 

death Data Movement Rules 
Name  Type  Rule Text/Value