--
-- Table structure for table `gnl_dynamic_form_value`
--

CREATE TABLE `gnl_dynamic_form_value` (
  `id` int(11) NOT NULL,
  `uid` int(11) DEFAULT NULL,
  `type_id` int(11) DEFAULT NULL COMMENT 'primary key (id)\r\n of Type table ',
  `form_id` varchar(50) DEFAULT NULL COMMENT '(uid) of form table ',
  `name` varchar(200) DEFAULT NULL,
  `value_field` varchar(200) DEFAULT NULL,
  `order_by` int(11) DEFAULT NULL,
  `note` text,
  `is_active` tinyint(2) NOT NULL DEFAULT '1',
  `is_delete` tinyint(2) NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for table `gnl_dynamic_form_value`
--
ALTER TABLE `gnl_dynamic_form_value`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `u_id` (`type_id`,`form_id`,`uid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `gnl_dynamic_form_value`
--
ALTER TABLE `gnl_dynamic_form_value`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;


COMMIT;

-- Dynamic form type, form, value table merge on 10/10/2023 for all module.
-- Merged by Md Mozahid Hossain

----------------------------------------------------
        --   Modifcation After Merging (10/10/2023)
----------------------------------------------------
