notification
表 · 8 字段
暂无表描述
字段信息
| 字段名 | 类型 | 必填 | 说明 | 关联关系 |
|---|---|---|---|---|
| id主键 | varchar(20) | 否 | - | - |
| type | varchar(40) | 是 | - | - |
| body | text | 是 | - | - |
| is_read | tinyint(1) | 是 | - | - |
| is_deleted | tinyint(1) | 是 | - | - |
| fk_user_id索引 | varchar(20) | 是 | - | - |
| created_at索引 | timestamp | 否 | - | - |
| updated_at | timestamp | 否 | - | - |
索引信息
notification_created_at_index
普通索引: created_at
notification_fk_user_id_index
普通索引: fk_user_id
PRIMARY
唯一索引: id
相关表
v_current_performance_config
v_employee_with_dept
v_按天业绩统计_净实收计算
v_钉钉员工表
v_销售业绩
v_销售业绩_快照版
conversation_sessions
crm_member_orders
customer_pool_proxy
department_mapping
dingtalk_employee_raw
employee_roster
n8n_html_reports
order_salesperson_snapshot
performance_verification
sales_amount_manual_input
star_subject
weike_phone_mapping
wm_order_discounts
wm_order_items
wm_order_rights
wm_orders