locationinfo 
Logical Entity Name  locationinfo 
Default Table Name  locationinfo 
Physical Only  NO 
Do Not Generate  False 
Owner  dbo 
Definition 
 
Note 
 
PreSQL   
DDL Code  CREATE TABLE dbo.locationinfo(
     locationinforid      nvarchar(11)     NOT NULL,
     locationid           nvarchar(7)      NULL,
     lif_year             smallint         CONSTRAINT [DF__locationi__lif_y__5AB9788F] DEFAULT (0) NULL,
     responsorid          nvarchar(35)     NULL,
     hcdistance           float            CONSTRAINT [DF__locationi__hcdis__5BAD9CC8] DEFAULT (0) NULL,
     hosdistance          float            CONSTRAINT [DF__locationi__hosdi__5CA1C101] DEFAULT (0) NULL,
     hctimemotor          float            CONSTRAINT [DF__locationi__hctim__5D95E53A] DEFAULT (0) NULL,
     hostimemotor         float            CONSTRAINT [DF__locationi__hosti__5E8A0973] DEFAULT (0) NULL,
     hctimemotorcycle     float            CONSTRAINT [DF__locationi__hctim__5F7E2DAC] DEFAULT (0) NULL,
     hostimemotorbike     float            CONSTRAINT [DF__locationi__hosti__607251E5] DEFAULT (0) NULL,
     hctimewalk           float            CONSTRAINT [DF__locationi__hctim__6166761E] DEFAULT (0) NULL,
     hostimewalk          float            CONSTRAINT [DF__locationi__hosti__625A9A57] DEFAULT (0) NULL,
     status_dat           nvarchar(1)      NULL,
     round                smallint         CONSTRAINT [DF__locationi__round__634EBE90] DEFAULT (0) NULL,
     dedate               datetime         NULL,
     dataclerk            nvarchar(2)      NULL,
     CONSTRAINT PK__location__5D28F9506451FCCA PRIMARY KEY CLUSTERED (locationinforid DESC),
     CONSTRAINT Reflocation31 FOREIGN KEY (locationid)
     REFERENCES dbo.location(locationid)
)

go
 
PostSQL   

locationinfo Columns 
ColumnName  Domain  Datatype  NULL  Definition 
locationinforid(PK)    nvarchar(11)  NO 
 
locationid(FK)    nvarchar(7)  YES 
 
lif_year    smallint  YES 
 
responsorid    nvarchar(35)  YES 
 
hcdistance    float  YES 
 
hosdistance    float  YES 
 
hctimemotor    float  YES 
 
hostimemotor    float  YES 
 
hctimemotorcycle    float  YES 
 
hostimemotorbike    float  YES 
 
hctimewalk    float  YES 
 
hostimewalk    float  YES 
 
status_dat    nvarchar(1)  YES 
 
round    smallint  YES 
 
dedate    datetime  YES 
 
dataclerk    nvarchar(2)  YES 
 

locationinfo Primary and Unique Keys 
Key Name  Key Type  Keys 
PK__location__5D28F9506451FCCA  PrimaryKey  locationinforid 

locationinfo Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
location  Non-Identifying  Zero or One to Zero or More        locationid  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 

locationinfo Check Constraints 
Check Constraint Name  CheckConstraint 

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

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

locationinfo Object Permissions 

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

locationinfo Bound Attachments 
Name  Current Value 

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

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

locationinfo Data Movement Rules 
Name  Type  Rule Text/Value