| | |
|---|
| | | CREATE TABLE `crm_invoice` ( |
|---|
| | | `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID', |
|---|
| | | `no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '开票编号', |
|---|
| | | `customer_id` bigint NOT NULL COMMENT '客户编号', |
|---|
| | | `contract_id` bigint NOT NULL COMMENT '合同编号', |
|---|
| | | `customer_id` bigint DEFAULT NULL COMMENT '客户编号', |
|---|
| | | `contract_id` bigint DEFAULT NULL COMMENT '合同编号', |
|---|
| | | `owner_user_id` bigint NOT NULL COMMENT '负责人编号', |
|---|
| | | `invoice_type` int NOT NULL COMMENT '发票类型（字典 crm_invoice_type）', |
|---|
| | | `invoice_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '发票号码', |
|---|
