payments

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
id	BIGINT	19		√	null

|

| | | pid | BIGINT | 19 | | | 0 |

|

| | | dtime | DATETIME | 19 | | | null |

|

| | | encounter | BIGINT | 19 | | | 0 |

|

| | | user | VARCHAR | 255 | √ | | NULL |

|

| | | method | VARCHAR | 255 | √ | | NULL |

|

| | | source | VARCHAR | 255 | √ | | NULL |

|

| | | amount1 | DECIMAL | 12,2 | | | 0.00 |

|

| | | amount2 | DECIMAL | 12,2 | | | 0.00 |

|

| | | posted1 | DECIMAL | 12,2 | | | 0.00 |

|

| | | posted2 | DECIMAL | 12,2 | | | 0.00 |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
pid	Performance	Asc	pid

Relationships

Close relationships within degrees of separation