[sql] opportunities
Viewer
- CREATE TABLE `opportunity_details` (
- `id` BIGINT(11) NOT NULL AUTO_INCREMENT COMMENT 'opportunity Id',
- `smec_intl` INT(20) NOT NULL DEFAULT NULL,
- `smec_india` VARCHAR(32) NOT NULL,
- `smec_sj` VARCHAR(20) NOT NULL,
- `service_type_id` INT(11) NOT NULL DEFAULT NULL COMMENT 'Type of Service',
- `project_name` TEXT(64) NOT NULL,
- `project_state_id` INT(32) NOT NULL DEFAULT NULL COMMENT 'Project State Name',
- `project_location` VARCHAR(32) NOT NULL COMMENT 'Project Location',
- `functional_group_id` INT(32) NOT NULL COMMENT 'Functional Group',
- `funded_by_id` INT(11) NOT NULL COMMENT 'Type of service',
- `lead_firm` VARCHAR(32) NOT NULL COMMENT 'Lead Firm',
- `associates_firm` VARCHAR(32) NOT NULL COMMENT 'Associates Firm',
- `client_type` VARCHAR(32) NOT NULL DEFAULT NULL COMMENT 'Client Type',
- `client_name` VARCHAR(32) NOT NULL DEFAULT NULL COMMENT 'Client Name',
- `address` VARCHAR(32) NOT NULL DEFAULT NULL COMMENT 'Client Details Address',
- `position` VARCHAR(32) NOT NULL DEFAULT NULL COMMENT 'Client Details Position',
- `phone` INT(32) NOT NULL DEFAULT NULL COMMENT 'Client Number',
- `email` VARCHAR(32) NOT NULL DEFAULT NULL COMMENT 'Client Email',
- `contact_person` INT(32) NOT NULL DEFAULT NULL COMMENT 'Client Contact Person Name',
- `client_interaction_level` INT(11) NOT NULL DEFAULT NULL COMMENT 'Client Interaction Level',
- `financial_year` DATE NOT NULL DEFAULT NULL,
- `estimated_service_value` INT(11) NOT NULL DEFAULT NULL,
- `project_start_date` DATE NOT NULL DEFAULT NULL,
- `confidence_factor` FLOAT NOT NULL DEFAULT NULL,
- `earnest_money` ENUM NOT NULL DEFAULT '0,1' COMMENT '0 for NO and 1 for Yes',
- `inr_earnest_money` INT(64) NOT NULL DEFAULT NULL,
- `earnest_money_mode` ENUM NOT NULL DEFAULT NULL COMMENT '0=>Demand Draft, 1=>Bank Guarantee, 2 =>Online Transfer',
- `overall_bid_status` VARCHAR(32) NOT NULL DEFAULT NULL,
- `remarks_bid_status` VARCHAR(64) NOT NULL DEFAULT NULL,
- `eoi_due_date` DATE NOT NULL DEFAULT NULL,
- `eoi_status` INT(11) NOT NULL DEFAULT NULL,
- `lead_generator` VARCHAR(32) NOT NULL DEFAULT NULL,
- `proposal_due_date` DATE NOT NULL DEFAULT NULL,
- `proposal_status` VARCHAR(32) NOT NULL DEFAULT NULL,
- `bid_meeting_date` DATE NOT NULL DEFAULT NULL,
- `bid_result_date` DATE NOT NULL DEFAULT NULL,
- `advertisement_files` LONGTEXT NOT NULL DEFAULT NULL,
- `rfp_files` LONGTEXT NOT NULL DEFAULT NULL,
- `pq_files` LONGTEXT NOT NULL DEFAULT NULL,
- `omaf_files` LONGTEXT NOT NULL DEFAULT NULL,
- `risk_matrix_files` LONGTEXT NOT NULL DEFAULT NULL,
- `date_added_at` DATETIME NOT NULL DEFAULT NULL,
- `date_uploaded_at` TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP,
- UNIQUE KEY `id` (`id`) USING BTREE,
- PRIMARY KEY (`id`)
- );
Editor
You can edit this paste and save as new: