Table lawprod.MSCM.CHARGE_HEADER Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
CHARGE_ID number 22
CHARGE_DETAIL.CHARGE_ID SYS_C00914786 R
CHARGE_SUPPLY_LOCATION.CHARGE_ID SYS_C00914810 R
REVENUE_CENTER_ID number 22
REVENUE_CENTER.REVENUE_CENTER_ID SYS_C00914775 R
PATIENT_LOCATION_ID number 22  √  null
PATIENT_LOCATION.PATIENT_LOCATION_ID SYS_C00914777 R
REQ_LOC_ID number 22
TXN_TYPE char 1
TXN_TYPE.TXN_TYPE Implied Constraint R
IS_FLOOR_CHARGE char 1
BATCH_NO number 22  √  null
DRAFT_NO number 4  √  null
USER_ID number 22
USERS.USER_ID Implied Constraint R
CHARGE_DATE date 7
TXN_DATE date 7
LAST_UPDATE_DATE date 7  √  null
PATIENT_VISIT_ID number 22  √  null
PATIENT_VISIT.PATIENT_VISIT_ID SYS_C00914852 R

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
CHARGE_ID Primary key Asc SYS_C00914774

Close relationships  within of separation: