dim_bed

9761 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
dim_bed_key int identity 4 √ null
fact_patient_census.dim_bed_key Implied ConstraintR
stage_patient_census.dim_bed_key Implied ConstraintR
facilityid int 4 √ null
PCC_Cache_FacID.FacilityID Implied ConstraintR
bedid int 4 √ null
roomid int 4 √ null
unitid int 4 √ null
beddesc varchar 30 √ null
createddate datetime 16,3 √ null
revisiondate datetime 16,3 √ null
deleted char 1 √ null
floorid int 4 √ null
floor varchar 256 √ null
retireddate datetime 16,3 √ null
dss_update_time datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
dim_bed_idx_0 Primary key Asc dim_bed_key

Relationships

Close relationships within degrees of separation