|
id
|
bigint(20) unsigned
|
|
|
|
|
line_user_id
|
varchar(64)
|
|
|
|
|
state
|
enum
|
-- |
|
collecting
|
|
full_name
|
varchar(150)
|
|
|
|
|
phone
|
varchar(20)
|
|
|
|
|
email
|
varchar(254)
|
|
|
|
|
supplied_line_id
|
varchar(100)
|
|
|
|
|
referral_token
|
char(48)
|
|
|
|
|
referrer_member_id
|
bigint(20) unsigned
|
|
|
|
|
otp_provider
|
varchar(30)
|
|
|
|
|
otp_token
|
varchar(255)
|
|
|
|
|
otp_ref
|
varchar(100)
|
|
|
|
|
otp_phone
|
varchar(20)
|
|
|
|
|
otp_requested_at
|
datetime
|
|
|
|
|
otp_verified_at
|
datetime
|
|
|
|
|
otp_attempts
|
int(10) unsigned
|
|
|
0
|
|
member_id
|
bigint(20) unsigned
|
|
|
|
|
last_message
|
text
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|
|
completed_at
|
datetime
|
|
|
|
|
fallback_due_at
|
datetime
|
|
|
|