| SchemaSpy Analysis of Medextract | Generated by SchemaSpy |
| Generated by SchemaSpy on Tue Dec 21 21:10 EST 2010 | |
| Database Type: Microsoft SQL Server - 9.00.3042 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| Account | 1 | 2 | 36,522 | ||
| AccountItem | 9 | 47,215 | |||
| AccountProcedure | 5 | 2,349 | |||
| AccountReceipt | 7 | 0 | |||
| AccountTypes | 12 | 109 | |||
| c_AccountProcedureValue | 17 | 1,568 | |||
| c_Date | 12 | 426 | |||
| c_Doctor | 11 | 343 | |||
| c_Patient | 20 | 6,227 | |||
| c_Payer | 9 | 6,237 | |||
| c_ResultProcedureCount | 17 | 7,140 | |||
| Procedures | 9 | 3,516 | |||
| procedures | 16 | view | |||
| ProcedureTest | 9 | 50,473 | |||
| Request | 1 | 59 | 36,522 | ||
| RequestCountByDoctor | 12 | view | |||
| ResultProcedure | 13 | 42,967 | |||
| Sections | 2 | 2 | |||
| Users | 17 | 505 | |||
| 17 Tables | 230 | 242,121 | |||
| 2 Views | 28 |