| 36642 |
ranu |
1 |
CREATE TABLE user.lead_visit_approval
|
|
|
2 |
(
|
|
|
3 |
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
|
4 |
lead_id INT NOT NULL,
|
|
|
5 |
assigned_to INT NOT NULL,
|
|
|
6 |
requested_by INT NOT NULL,
|
|
|
7 |
beat_plan_group_id VARCHAR(100),
|
|
|
8 |
beat_date DATE NOT NULL,
|
|
|
9 |
beat_name VARCHAR(200),
|
|
|
10 |
schedule_timestamp DATETIME,
|
|
|
11 |
status VARCHAR(20) NOT NULL DEFAULT 'PENDING',
|
|
|
12 |
approved_by INT DEFAULT 0,
|
|
|
13 |
approved_timestamp DATETIME,
|
|
|
14 |
remark VARCHAR(500),
|
|
|
15 |
created_timestamp DATETIME NOT NULL,
|
|
|
16 |
updated_timestamp DATETIME NOT NULL,
|
|
|
17 |
INDEX idx_lva_lead (lead_id),
|
|
|
18 |
INDEX idx_lva_status (status),
|
|
|
19 |
INDEX idx_lva_assigned (assigned_to, status)
|
|
|
20 |
);
|
|
|
21 |
|
|
|
22 |
-- Geo Review menu
|
|
|
23 |
INSERT INTO auth.menu (display_text, description, parent_menu_id, sequence, action_class)
|
|
|
24 |
VALUES ('Geo Review', 'Review lead geolocation submissions', 175, 4, 'geo-review');
|
|
|
25 |
|
|
|
26 |
-- Visit Approvals menu (Sales L3+ only)
|
|
|
27 |
INSERT INTO auth.menu (display_text, description, parent_menu_id, sequence, action_class)
|
|
|
28 |
VALUES ('Visit Approvals', 'Approve lead visit requests', 175, 5, 'visit-approvals');
|