| CREATE TABLE `crmdocuploadconfiguration` (
|
| `entity_id` bigint(20) NOT NULL,
|
| `parent_entity_id` int(11) NOT NULL,
|
| `orgid` int(11) NOT NULL,
|
| `dcnid` int(11) NOT NULL,
|
| `docdocument` varchar(100) DEFAULT NULL,
|
| `doctitile` varchar(100) DEFAULT NULL,
|
| `docdescription` varchar(256) DEFAULT NULL,
|
| `logged_date` datetime NOT NULL,
|
| `last_updated_date` datetime DEFAULT NULL,
|
| `logged_by` bigint(20) DEFAULT NULL,
|
| `last_updated_by` bigint(20) DEFAULT NULL,
|
| `rowstate` int(11) NOT NULL,
|
| `docowner` varchar(508) DEFAULT NULL,
|
| `moduleflag` varchar(254) DEFAULT NULL,
|
| `docentityId` bigint(20) DEFAULT NULL,
|
| `docccategory` varchar(25) DEFAULT NULL,
|
| `assignedowner` bigint(100) DEFAULT NULL,
|
| PRIMARY KEY (`entity_id`,`dcnid`),
|
| KEY `idx_moduleflag` (`moduleflag`)
|
| ) ENGINE=InnoDB DEFAULT CHARSET=latin1
|