Skip to content

Instantly share code, notes, and snippets.

@GurunadhPachappagari

GurunadhPachappagari/data_creation.sql

Created March 23, 2021 09:42
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save GurunadhPachappagari/824f2fd1ce0fbe81b5e0d82f61d47994 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save GurunadhPachappagari/824f2fd1ce0fbe81b5e0d82f61d47994 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
data_creation.sql
-- PATIENT TABLE FORMAT (id, name, address, contact_number, gender)
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801001', 'Captain Jack Sparrow', '1-1, Black Pearl Island, Atlantic Ocean', '2715144000', 'male');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801003', 'Elizabeth Swann', '34-(90/A) High Land, California', '9752762770', 'female');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801002', 'Gellert Grindelwald', '22-121, Maldives, Indian Ocean', '8558134440', 'male');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801004', 'Harry Potter', '4, Privet Drive, Little Whinging, Surrey', '7603341062', 'male');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801005', 'Ronald Weasley', 'The main, Tree house, Amazon Forest', '8132047892', 'male');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801006', 'Hermione Granger', '1755 Karen Lane, Shepherdsville, KY', '5789962996', 'female');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801007', 'Albus Dumbledore', '3166 Abia Martin Drive, New York, NY', '7524991112', 'male');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801029', 'Tom Riddle', '141 Stiles Street, Pittsburgh, PA', '5427563280', 'male');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801031', 'Sirius Black', 'Main Pyramid, Egypt Desert', '4088658157', 'male');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801034', 'Neville Longbottom', '1911 Brentwood Drive, Austin, TX', '7942396652', 'male');
INSERT INTO `Patient`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('111801045', 'Draco Malfoy', '2-68, LA, Vegan, Airport, Street', '3817196249', 'male');
-- Visitor Table (id, name, address, contact_number, gender)
INSERT INTO `Visitor`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('v111801001', 'Will Turner', '2-1, Black Pearl Island, Atlantic Ocean', '3715144000', 'male');
INSERT INTO `Visitor`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('v111801003', 'Hector', '35-(90/A) High Land, California', '8752762770', 'male');
INSERT INTO `Visitor`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('v111801002', 'James Norry', '23-121, Maldives, Indian Ocean', '9558134440', 'male');
INSERT INTO `Visitor`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('v111801004', 'Ragetti', '5, Privet Drive, Little Whinging, Surrey', '8603341062', 'male');
INSERT INTO `Visitor`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('v111801005', 'Ana Maria', 'The second main, Tree house, Amazon Forest', '9132047892', 'female');
INSERT INTO `Visitor`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('v111801006', 'Joshamee', '1756 Karen Lane, Shepherdsville, KY', '6789962996', 'female');
INSERT INTO `Visitor`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('v111801007', 'Marty', '3167 Abia Martin Drive, New York, NY', '8524991112', 'male');
INSERT INTO `Visitor`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('v111801008', 'Mull roy', '142 Stiles Street, Pittsburgh, PA', '6427563280', 'male');
INSERT INTO `Visitor`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('v111801009', 'Murtogg', 'Second Pyramid, Egypt Desert', '5088658157', 'male');
INSERT INTO `Visitor`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('v111801010', 'Lieutenant', '1912 Brentwood Drive, Austin, TX', '8942396652', 'male');
INSERT INTO `Visitor`(`id`, `name`, `address`,`contact_number`, `gender`) VALUES ('v111801011', 'Twigg', '2-69, LA, Vegan, Airport, Street', '4817196249', 'male');
-- visit (visitor_id, patient_id)
INSERT INTO `visit` (`visitor_id`, `patient_id`) VALUES ('v111801001', '111801001');
INSERT INTO `visit` (`visitor_id`, `patient_id`) VALUES ('v111801001', '111801002');
INSERT INTO `visit` (`visitor_id`, `patient_id`) VALUES ('v111801002', '111801001');
INSERT INTO `visit` (`visitor_id`, `patient_id`) VALUES ('v111801003', '111801003');
INSERT INTO `visit` (`visitor_id`, `patient_id`) VALUES ('v111801003', '111801004');
INSERT INTO `visit` (`visitor_id`, `patient_id`) VALUES ('v111801004', '111801003');
INSERT INTO `visit` (`visitor_id`, `patient_id`) VALUES ('v111801005', '111801005');
INSERT INTO `visit` (`visitor_id`, `patient_id`) VALUES ('v111801005', '111801006');
INSERT INTO `visit` (`visitor_id`, `patient_id`) VALUES ('v111801006', '111801005');
INSERT INTO `visit` (`visitor_id`, `patient_id`) VALUES ('v111801007', '111801029');
INSERT INTO `visit` (`visitor_id`, `patient_id`) VALUES ('v111801008', '111801031');
INSERT INTO `visit` (`visitor_id`, `patient_id`) VALUES ('v111801009', '111801034');
INSERT INTO `visit` (`visitor_id`, `patient_id`) VALUES ('v111801010', '111801045');
-- Appointment (id, patient_id, patient_name, date_and_time, reason)
INSERT INTO `Appointment` (`id`, `patient_id`, `patient_name`, `date_and_time`, `reason`) VALUES ('a111801001', '111801001', 'Captain Jack Sparrow', curdate(), 'Stomach Pain');
-- INSERT INTO `Appointment` (`id`, `patient_id`, `patient_name`, `date_and_time`, `reason`) VALUES ('a111801002', '111801001', 'Captain Jack Sparrow', curdate(), 'Head ache');
INSERT INTO `Appointment` (`id`, `patient_id`, `patient_name`, `date_and_time`, `reason`) VALUES ('a111801003', '111801002', 'Gellert Grindelwald', curdate(), 'Stomach Pain');
INSERT INTO `Appointment` (`id`, `patient_id`, `patient_name`, `date_and_time`, `reason`) VALUES ('a111801004', '111801003', 'Elizabeth Swann', curdate(), 'Head ache');
INSERT INTO `Appointment` (`id`, `patient_id`, `patient_name`, `date_and_time`, `reason`) VALUES ('a111801005', '111801004', 'Harry Potter', curdate(), 'Stomach Pain');
INSERT INTO `Appointment` (`id`, `patient_id`, `patient_name`, `date_and_time`, `reason`) VALUES ('a111801006', '111801005', 'Ronald Weasley', curdate(), 'Head ache');
INSERT INTO `Appointment` (`id`, `patient_id`, `patient_name`, `date_and_time`, `reason`) VALUES ('a111801007', '111801006', 'Hermione Granger', curdate(), 'Stomach Pain');
INSERT INTO `Appointment` (`id`, `patient_id`, `patient_name`, `date_and_time`, `reason`) VALUES ('a111801008', '111801007', 'Albus Dumbledore', curdate(), 'Head ache');
INSERT INTO `Appointment` (`id`, `patient_id`, `patient_name`, `date_and_time`, `reason`) VALUES ('a111801009', '111801029', 'Tom Riddle', curdate(), 'Stomach Pain');
INSERT INTO `Appointment` (`id`, `patient_id`, `patient_name`, `date_and_time`, `reason`) VALUES ('a111801010', '111801031', 'Sirius Black', curdate(), 'Head ache');
INSERT INTO `Appointment` (`id`, `patient_id`, `patient_name`, `date_and_time`, `reason`) VALUES ('a111801011', '111801034', 'Neville Longbottom', curdate(), 'Head ache');
INSERT INTO `Appointment` (`id`, `patient_id`, `patient_name`, `date_and_time`, `reason`) VALUES ('a111801012', '111801045', 'Draco Malfoy', curdate(), 'Head ache');
-- booking (patient_id, appointment_id)
INSERT INTO `booking` (`patient_id`, `appointment_id`) VALUES ('111801001', 'a111801001');
-- INSERT INTO `booking` (`patient_id`, `appointment_id`) VALUES ('111801001', 'a111801002');
INSERT INTO `booking` (`patient_id`, `appointment_id`) VALUES ('111801002', 'a111801003');
INSERT INTO `booking` (`patient_id`, `appointment_id`) VALUES ('111801003', 'a111801004');
INSERT INTO `booking` (`patient_id`, `appointment_id`) VALUES ('111801004', 'a111801005');
INSERT INTO `booking` (`patient_id`, `appointment_id`) VALUES ('111801005', 'a111801006');
INSERT INTO `booking` (`patient_id`, `appointment_id`) VALUES ('111801006', 'a111801007');
INSERT INTO `booking` (`patient_id`, `appointment_id`) VALUES ('111801007', 'a111801008');
INSERT INTO `booking` (`patient_id`, `appointment_id`) VALUES ('111801029', 'a111801009');
INSERT INTO `booking` (`patient_id`, `appointment_id`) VALUES ('111801031', 'a111801010');
INSERT INTO `booking` (`patient_id`, `appointment_id`) VALUES ('111801034', 'a111801011');
INSERT INTO `booking` (`patient_id`, `appointment_id`) VALUES ('111801045', 'a111801012');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment