全景目录 › 数据库 › yjgw › service_orders

service_ordersyjgw

yjgw 库的实体表 · 36 个字段 · 主键 id · 数据行约 11
36字段数
11数据行数
1索引
yjgw所属库

字段结构

字段类型键可空默认注释
idchar(36)PRINO
typelongtextYES
customer_idchar(36)YES
worker_idchar(36)YES
addresslongtextYES
distancedecimal(8,2)YES
rewarddecimal(10,2)YES
match_ratedecimal(5,2)YES
statuslongtextYES
is_urgenttinyint(1)YES
is_deletedtinyint(1)YES
created_atdatetime(3)YES
updated_atdatetime(3)YES
itemslongtextYES
requirementslongtextYES
estimated_timelongtextYES
scheduled_timedatetime(3)YES
customer_namevarchar(100)YES
customer_phonevarchar(20)YES
ratingint(11)YES
reviewlongtextYES
review_replylongtextYES
order_novarchar(50)YES
service_typevarchar(100)YES
service_datedateYES
service_timelongtextYES
durationint(11)YES
service_addresslongtextYES
latitudedecimal(10,7)YES
longitudedecimal(10,7)YES
noteslongtextYES
completion_timedatetime(3)YES
cancellation_reasonlongtextYES
review_timedatetime(3)YES
payment_methodlongtextYES
payment_timedatetime(3)YES

索引

索引名字段类型
PRIMARYid唯一

样本数据 · 已脱敏 · 前 3 行

idtypecustomer_idworker_idaddressdistancerewardmatch_ratestatusis_urgentis_deletedcreated_at
11a751dc-473b-5280-b54b-b73307363fafservice8ff30c1d-d0c1-409b-96ab-f5d0f4b16f988356f74a-8558-40de-b37a-29c7f3815dbf四川省成都市…1.2080.0088.00pending002026-11-09 04:48:31.553000
2be3ead0-6140-5a73-a035-4e14ab1d9453service8ff30c1d-d0c1-409b-96ab-f5d0f4b16f988356f74a-8558-40de-b37a-29c7f3815dbf四川省成都市…2.40160.0096.00cancelled002026-11-09 04:48:31.553000
38721da6-64f1-57c8-b82f-9dc9c252f88aservice8ff30c1d-d0c1-409b-96ab-f5d0f4b16f988356f74a-8558-40de-b37a-29c7f3815dbf四川省成都市…1.80120.0092.00completed002026-11-09 04:48:31.553000
用户协议隐私政策商家服务协议争议处理规则协议中心意见反馈
中浩贵华(海南)投资有限公司 · 琼ICP备2025057228号-3