| entity_id parent_entity_id orgId dcnId funnelno funneldesc logged_date logged_by last_updated_date last_updated_by rowstate
|
|
|
|
|
|
|
|
|
|
|
|
|
| create table query
|
| CREATE TABLE `crmsalesfunnel` (
|
| `entity_id` bigint(20) NOT NULL AUTO_INCREMENT,
|
| `parent_entity_id` int(11) NOT NULL,
|
| `orgId` int(11) NOT NULL,
|
| `dcnId` int(11) NOT NULL DEFAULT '1',
|
| `funnelno` varchar(50) NOT NULL,
|
| `funneldesc` varchar(256) DEFAULT NULL,
|
| `logged_date` datetime NOT NULL,
|
| `logged_by` bigint(20) DEFAULT NULL,
|
| `last_updated_date` datetime DEFAULT NULL,
|
| `last_updated_by` bigint(20) DEFAULT NULL,
|
| `rowstate` int(11) NOT NULL,
|
| PRIMARY KEY (`entity_id`,`dcnId`),
|
| KEY `idx_funnelno` (`funnelno`),
|
| KEY `idx_funneldesc` (`funneldesc`)
|
| )
|