Skip to content

Instantly share code, notes, and snippets.

@ishikawam
Last active July 22, 2017 05:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ishikawam/914fd661dc4adf8b983f061c511c7de2 to your computer and use it in GitHub Desktop.
Save ishikawam/914fd661dc4adf8b983f061c511c7de2 to your computer and use it in GitHub Desktop.
form database
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment