aurora_standard.chmnotrr
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| note_no | bigint(20) unsigned | NO | PRI | auto_increment | ||
| visit_no | int(11) | YES | MUL | |||
| guar_no | int(11) | YES | MUL | |||
| note_date | date | YES | MUL | |||
| note_time | time | YES | ||||
| input_by | int(11) | YES | ||||
| action_code | varchar(10) | YES | ||||
| action_date | date | YES | MUL | |||
| contract_no | int(11) | YES | ||||
| create_date | date | YES | MUL | |||
| create_time | time | YES |