aurora_standard.chnvtlsd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| visit_no | int(11) | YES | MUL | |||
| vitals_date | date | YES | ||||
| vitals_time | time | YES | ||||
| chart_no | int(11) | YES | ||||
| chart_id | varchar(10) | YES | ||||
| temperature | decimal(4,1) | YES | ||||
| ap_pulse | smallint(6) | YES | ||||
| rad_pulse | smallint(6) | YES | ||||
| respiration | smallint(6) | YES | ||||
| bp_l_dystolic | decimal(3,0) | YES | ||||
| bp_l_systolic | decimal(3,0) | YES | ||||
| bp_r_dystolic | decimal(3,0) | YES | ||||
| bp_r_systolic | decimal(3,0) | YES | ||||
| input_by | int(11) | YES | ||||
| input_date | date | YES | ||||
| input_time | time | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| visit_no |
| ||||||||||||||||||||||||||
| temperature |
|