| | |
| | | is_active BOOLEAN DEFAULT TRUE, -- 是否激活 |
| | | remarks TEXT, -- 备注 |
| | | registrant_id BIGINT, -- 登记人id,不允许为空 |
| | | registrant VARCHAR(255) NOT NULL, -- 登记人,不允许为空 |
| | | registrant VARCHAR(255), -- 登记人,不允许为空 |
| | | registration_date DATE NOT NULL, -- 登记日期,不允许为空 |
| | | status VARCHAR(255), -- 状态 |
| | | |
| | | deleted INT NOT NULL DEFAULT 0, -- 软删除标志:0=未删除,1=已删除 |
| | | create_by VARCHAR(255), -- 创建人用户名 |
| | |
| | | COMMENT |
| | | ON COLUMN timing_task.inspection_location IS '巡检地点'; |
| | | COMMENT |
| | | ON COLUMN timing_task.frequency IS '频次'; |
| | | ON COLUMN timing_task.frequency_type IS '频次'; |
| | | COMMENT |
| | | ON COLUMN timing_task.remarks IS '备注'; |
| | | COMMENT |