Data Type Analysis (Primary Keys)
Fact	SQLServerType	is_identity	key_ordinal	Objects	Columns
31	date	False	2	1	1
31	datetime	False	2	5	5
31	hierarchyid	False	1	1	1
31	hierarchyid	False	2	1	1
31	int	False	1	29	29
31	int	False	2	10	10
31	int	False	3	4	4
31	int	True	1	31	31
31	int	True	2	3	3
31	nchar(0003)	False	1	2	2
31	nchar(0003)	False	2	1	1
31	nchar(0006)	False	1	1	1
31	nchar(0006)	False	3	1	1
31	nvarchar(0003)	False	1	2	2
31	Phone	False	2	1	1
31	smallint	False	2	1	1
31	smallint	False	3	2	2
31	smallint	True	1	3	3
31	tinyint	False	4	1	1
31	tinyint	True	1	2	2