-- MySQL dump 10.13  Distrib 8.0.30, for Win64 (x86_64)
--
-- Host: 192.168.30.25    Database: sdoh_staging
-- ------------------------------------------------------
-- Server version	8.0.34-0ubuntu0.20.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `tbl_survey_questions`
--

DROP TABLE IF EXISTS `tbl_survey_questions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_survey_questions` (
  `surveyQuestion_Id` int NOT NULL AUTO_INCREMENT,
  `category` varchar(100) DEFAULT NULL,
  `question` varchar(500) DEFAULT NULL,
  `question_spanish` varchar(500) DEFAULT NULL,
  `service_id` int DEFAULT NULL,
  PRIMARY KEY (`surveyQuestion_Id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_survey_questions`
--

LOCK TABLES `tbl_survey_questions` WRITE;
/*!40000 ALTER TABLE `tbl_survey_questions` DISABLE KEYS */;
INSERT INTO `tbl_survey_questions` VALUES (1,'ID','Do you have a valid government issued ID?','¿Tiene una identificación válida emitida por el gobierno?',1),(2,'Food','Do you eat less than you feel you	should	because	there’s	not	enough food ?','¿Comes menos de lo que crees que deberías porque no hay suficiente comida?',2),(3,'Housing','Are	you	worried	that	in	the	next	few	months,	you	may	not	have	safe	housing	that	you	own,	rent	or	share?','¿Le preocupa que en los próximos meses no tenga una vivienda segura que sea propia, alquilada o compartida?',3),(4,'Utilities','In   the	past	year,	have	you	had	a	hard	time	paying	your utility	company	bills?','Durante el año pasado, ¿ha tenido dificultades para pagar las facturas de su compañía de servicios públicos?',4),(5,'Clothing','Are	you	in	need of	clothing	to	meet	your	daily	needs? ','¿Necesitas ropa para cubrir tus actividades diarias?',5),(6,'Finances','Are	your	finances	covering	your	living	costs? ','¿Sus finanzas cubren sus costos de vida?',6),(7,'Transportation','Do	you	have	a	dependable	way	to	get	to	work	or	school	and	your	appointments?	','¿Tiene una forma confiable de llegar al trabajo o la escuela y a sus citas?',7),(8,'Education','Do you	think	completing	more	education	or	training,	like finishing	a	GED,	going	to	college	or learning	a	trade would	be	helpful	to	you?','¿Cree que le sería útil completar más educación o capacitación, como terminar un GED, ir a la universidad o aprender un oficio?',8),(9,'Employment','Do	you	have	a	job	or	other	steady	source	of	income?	','¿Tiene usted un trabajo u otra fuente estable de ingresos?',9),(10,'Medical  Home','Do	you	have	a	usual	source	of	medical	care?','¿Tiene usted una fuente habitual de atención médica?',10),(11,'Insurance','Do	you	have	medical	insurance?','¿Tienes seguro médico?',11),(12,'Childcare','Does	getting	childcare	make	it	hard	for	you	to	work,	go	to	school	or	study?','¿Tener cuidado infantil le dificulta trabajar, ir a la escuela o estudiar?',12),(13,'Social	Support','Do	you	have	people	in	your	life	that	you	feel	supported	by?	','¿Tienes personas en tu vida por las que te sientes apoyado?',13),(14,'Prescription','Have	you	experienced	a	time	when	finances	got	in	the	way	of	being	able	to	cover	your	costs	for	your prescriptions?	','¿Ha experimentado algún momento en el que las finanzas le impidieron poder cubrir los costos de sus recetas?',14),(15,'Consent	to	Help','Would	you	like	to	receive	assistance	with	any	of	these needs?	','¿Le gustaría recibir ayuda con alguna de estas necesidades?',15),(16,'General','Are	any	of	your	needs	urgent?	For	example,	I	don’t	have food	tonight	or	I	don’t	have	a	place	to	sleep	tonight?','¿Alguna de tus necesidades es urgente? Por ejemplo, ¿no tengo comida esta noche o no tengo dónde dormir esta noche?',16);
/*!40000 ALTER TABLE `tbl_survey_questions` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-09-22 11:42:04
