form database

form.sql

form database

####################################################################

# Dump of table branch
# ------------------------------------------------------------

CREATE TABLE `branch` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PARENT_CONTACT_EMAIL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VOLUNTEER_CONTACT_EMAIL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CREATED_AT` datetime NOT NULL,
  `UPDATED_AT` datetime NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table coupon
# ------------------------------------------------------------

CREATE TABLE `coupon` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `CODE` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `FORM_ANSWER_SUMMARY_ID` int(11) NOT NULL,
  `CREATED_AT` datetime NOT NULL,
  `UPDATED_AT` datetime NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `coupon_code_unique` (`CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table cs_migrations
# ------------------------------------------------------------

CREATE TABLE `cs_migrations` (
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table form
# ------------------------------------------------------------

CREATE TABLE `form` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `BRANCH_ID` int(10) unsigned NOT NULL,
  `TYPE_ID` tinyint(3) unsigned NOT NULL,
  `TARGET_YEAR` int(10) unsigned NOT NULL,
  `MAX_MALE` int(10) unsigned DEFAULT NULL,
  `MAX_FEMALE` int(10) unsigned DEFAULT NULL,
  `MAX_TOTAL` int(10) unsigned NOT NULL,
  `NOTICE` mediumtext COLLATE utf8_unicode_ci,
  `BEGIN_AT` datetime DEFAULT NULL,
  `END_AT` datetime DEFAULT NULL,
  `IS_OPEN` tinyint(4) NOT NULL DEFAULT '0',
  `CREATED_AT` datetime NOT NULL,
  `UPDATED_AT` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `FORM_UK_01` (`BRANCH_ID`,`TYPE_ID`,`TARGET_YEAR`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table form_answer_detail
# ------------------------------------------------------------

CREATE TABLE `form_answer_detail` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ANSWERS` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `CREATED_AT` datetime NOT NULL,
  `UPDATED_AT` datetime NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table form_answer_summary
# ------------------------------------------------------------

CREATE TABLE `form_answer_summary` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `FORM_ID` int(11) NOT NULL,
  `EMAIL` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `NAME` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `SEX` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FORM_ANSWER_DETAIL_ID` int(11) NOT NULL,
  `CREATED_AT` datetime NOT NULL,
  `UPDATED_AT` datetime NOT NULL,
  `TOKEN` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `COUPON_CODE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `form_answer_summary_form_id_index` (`FORM_ID`),
  KEY `form_answer_summary_email_index` (`EMAIL`),
  KEY `form_answer_summary_name_index` (`NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table form_question
# ------------------------------------------------------------

CREATE TABLE `form_question` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `FORM_ID` int(11) NOT NULL,
  `QUESTIONS` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `CREATED_AT` datetime NOT NULL,
  `UPDATED_AT` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `form_question_form_id_unique` (`FORM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table parent_voice
# ------------------------------------------------------------

CREATE TABLE `parent_voice` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `TEXT` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `IS_DISPLAY` tinyint(4) NOT NULL DEFAULT '1',
  `CREATED_AT` datetime NOT NULL,
  `UPDATED_AT` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table staff
# ------------------------------------------------------------

CREATE TABLE `staff` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `BRANCH_ID` int(10) unsigned NOT NULL,
  `NAME` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `EMAIL` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `MOBILE_PHONE` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `FACEBOOK_PROFILE_URL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CREATED_AT` datetime NOT NULL,
  `UPDATED_AT` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `staff_email_unique` (`EMAIL`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;