-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Feb 26, 2021 at 03:17 PM
-- Server version: 10.5.8-MariaDB
-- PHP Version: 8.0.2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `media_klinik`
--

--
-- Dumping data for table `doctors`
--

INSERT INTO `doctors` (`id`, `user_id`, `polyclinic_id`, `name`, `email`, `phone_number`, `birth_place`, `birthday`, `type`, `gender`, `address`, `is_active`, `created_at`, `updated_at`) VALUES
('92b59149-d827-43cc-95fd-d1cfe43813a4', NULL, '93026126-5848-48d7-b31d-b712a17da25c', 'Nur Fitriani S', 'nrftrianis12@gmail.com', '087816973617', 'Makassar', '2001-12-12', 'Umum', 'Perempuan', 'Paccerakkang', 1, '2021-02-11 23:14:02', '2021-02-11 23:14:02');

--
-- Dumping data for table `patients`
--

INSERT INTO `patients` (`id`, `name`, `id_number`, `birth_place`, `birthday`, `email`, `phone_number`, `job`, `company_id`, `gender`, `province_id`, `regency_id`, `district_id`, `village_id`, `address`, `type`, `type_number`, `registration_password`, `medical_record_number`, `picture`, `is_active`, `created_at`, `updated_at`) VALUES
('92b590ed-6d60-46c6-bf4f-34523273f267', 'Abel Ardhana S', '7371110000000000', 'Makassar', '2002-05-05', 'abelardhana96@gmail.com', '087816970000', 'Developer', NULL, 'Laki-laki', NULL, NULL, NULL, NULL, 'Kima', 'Umum (Karyawan)', '', '050502', 'P000001', NULL, 1, '2021-02-11 23:13:02', '2021-02-12 01:27:53');

INSERT INTO `patients` (`id`, `user_id`, `name`, `id_number`, `birth_place`, `birthday`, `email`, `phone_number`, `job`, `company_id`, `gender`, `province_id`, `regency_id`, `district_id`, `village_id`, `address`, `type`, `type_number`, `registration_password`, `medical_record_number`, `picture`, `is_active`, `created_at`, `updated_at`) VALUES ('92fc59bd-d662-4f88-a435-7fde8bf1a0c2', NULL, 'Ann', '7371111987806345', 'Bandung', '1998-03-19', 'ann@fake.com', '0821343936457', 'Desainer', '92fc5386-51cd-42de-849b-b2d5fd088796', 'Perempuan', '32', '3204', '3204120', '3204120011', 'Jalan Baroncong No. 3', 'Umum (Karyawan)', NULL, '190398', 'P000002', NULL, '1', '2021-03-19 11:42:30', '2021-03-19 11:42:30');

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` (`id`, `name`, `email`, `contract`, `start_date`, `end_date`, `address`, `responsible_person`, `phone_number`, `category`, `billing_address`, `province_id`, `regency_id`, `district_id`, `village_id`, `logo`, `is_active`, `created_at`, `updated_at`) VALUES ('92d3e42d-72f9-490a-8f54-1a5524709d52', 'Umum (Masyarakat)', 'umum@email.fake', '--', '2020-01-01 00:00:00', '2100-01-01 00:00:00', 'Klinik', '--', '000000000000', 'Asuransi', '', '73', '7371', '7371111', '7371111003', NULL, '1', '2021-02-27 09:00:39', '2021-02-27 09:00:39');

INSERT INTO `companies` (`id`, `name`, `email`, `contract`, `start_date`, `end_date`, `address`, `responsible_person`, `phone_number`, `category`, `billing_address`, `province_id`, `regency_id`, `district_id`, `village_id`, `logo`, `is_active`, `created_at`, `updated_at`, `default_discount`) VALUES ('92fc5386-51cd-42de-849b-b2d5fd088796', 'Telkomsel', 'by.u@telkom.id', 'Maret S.d Mei 2021', '2021-03-01 00:00:00', '2021-05-31 00:00:00', 'Jalan Cibugur Sampai Cilandak', 'by.u', '082163214821', 'Swasta', '', '31', '3171', '3171030', '3171030003', NULL, '1', '2021-03-19 11:25:07', '2021-03-19 11:25:07', '20');

--
-- Dumping data for table `polyclinics`
--

INSERT INTO `polyclinics` (`id`, `code`, `name`, `created_at`, `updated_at`) VALUES ('93026126-5848-48d7-b31d-b712a17da25c', 'UM', 'Umum', '2021-03-22 11:38:11', '2021-03-22 11:38:11'), ('93026142-d22b-4415-8df9-c06e9fbb4e71', 'LAB', 'Laboratorium', '2021-03-22 11:38:29', '2021-03-22 11:38:29'), ('9302615f-45d1-4aef-bc69-0544390546c8', 'INT', 'Interna', '2021-03-22 11:38:48', '2021-03-22 11:38:48');

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 */;