-- phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Apr 27, 2019 at 09:48 PM -- Server version: 10.1.38-MariaDB -- PHP Version: 7.3.3 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `login` -- DELIMITER $$ -- -- Procedures -- CREATE DEFINER=`root`@`localhost` PROCEDURE `EmployeeSP_Delete` (INOUT `employee_id` INT) NO SQL DELETE from employees WHERE employees.employee_id=employee_id$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `EmployeeSP_Insert` (IN `employee_id` INT, IN `first_name` VARCHAR(60), IN `last_name` VARCHAR(60), IN `manager_id` INT) NO SQL INSERT into employees (employee_i,first_name, last_name,manager_id) VALUES (employee_i,first_name, last_name,manager_id)$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `EmployeeSP_Update` (INOUT `employee_id` INT, INOUT `last_name` VARCHAR(60)) NO SQL UPDATE employees SET last_name=last_name WHERE employees.employee_id=employee_id$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `ItemsSP_Delete` (INOUT `item_id` INT) NO SQL DELETE from items WHERE items.item_id=item_id$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `ItemsSP_Insert` (IN `item_id` INT, IN `title` VARCHAR(256), IN `unit_price` VARCHAR(60)) NO SQL INSERT into items (item_id,title,unit_price) VALUES (item_id,title,unit_price)$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `ItemsSP_Update` (INOUT `item_id` INT, INOUT `unit_price` VARCHAR(60)) NO SQL UPDATE items SET unit_price=unit_price WHERE items.item_id=item_id$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `OrdersSP_Delete` (INOUT `order_id` INT) NO SQL DELETE from orders WHERE orders.order_id=order_id$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `OrdersSP_Insert` (IN `order_id` INT, IN `user_id` INT, IN `order_date` DATE, IN `shipped_date` DATE, IN `employee_id` INT) NO SQL INSERT INTO orders (order_id,customer_id,order_date,shipped_date,employee_id) VALUES (order_id,customer_id,order_date,shipped_date,employee_id)$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `OrdersSP_Update` (INOUT `order_id` INT, INOUT `shipped_date` DATE) NO SQL UPDATE orders SET shipped_date=shipped_date WHERE orders.order_id=order_id$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `Order_detailsSP_Delete` (INOUT `item_id` INT, INOUT `order_id` INT) NO SQL DELETE from order_details WHERE order_details.order_id=order_id AND order_details.item_id=item_id$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `order_detailsSP_Insert` (IN `order_id` INT, IN `item_id` INT, IN `order_qty` INT) NO SQL INSERT into order_details (order_id,item_id,order_qty) VALUES (order_id,item_id,order_qty)$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `Order_detailsSP_Update` (INOUT `order_id` INT, INOUT `item_id` INT, INOUT `order_qty` INT) NO SQL UPDATE order_details SET order_qty=order_qty WHERE order_details.order_id=order_id$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `UsersSP_Delete` (INOUT `user_id` INT) NO SQL DELETE from users WHERE users.user_id=user_id$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `UsersSP_Insert` (IN `user_address` VARCHAR(60), IN `user_city` VARCHAR(20), IN `user_state` VARCHAR(2), IN `user_zip` VARCHAR(5), IN `user_phone` VARCHAR(10)) NO SQL INSERT into users (user_address,user_city,user_state,user_zip,user_phone) VALUES (user_address,user_city,user_state,user_zip,user_phone)$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `UsersSP_Update` (INOUT `user_id` INT, INOUT `user_phone` VARCHAR(60)) NO SQL UPDATE users SET user_phone=user_phone WHERE users.user_id=user_id$$ DELIMITER ; -- -------------------------------------------------------- -- -- Table structure for table `employees` -- CREATE TABLE `employees` ( `employee_id` int(11) NOT NULL, `last_name` varchar(20) DEFAULT NULL, `first_name` varchar(20) DEFAULT NULL, `manager_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `employees` -- INSERT INTO `employees` (`employee_id`, `last_name`, `first_name`, `manager_id`) VALUES (1, 'Smith', 'Cindy', NULL), (2, 'Jones', 'Elmer', 1), (3, 'Simonian', 'Ralph', 2), (4, 'Hernandez', 'Olivia', 9), (5, 'Aaronsen', 'Robert', 4), (6, 'Watson', 'Denise', 8), (7, 'Hardy', 'Thomas', 2), (8, 'Leary', 'Rhea', 9), (9, 'Locario', 'Paulo', 1); -- -------------------------------------------------------- -- -- Table structure for table `items` -- CREATE TABLE `items` ( `item_id` int(11) NOT NULL, `title` varchar(50) DEFAULT NULL, `unit_price` decimal(9,2) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `items` -- INSERT INTO `items` (`item_id`, `title`, `unit_price`) VALUES (1, 'Umami In Concert', '17.95'), (2, 'Race Car Sounds', '13.00'), (3, 'No Rest For The Weary', '16.95'), (4, 'More Songs About Structures and Comestibles', '17.95'), (5, 'On The Road With Burt Ruggles', '17.50'), (6, 'No Fixed Address', '16.95'), (7, 'Rude Noises', '13.00'), (8, 'Burt Ruggles: An Intimate Portrait', '17.95'), (9, 'Zone Out With Umami', '16.95'), (10, 'btcetera', '17.00'), (11, 'Amami In Concert', '17.95'), (12, 'Race Truck Sounds', '13.00'), (13, 'Always Rest For The Weary', '16.95'), (14, 'Songs About Structures', '17.95'), (15, 'Off Road With John Line', '17.50'), (16, 'No Fixed', '16.95'), (17, 'Noises', '13.00'), (18, 'Body Mind and Soul', '17.95'), (19, 'In The Zone', '16.95'), (20, 'Sweet Living', '17.00'); -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `order_id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `order_date` date DEFAULT NULL, `shipped_date` date DEFAULT NULL, `employee_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `orders` -- INSERT INTO `orders` (`order_id`, `user_id`, `order_date`, `shipped_date`, `employee_id`) VALUES (19, NULL, '2012-10-23', '2012-10-28', 6), (29, NULL, '2012-11-05', '2012-11-11', 6), (32, NULL, '2012-11-10', '2012-11-13', 2), (45, NULL, '2012-11-25', '2012-11-30', NULL), (70, NULL, '2012-12-28', '2013-01-07', 5), (89, NULL, '2013-01-20', '2013-01-22', 7), (97, NULL, '2013-01-29', '2013-02-02', 5), (118, NULL, '2013-02-24', '2013-02-28', 7), (144, NULL, '2013-03-21', '2013-03-29', 1), (158, NULL, '2013-04-04', '2013-04-20', 9), (165, NULL, '2013-04-11', '2013-04-13', 1), (180, NULL, '2013-04-25', '2013-05-30', NULL), (231, NULL, '2013-06-14', '2013-06-22', 9), (242, NULL, '2013-06-24', '2013-07-06', 3), (264, NULL, '2013-07-15', '2013-07-18', 6), (298, NULL, '2013-08-18', '2013-09-22', 3), (321, NULL, '2013-09-09', '2013-10-05', 6), (381, NULL, '2013-11-08', '2013-11-16', 7), (413, NULL, '2013-12-05', '2014-01-11', 7), (442, NULL, '2013-12-28', '2014-01-03', 5); -- -------------------------------------------------------- -- -- Table structure for table `order_details` -- CREATE TABLE `order_details` ( `order_id` int(11) NOT NULL, `item_id` int(11) NOT NULL, `order_qty` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `order_details` -- INSERT INTO `order_details` (`order_id`, `item_id`, `order_qty`) VALUES (19, 1, 1), (29, 9, 1), (32, 1, 1), (70, 9, 1), (89, 5, 1), (97, 1, 1), (118, 10, 1), (144, 3, 1), (158, 1, 1), (158, 3, 1), (180, 7, 1), (231, 10, 1), (242, 1, 1), (242, 7, 1), (264, 5, 1), (264, 10, 1), (298, 6, 1), (321, 6, 1), (381, 1, 2), (413, 6, 2); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `user_id` int(10) NOT NULL, `user_first` varchar(256) NOT NULL, `user_last` varchar(256) NOT NULL, `user_email` varchar(256) NOT NULL, `user_uid` varchar(256) NOT NULL, `user_pwd` varchar(256) NOT NULL, `user_address` varchar(265) NOT NULL, `user_city` varchar(265) NOT NULL, `user_state` varchar(265) NOT NULL, `user_zip` varchar(265) NOT NULL, `user_phone` varchar(265) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`user_id`, `user_first`, `user_last`, `user_email`, `user_uid`, `user_pwd`, `user_address`, `user_city`, `user_state`, `user_zip`, `user_phone`) VALUES (1, 'Agnes', 'Galimah', '[email protected]', 'Agalimah', '$2y$10$LPp4eCgZVm7gtI0WtlJnou20lhdKI/u/ugIomP.Qa2VpjQuynczmm', '60 Madison Ave', 'New York', 'NY', '10010', '2125554800'), (2, 'Vernesa', 'Scott', '[email protected]', 'VerGirl', '$2y$10$Xtwa9t.zAozoXYP/rZKyYuQjOnlXa7MZLk5C3xSRnPR/J8HOJSbFW', '11 E Rancho Madera Rd', 'Madison', 'WI', '53707', '2095551205'), (3, 'Akin', 'Ade', '[email protected]', 'AkinAde1', '$2y$10$PYADFI88seqigcHNcG3TnOU5SYnw49FcE5yUeBQM109JlDW31kJCS', '1555 W Lane Ave', 'Columbus', 'OH', '43221', '6145554435'), (4, 'Mikayla', 'Davis', '[email protected]', 'MDavis', '$2y$10$bM0Zb4ePI2Ar7AqLJM87YetMsRRn.WStoQsumveeW9z8/D51GoljG', '2021 K Street Nw', 'Washington', 'DC', '20006', '2025555561'), (5, 'Kendall', 'Mayte', '[email protected]', 'KMayte', '$2y$10$BlaVuMgpVerjKB0UXXsPxe0P7gf1Hzc3oKnpKZda76QARdppODyk6', '4775 E Miami River Rd', 'Cleves', 'OH', '45002', '5135553043'), (6, 'Kaitlin', 'Hostlery', '[email protected]', 'KHostlery', '$2y$10$dbGUhjQI7EHynkEPSpV5bOjyGGv6xVDzs7/OVrbpVp1hKrVVZA8dG', '3250 Spring Grove Ave', 'Cincinnati', 'OH', '45225', '8005551957'), (7, 'Derek', 'Chaddick', '[email protected]', 'DChaddick', '$2y$10$1QHdTgdwCKXom7xeYJlvBufbjpDZmmyF0wHLi49iTf5DzTSdrmWsq', '9022 E Merchant Wy', 'Fairfield', 'IA', '52556', '5155556130'), (8, 'Deborah', 'Davis', '[email protected]', 'DDavis', '$2y$10$Dv1MeN5EmqlIwM3bdJrJzOfTTGLsJs15yQR6JIsLszZnDyZSNRgi2', 'Davis\',\'415 E Olive Ave', 'Fresno', 'CA', '93728', '5595558060'), (9, 'Karina', 'Lacy', '[email protected]', 'KLacy', '$2y$10$aA1NZGzcyINQIhXFHTEVJu/K6jtmEjW5p0hZdaou2LvjfllLQBBrO', '882 W Easton Wy', 'Los Angeles', 'CA', '90084', '8005557000'), (10, 'Kurt', 'Nickalus', '[email protected]', 'KNickalus', '$2y$10$KOn9PlRL2BW4yQ8Kyc9Weu/OeZZbRYEN6y5fW63vSlS3KBseTLj6O', '28210 N Avenue Stanford', 'Valencia', 'CA', '91355', '8055550584'), (11, 'Kelsey', 'Eulalia', '[email protected]', 'KEulalia', '$2y$10$48c8Kwvfjur537y4.q9ObeuH1OpKjNX4dhFgd8f7nqHfbxL13Zayq', '7833 N Ridge Rd', 'Sacramento', 'CA', '95887', '2095557500'), (12, 'Anders', 'Rohansen', '[email protected]', 'ARohansen', '$2y$10$h6FwWfb4Bbl3YWBe0iJpMu3RE6JmcgVl3OssP8ujW/mhE9mM64RuS', '12345 E 67th Ave NW', 'Takoma Park', 'MD', '24512', '3385556772'), (13, 'Thalia', 'Neftaly', '[email protected]', 'TNeftaly', '$2y$10$P8XvDvdzfFFNA7pIkz6bCOs0xd5AXvaLI4kHj4Ulsj2.BqKfx2YJ2', '2508 W Shaw Ave', 'Fresno', 'CA', '93711', '5595556245'), (14, 'Gonzalo', 'Keeton', '[email protected]', 'GKeeton', '$2y$10$3rxP5CAejVGcEqbRNAGxl.HCXjyA0hHSCjfz/Dk7pt6Ddzt/rD69m', '12 Daniel Road', 'Fairfield', 'NJ', '07004', '2015559742'), (15, 'Ania', 'Irvin', '[email protected]', 'AIrvin', '$2y$10$9sc28u2VIdHhgu7T7KRzSO27PO5qXfOUUDBWS962KGPIeDm21GuCy', '1099 N Farcourt St', 'Orange', 'CA', '92807', '7145559000'), (16, 'Dakota', 'Baylee', '[email protected]', 'DBaylee', '$2y$10$HeCqr.y1HWQchTL1vrOU3eSitqmfW/iny8.mXU4oIqlTf4gF3Szz.', '1033 N Sycamore Ave.', 'Los Angeles', 'CA', '90038', '2135554322'), (17, 'Samuel', 'Jacobsen', '[email protected]', 'SJacobsen', '$2y$10$1VIr.y/gH9TWPEaoV20uTed7OLKxkTir8hxuNiEXb6Quk3k.zgCwS', '3433 E Widget Ave', 'Palo Alto', 'CA', '92711', '4155553434'), (18, 'Justin', 'Javen', '[email protected]', 'JJaven', '$2y$10$VVdKYQt.aI8/rZdxPxFcr.UNh4fN8YvGDQUwpfuE7nVmZQauzdDTq', '828 S Broadway', 'Tarrytown', 'NY', '10591', '8005550037'), (19, 'Kyle', 'Marissa', '[email protected]', 'KMarissa', '$2y$10$ImYfYDs9kqmr.hSG4ud2vOy/6/dChYOWge/57piUVVVV3ulL8AQZS', '789 E Mercy Ave', 'Phoenix', 'AZ', '85038', '9475553900'), (20, 'Erick', 'Kaleigh', '[email protected]', 'EKaleigh', '$2y$10$bYBStEgZspGL/zFJ0wmY/eWTgKzLhcbE1XEWcwi4guLlMgBXobnri', 'Five Lakepointe Plaza, Ste 500', 'Charlotte', 'NC', '28217', '7045553500'); -- -- Indexes for dumped tables -- -- -- Indexes for table `employees` -- ALTER TABLE `employees` ADD PRIMARY KEY (`employee_id`); -- -- Indexes for table `items` -- ALTER TABLE `items` ADD PRIMARY KEY (`item_id`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`order_id`), ADD KEY `user_id` (`user_id`) USING BTREE, ADD KEY `employee_id` (`employee_id`) USING BTREE; -- -- Indexes for table `order_details` -- ALTER TABLE `order_details` ADD PRIMARY KEY (`order_id`,`item_id`), ADD KEY `item_id_idx` (`item_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`user_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `user_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44; -- -- Constraints for dumped tables -- -- -- Constraints for table `orders` -- ALTER TABLE `orders` ADD CONSTRAINT `customer_id` FOREIGN KEY (`user_id`) REFERENCES `customers` (`customer_id`), ADD CONSTRAINT `employee_id` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`employee_id`); -- -- Constraints for table `order_details` -- ALTER TABLE `order_details` ADD CONSTRAINT `item_id` FOREIGN KEY (`item_id`) REFERENCES `items` (`item_id`), ADD CONSTRAINT `order_id` FOREIGN KEY (`order_id`) REFERENCES `orders` (`order_id`); COMMIT; /*!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 */;
SOAP NOTE SAMPLE FORMAT FOR MRC
Name: LP |
Date: |
Time: 1315 |
|
Age: 30 |
Sex: F |
SUBJECTIVE |
||
CC: “I am having vaginal itching and pain in my lower abdomen.”
|
||
HPI: Pt is a 30y/o AA female, who is a new patient that has recently moved to Miami. She seeks treatment today after unsuccessful self-treatment of vaginal itching, burning upon urination, and lower abdominal pain. She is concerned for the presence of a vaginal or bladder infection, or an STD. Pt denies fever. She reports the itching and burning with urination has been present for 3 weeks, and the abdominal pain has been intermittent since months ago. Pt has tried OTC products for the itching, including Monistat and Vagisil. She denies any other urinary symptoms, including urgency or frequency. She describes the abdominal pain as either sharp or dull. The pain level goes as high as 8 out of 10 at times. 200mg of PO Advil PRN reduces the pain to a 7/10. Pt denies any aggravating factors for the pain. Pt reports that she did start her menstrual cycle this morning, but denies any other discharge other that light bleeding beginning today. Pt denies douching or the use of any vaginal irritants. She reports that she is in a stable sexual relationship, and denies any new sexual partners in the last 90 days. She denies any recent or historic known exposure to STDs. She reports the use of condoms with every coital experience, as well as this being her only form of contraceptive. She reports normal monthly menstrual cycles that last 3-4 days. She reports dysmenorrhea, which she also takes Advil for. She reports her last PAP smear was in 7/2016, was normal, and reports never having an abnormal PAP smear result. Pt denies any hx of pregnancies. Other medical hx includes GERD. She reports that she has an Rx for Protonix, but she does not take it every day. Her family hx includes the presence of DM and HTN.
|
||
Current Medications: Protonix 40mg PO Daily for GERD MTV OTC PO Daily Advil 200mg OTC PO PRN for pain
|
||
PMHx: Allergies: NKA & NKDA Medication Intolerances: Denies Chronic Illnesses/Major traumas GERD Hospitalizations/Surgeries Denies
|
||
Family History Father- DM & HTN; Mother- HTN; Older sister- DM & HTN; Maternal and paternal grandparents without known medical issues; 1 brother and 3 other sisters without known medical issues; No children.
|
||
Social History Lives alone. Currently in a stable sexual relationship with one man. Works for DEFACS. Reports occasional alcohol use, but denies tobacco or illicit drug use.
|
||
ROS |
||
General Denies weight change, fatigue, fever, night sweats
|
Cardiovascular Denies chest pain and edema. Reports rare palpitations that are relieved by drinking water
|
|
Skin Denies any wounds, rashes, bruising, bleeding or skin discolorations, any changes in lesions
|
Respiratory Denies cough. Reports dyspnea that accompanies the rare palpitations and is also relieved by drinking water
|
|
Eyes Denies corrective lenses, blurring, visual changes of any kind
|
Gastrointestinal Abdominal pain (see HPI) and Hx of GERD. Denies N/V/D, constipation, appetite changes
|
|
Ears Denies Ear pain, hearing loss, ringing in ears
|
Genitourinary/Gynecological Reports burning with urination, but denies frequency or urgency. Contraceptive and STD prevention includes condoms with every coital event. Current stable sexual relationship with one man. Denies known historic or recent STD exposure. Last PAP was 7/2016 and normal. Regular monthly menstrual cycle lasting 3-4 days.
|
|
Nose/Mouth/Throat Denies sinus problems, dysphagia, nose bleeds or discharge
|
Musculoskeletal Denies back pain, joint swelling, stiffness or pain |
|
Breast Denies SBE |
Neurological Denies syncope, seizures, paralysis, weakness |
|
Heme/Lymph/Endo Denies bruising, night sweats, swollen glands |
Psychiatric Denies depression, anxiety, sleeping difficulties |
|
OBJECTIVE |
||
Weight 140lb |
Temp -97.7 |
BP 123/82 |
Height 5’4” |
Pulse 74 |
Respiration 18 |
General Appearance Healthy appearing adult female in no acute distress. Alert and oriented; answers questions appropriately. |
||
Skin Skin is normal color for ethnicity, warm, dry, clean and intact. No rashes or lesions noted. |
||
HEENT Head is norm cephalic, hair evenly distributed. Neck: Supple. Full ROM. Teeth are in good repair. |
||
Cardiovascular S1, S2 with regular rate and rhythm. No extra heart sounds. |
||
Respiratory Symmetric chest walls. Respirations regular and easy; lungs clear to auscultation bilaterally. |
||
Gastrointestinal Abdomen flat; BS active in all 4 quadrants. Abdomen soft, suprapubic tender. No hepatosplenomegaly. |
||
|
||
Genitourinary Suprapubic tenderness noted. Skin color normal for ethnicity. Irritation noted at labia majora, minora, and perineum. No ulcerated lesions noted. Lymph nodes not palpable. Vagina pink and moist without lesions. Discharge minimal, thick, dark red, no odor. Cervix pink without lesions. No CMT. Uterus normal size, shape, and consistency. |
||
Musculoskeletal Full ROM seen in all 4 extremities as patient moved about the exam room. |
||
Neurological Speech clear. Good tone. Posture erect. Balance stable; gait normal. |
||
Psychiatric Alert and oriented. Dressed in clean clothes. Maintains eye contact. Answers questions appropriately. |
||
Lab Tests Urinalysis – blood noted (pt. on menstrual period), but results negative for infection Urine culture testing unavailable Wet prep - inconclusive STD testing pending for gonorrhea, chlamydia, syphilis, HIV, HSV 1 & 2, Hep B & C
|
||
Special Tests- No ordered at this time.
|
||
Diagnosis |
||
Differential Diagnoses · 1-Bacterial Vaginosis (N76.0) · 2- Malignant neoplasm of female genital organ, unspecified. (C57.9) · 3-Gonococcal infection, unspecified. (A54.9) Diagnosis · Urinary tract infection, site not specified. (N39.0) Candidiasis of vulva and vagina. (B37.3) secondary to presenting symptoms (Colgan & Williams, 2011) & (Hainer & Gibson, 2011).
|
||
Plan/Therapeutics |
||
· Plan: · Medication – · Terconazole cream 1 vaginal application QHS for 7 days for Vulvovaginal Candidiasis; · Sulfamethoxazole/TMP DS 1 tablet PO twice daily for 3 days for UTI (Woo & Wynne, 2012) · Education – · Medications prescribed. · UTI and Candidiasis symptoms, causes, risks, treatment, prevention. Reasons to seek emergent care, including N/V, fever, or back pain. · STD risks and preventions. · Ulcer prevention, including taking Protonix as prescribed, not exceeding the recommended dose limit of NSAIDs, and not taking NSAIDs on an empty stomach. · Follow-up – · Pt will be contacted with results of STD studies. · Return to clinic when finished the period for perform pap-smear or if symptoms do not resolve with prescribed TX.
|
||
|
References
Colgan, R. & Williams, M. (2011). Diagnosis and Treatment of Acute Uncomplicated Cystitis. American Family Physician, 84(7), 771-776.
Hainer, B. & Gibson, M. (2011). Vaginitis: Diagnosis and Treatment. American Family Physician, 83(7), 807-815.
Woo, T. M., & Wynne, A. L. (2012). Pharmacotherapeutics for Nurse Practitioner Prescribers (3rd ed.). Philadelphia, PA: F.A. Davis Company.
1
DBM405A
Week 1
Order Management Database
This project is to manage customers and the orders they place online for a local company. The company’s employees are responsible to manage the order. The purpose of the project is to take orders online by the customers and maintain their information in the system. The system will also maintain the details of the current employees. Order information is maintained in the system that can be shipped to the customers. This allows the company to expand beyond just a store front and to keep a better track of customers’ information and what they order.
The system will maintain the information about the customers, orders, order details, items, and employee information. Employees will enter the information of Customers in the system or the customers themselves can do it online. The employee can then enter the information of the orders placed by these customers. The system will also keep a track of orders that are shipped and their details. The project will consist of 5 tables.
Week 2
Week 3
Week 4
See compressed file.
Week 5
For this week I had to establish a connection to the database from my programming language (HTML). For me to do so I pretty much had to start from scratch by renaming the database to login and adding an additional table call users. This table is what I use to store the data that was and will be enter by any user. I also use XAMPP, PHP with MySQL to help connect to the database as well. Below is a screenshot of the users table with a few data already stored in using the login system I created. Attach is also the HTML code to get to the login system.
Week 6
For this week I had to write programs that will allow me to add a record, change a record, and delete a record for each of the tables in my database. I did that by creating an insert, update and delete stored procedure for each of the tables in my database.
Below is a screenshot of all the procedures created with the naming convention specifying what each procedure is doing on which table.
Below I’ll post the statement for one of each type of procedures (being that it’s 15). I will only post one for insert, update and delete.
This is the INSERT SP
CREATE PROCEDURE `EmployeeSP_Insert`(IN `employee_id` INT, IN `first_name` VARCHAR(60), IN `last_name` VARCHAR(60), IN `manager_id` INT) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER INSERT into employees (employee_i,first_name, last_name,manager_id) VALUES (employee_i,first_name, last_name,manager_id);
This is the UPDATE SP
CREATE PROCEDURE `ItemsSP_Update`(INOUT `item_id` INT, INOUT `unit_price` VARCHAR(60)) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER UPDATE items SET unit_price=unit_price WHERE items.item_id=item_id;
This the DELETE SP
CREATE PROCEDURE `UsersSP_Delete`(INOUT `user_id` INT) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER DELETE from users WHERE users.user_id=user_id;
References
Generatedata.com. (2019, March). Retrieved March 24, 2019, from http://www.generatedata.com/
Mmtuts. (2017, June 20). Retrieved April 08, 2019, from https://www.youtube.com/watch?v=xb8aad4MRx8
Technology, H. C. (2017, October 07). Retrieved April 15, 2019, from https://www.youtube.com/watch?v=SPZJt3D5f4k
University, D. (2019, March). Re: Class Discussion [Web log comment]. Retrieved March, 2019.
Orders
Items
Employees
Order_details
Customers
order_id
PK
shipped_date
employee_id
FK
item_id
PK
title
attribute name
employee_id
PK
first_name
manger_id
order_id
PK
item_id
FK
order_qty
FK
customer_id
PK
customer_first_name
customer_last_name
customer_address
customer_city
customer_phone
customer_zip
customer_state
unit_price
last_name
customer_id
FK
order_date

Get help from top-rated tutors in any subject.
Efficiently complete your homework and academic assignments by getting help from the experts at homeworkarchive.com