SchemaSpy - Table rice-2.2.0-SNAPSHOT.trvl_per_diem

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
ID	decimal	19		0
TRIP_TYP_CD	varchar	3
COUNTRY	varchar	100	√	null
COUNTRY_NM	varchar	100	√	null
COUNTY_CD	varchar	100	√	null
PRI_DEST	varchar	100	√	null
SSN_BGN_DT	datetime	19	√	null
EFFECT_FROM_DT	datetime	19	√	null
EFFECT_TO_DT	datetime	19	√	null
LOAD_DT	datetime	19	√	null
SSN_BGN_MONTH_DAY	varchar	5	√	null
BKFST	decimal	19	√	null
LUNCH	decimal	19	√	null
DIN	decimal	19	√	null
LODGING	decimal	19,2	√	0.00
INC	decimal	19,2	√	0.00
MEALS_INC	decimal	19,2	√	0.00
ACTV_IND	varchar	1
VER_NBR	decimal	8		1
OBJ_ID	varchar	36

Table contained 0 rows at Fri May 10 14:36 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
ID	Primary key	Asc	PRIMARY