invoices发票
yjgw 库的实体表 · 13 个字段 · 主键 id · 数据行约 2
字段结构
| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|
| id | char(36) | PRI | NO | | |
| user_id | char(36) | | YES | | |
| invoice_type | longtext | | YES | | |
| title | longtext | | YES | | |
| tax_number | longtext | | YES | | |
| order_ids | longtext | | YES | | |
| total_amount | decimal(12,2) | | YES | | |
| status | longtext | | YES | | |
| save_as_template | tinyint(1) | | YES | | |
| remark | longtext | | YES | | |
| is_deleted | tinyint(1) | | YES | | |
| created_at | datetime(3) | | YES | | |
| updated_at | datetime(3) | | YES | | |
索引
样本数据 · 已脱敏 · 前 3 行
| id | user_id | invoice_type | title | tax_number | order_ids | total_amount | status | save_as_template | remark | is_deleted | created_at |
|---|
| c13b55e9-e371-556f-baf7-8acd8022be58 | 0da15089-2a5b-4222-bc11-95990ae1c9c5 | personal | 个人-陈明 | 9150000000000000AB | ["YJDEMO20261109011"] | 188.50 | PENDING | 0 | NULL | 0 | 2026-11-09 04:43:58.185000 |
| e78a8a45-c476-5dab-acbb-77815c6b8ce0 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | personal | 个人-普通用户小李 | 9150000000000000AB | ["YJDEMO20261109010"] | 100.00 | ISSUED | 0 | NULL | 0 | 2026-11-09 04:43:58.185000 |