| id |
int(11)
|
|
|
|
| document_id |
int(11)
|
|
|
|
| user_id |
int(11)
|
|
|
|
| signature_id |
int(11)
|
|
|
|
| user_name |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| sign_type |
enum('sign', 'initial', 'approve')
|
utf8mb4_general_ci
|
|
|
| page_no |
int(11)
|
|
|
|
| pos_x |
double
|
|
|
|
| pos_y |
double
|
|
|
|
| box_width |
double
|
|
|
|
| box_height |
double
|
|
|
|
| signed |
tinyint(1)
|
|
|
|
| signed_time |
datetime
|
|
|
|
| otp_verified |
tinyint(1)
|
|
|
|
| sign_order |
int(11)
|
|
|
|
| status |
enum('waiting', 'signed', 'rejected', 'returned')
|
utf8mb4_general_ci
|
|
|
| note |
text
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| sign_status |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| sign_time |
datetime
|
|
|
|
