-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Feb 02, 2026 at 11:26 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.1.17

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: `laravel_notedoctor`
--

-- --------------------------------------------------------

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `medical_notes`
--

CREATE TABLE `medical_notes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'completed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `medical_notes`
--

INSERT INTO `medical_notes` (`id`, `user_id`, `title`, `content`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'Chest Pain', '# Clinical Note\n\n## Patient Name: [Patient\'s Name]   \n## Date of Visit: [Date]\n\n---\n\n### 1. HPI (History of Present Illness)\nThe patient is a [age]-year-old [gender] presenting with a chronic history of chest pain, which began approximately 2 years ago. The patient describes the pain as dull in nature. The intensity of the pain was reported as -2 on a scale of 1 to 10, although this rating might indicate a potential misunderstanding or miscommunication regarding the scale. The pain has been noted to radiate to the arm and neck. No specific triggers or alleviating factors were identified, and no additional context on exacerbating circumstances was provided at this time.\n\n### 2. ROS (Review of Systems)\n- **Constitutional:** No fever, chills, or unexplained weight loss reported.\n- **Cardiovascular:** Positive for dull chest pain; reports radiation to arm and neck. Denies palpitations or syncope.\n- **Respiratory:** Denies shortness of breath, coughing, or wheezing.\n- **Gastrointestinal:** Denies nausea, vomiting, or indigestion.\n- **Musculoskeletal:** Denies joint or muscle pain apart from radiation of chest pain.\n- **Neurological:** Denies headaches, dizziness, or other neurological symptoms.\n- **Psychiatric:** No reports of anxiety or depression.\n\n### 3. Physical Examination\n- **Vital Signs:** \n  - Blood Pressure: [BP] mmHg \n  - Heart Rate: [HR] bpm\n  - Respiratory Rate: [RR] breaths/min\n  - Temperature: [Temp] °F\n  - Oxygen Saturation: [SpO2] % on room air\n\n- **General Appearance:** The patient appears well-nourished and in no acute distress.\n- **Cardiovascular:** Regular rhythm noted. No murmurs, rubs, or gallops. No jugular venous distention or peripheral edema.\n- **Respiratory:** Lungs clear to auscultation bilaterally without wheezes, rales, or rhonchi.\n- **Musculoskeletal:** No costochondral tenderness. No joint swelling or tenderness.\n- **Neurological:** Alert and oriented to person, place, and time. Cranial nerves II-XII intact.\n\n### 4. Assessment & Plan\n**Assessment:**\n- Chronic dull chest pain, radiating to arm and neck; differential diagnoses include chronic stable angina, gastroesophageal reflux disease (GERD), musculoskeletal pain, and anxiety-related chest discomfort. The atypical pain intensity rating necessitates clarification.\n\n**Plan:**\n1. Further evaluation for potential cardiovascular causes with an EKG and possible stress testing.\n2. Consider a referral to cardiology for further assessment if cardiovascular concerns persist.\n3. Consider GERD as a contributing factor and discuss lifestyle modifications and empirical trial of proton pump inhibitors.\n4. Recommend musculoskeletal assessment if postural or muscular etiologies are suspected.\n5. Educate patient regarding symptom monitoring, emphasizing potential red flags for urgent reassessment.\n6. Follow-up appointment in 4 weeks to assess progress and response to interventions.\n\n**Patient was advised to seek immediate care if experiencing acute or worsening symptoms, such as severe chest pain or shortness of breath.**\n\n--- \n\n*Documented by [Your Name], [Your Credentials]*  \n*Date: [Date of Documentation]*', 'completed', '2026-01-26 07:50:44', '2026-01-26 07:50:44'),
(2, 1, 'headache', '# Clinical Medical Note\n\n## Patient Information\n- **Name:** [Rehman]\n- **Date:** [Date of Encounter]\n- **Age:** [25]\n- **Gender:** Male\n\n---\n\n## 1. HPI (History of Present Illness)\nThe patient, a [age]-year-old [gender], presents with a complaint of headache primarily located at the front of the head and temples. The headache began 2 days ago and has persisted since onset. The patient denies any preceding trauma or identifiable triggers. No previous history of similar headaches is reported. Supportive measures attempted include over-the-counter analgesics, which provided minimal relief. The patient rates the pain as [pain intensity on a scale of 1-10]. There is no associated nausea, vomiting, or visual disturbances. The patient does not report photophobia or phonophobia.\n\n## 2. ROS (Review of Systems)\n- **Constitutional:** Denies fever, chills, or weight changes.\n- **HEENT:** Denies visual changes, dizziness, ear pain, or nasal congestion.\n- **Neurological:** Reports headache; denies vertigo, weakness, or paresthesia.\n- **Cardiovascular:** Denies chest pain or palpitations.\n- **Respiratory:** Denies cough or shortness of breath.\n- **Gastrointestinal:** Denies nausea or vomiting.\n- **Psychiatric:** Denies changes in mood or thought processes.\n\n## 3. Physical Examination\n- **Vital Signs:** [Include vital signs here, if available]\n- **General:** Alert and oriented x3; no acute distress.\n- **HEENT:** Normocephalic; extraocular movements intact; no sinus tenderness; oropharynx clear.\n- **Neck:** Supple, no lymphadenopathy or meningeal signs.\n- **Neurological:** Cranial nerves II-XII intact; motor and sensory exams grossly normal; reflexes 2+ bilaterally.\n- **Cardiovascular:** Regular rate and rhythm, no murmurs.\n- **Respiratory:** Clear to auscultation bilaterally.\n- **Gastrointestinal:** Soft, non-tender abdomen.\n\n## 4. Assessment & Plan\n### Assessment\nThe patient presents with a likely tension-type headache, considering the location, quality, and absence of alarming associated symptoms or a significant prior history of headaches.\n\n### Plan\n- **Headache Management:** Continue use of over-the-counter analgesics, such as acetaminophen or ibuprofen, as needed.\n- **Lifestyle Modifications:** Encourage adequate hydration, regular meals, and sleep hygiene.\n- **Follow-Up:** Advise the patient to return if the headache worsens, persists beyond a few days, or if new symptoms (such as neurological deficits or severe nausea/vomiting) develop.\n- **Further Investigation:** Consider imaging studies if symptoms do not resolve or neurological signs appear.\n\n---\n\n**Physician\'s Signature:** [Physician\'s Name and Credentials]  \n**Date:** [Date of Signature]', 'completed', '2026-01-26 07:56:31', '2026-01-26 07:56:31'),
(4, 11, 'Chest Pain', '**History of Present Illness**  \nThe patient presents with chest pain that began less than 1 hour ago following a fall while walking. The pain is described as dull and is intermittent in nature. The patient reports that repositioning alleviates the discomfort. There are no associated noticeable physical symptoms. The patient has experienced abnormal heart rhythms since the onset of the pain.\n\n**Review of Systems**  \n- Cardiovascular: Positive for abnormal heart rhythms.  \n- Respiratory: Wheezing present.  \n- Extremities: No swelling reported.  \n- General: Visible distress noted.  \n- Review of other systems not recorded.\n\n**Physical Exam**  \n- Heart Rate: 60-100 bpm.  \n- Respiratory Rate: 12-20 breaths/min.  \n- Lung Sounds: Wheezing present.  \n- Chest: Pain is reproducible upon palpation.  \n- Other aspects of the physical exam not performed/recorded.  \n\n**Medical Decision Making**  \nAn electrocardiogram (ECG) is indicated to further evaluate the abnormal heart rhythms and assess cardiac function. Hospital admission is not deemed necessary at this time. Further outpatient monitoring and management of symptoms will be required, with consideration for adjustments based on the ECG findings.', 'completed', '2026-02-02 02:20:19', '2026-02-02 02:20:19');

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_01_12_075305_add_role_to_users_table', 1),
(5, '2026_01_12_075305_create_transactions_table', 1),
(6, '2026_01_20_074508_create_packages_table', 1),
(7, '2026_01_20_074509_create_package_features_table', 1),
(8, '2026_01_20_075356_add_status_and_package_to_users_table', 1),
(9, '2026_01_20_081209_create_personal_access_tokens_table', 1),
(10, '2026_01_21_080639_create_medical_notes_table', 1),
(11, '2026_01_21_114207_create_subscriptions_table', 1),
(12, '2026_01_21_114323_remove_package_fields_from_users_table', 1),
(13, '2026_01_21_121018_add_status_to_users_table', 1),
(14, '2026_01_22_070812_add_stripe_fields_to_subscriptions_table', 1),
(15, '2026_01_22_071351_add_columns_to_transactions_table', 1),
(16, '2026_01_22_124207_add_paypal_fields_to_subscriptions_table', 1),
(17, '2026_01_22_140628_add_gateway_to_subscriptions_and_transactions', 1),
(18, '2026_01_26_082240_add_stripe_customer_id_to_users_table', 2);

-- --------------------------------------------------------

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `notes_limit` int(11) NOT NULL DEFAULT 0,
  `billing_cycle` varchar(255) NOT NULL DEFAULT 'one_time',
  `interval` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `name`, `description`, `price`, `notes_limit`, `billing_cycle`, `interval`, `created_at`, `updated_at`) VALUES
(1, 'test 1', 'test', 100.00, 50, 'recurring', 'monthly', '2026-01-26 03:04:34', '2026-01-29 10:11:07'),
(2, 'test 2', 'sds', 100.00, 100, 'recurring', 'monthly', '2026-01-26 04:54:03', '2026-01-29 10:10:53');

-- --------------------------------------------------------

--
-- Table structure for table `package_features`
--

CREATE TABLE `package_features` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `feature` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `package_features`
--

INSERT INTO `package_features` (`id`, `package_id`, `feature`, `created_at`, `updated_at`) VALUES
(5, 2, '100 notes', '2026-01-29 10:11:00', '2026-01-29 10:11:00'),
(6, 1, '50 Notes', '2026-01-29 10:11:07', '2026-01-29 10:11:07');

-- --------------------------------------------------------

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_reset_tokens`
--

INSERT INTO `password_reset_tokens` (`email`, `token`, `created_at`) VALUES
('rehmanahmad101@gmail.com', '$2y$12$UiadnWsKNFyPzq28m9cMluYzECoSqJZJqdCfKLuW5b9vjOmFpAzS6', '2026-01-29 11:27:55');

-- --------------------------------------------------------

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` text NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--

INSERT INTO `personal_access_tokens` (`id`, `tokenable_type`, `tokenable_id`, `name`, `token`, `abilities`, `last_used_at`, `expires_at`, `created_at`, `updated_at`) VALUES
(1, 'App\\Models\\User', 1, 'auth_token', '8de9c5e8d046cc3d1f4eb949c0a71abb7189388d69a29b6ef0546c1be571f2a2', '[\"*\"]', '2026-01-26 08:14:47', NULL, '2026-01-26 02:58:45', '2026-01-26 08:14:47'),
(2, 'App\\Models\\User', 3, 'auth_token', 'e2a28e2bab3f52f96ad0b63c92e8527649f67d3c9931603a035f2ac3183fa0cb', '[\"*\"]', '2026-01-29 10:04:07', NULL, '2026-01-29 10:01:02', '2026-01-29 10:04:07'),
(3, 'App\\Models\\User', 6, 'auth_token', 'd6f12a1608d2121e45daf7aac7672939700bbea1d87303cd31077ebeefe3bcd9', '[\"*\"]', '2026-01-29 10:09:42', NULL, '2026-01-29 10:08:46', '2026-01-29 10:09:42'),
(6, 'App\\Models\\User', 9, 'auth_token', '91cc1defb72cc01937497523506f54c19170a0b3a62160f625e1170be99dc3e4', '[\"*\"]', '2026-01-29 10:21:34', NULL, '2026-01-29 10:19:47', '2026-01-29 10:21:34'),
(12, 'App\\Models\\User', 11, 'auth_token', '5ab2c78e6a46342650580bea4dbe07924684101a0630b460525735480ac55c3c', '[\"*\"]', '2026-01-29 11:28:22', NULL, '2026-01-29 11:28:22', '2026-01-29 11:28:22'),
(13, 'App\\Models\\User', 11, 'auth_token', '82162756df6593ebb682c793a84aa0b2d95fe7dfcee4dc1456cc4bd3531c884c', '[\"*\"]', '2026-02-02 02:26:50', NULL, '2026-01-30 05:42:51', '2026-02-02 02:26:50');

-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('LBuQjHaw1tfLgzu0O9DJmHVXjHErdxPVCrLbX8OQ', 1, '119.73.101.218', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiODdQekRlVmVQamlDREE1WmxoWHo3VXp1SFhMM2hQdDk2d3g1dEtmVyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NTY6Imh0dHBzOi8vZGV2MS5icm93bnRlY2guY28vTm90ZURvY3RvcnMvcHVibGljL2FkbWluL3VzZXJzIjtzOjU6InJvdXRlIjtzOjE3OiJhZG1pbi51c2Vycy5pbmRleCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1769686904),
('MDW39ID1UVOtUhHKpQxV3voN7QgTT7EcgDLeN8TF', NULL, '119.73.101.218', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSDRmOGYxanNTdzYxeHM0dDNpVUpIQ2pNYzFPZlF4QzlzS05WYm5GQiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NTA6Imh0dHBzOi8vZGV2MS5icm93bnRlY2guY28vTm90ZURvY3RvcnMvcHVibGljL2xvZ2luIjtzOjU6InJvdXRlIjtzOjU6ImxvZ2luIjt9fQ==', 1769683970),
('uIGQu8il6WS5y6M7Dw6O5NDt9pFclq30tUr6LoEJ', NULL, '103.217.179.199', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTDlrWnQyMmRvRUZEQU1Hb2dDMzF0SjhaVlV3QldldXMzRkVuNzdkTiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NTA6Imh0dHBzOi8vZGV2MS5icm93bnRlY2guY28vTm90ZURvY3RvcnMvcHVibGljL2xvZ2luIjtzOjU6InJvdXRlIjtzOjU6ImxvZ2luIjt9fQ==', 1769682136),
('yHTH6zvCOk2Wuambd3a2AOKdt0TD4ikt5Pd0aw7Q', NULL, '119.73.101.218', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVm5jUTZNTGJQcHFURmVNeFVRTHBsanNQSDFEemZudzFjS1hqaU5iTiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDk6Imh0dHA6Ly9kZXYxLmJyb3dudGVjaC5jby9Ob3RlRG9jdG9ycy9wdWJsaWMvbG9naW4iO3M6NToicm91dGUiO3M6NToibG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1769683018);

-- --------------------------------------------------------

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `gateway` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `stripe_payment_method_id` varchar(255) DEFAULT NULL,
  `paypal_customer_id` varchar(255) DEFAULT NULL,
  `paypal_payment_method_id` varchar(255) DEFAULT NULL,
  `stripe_customer_id` varchar(255) DEFAULT NULL,
  `stripe_subscription_id` varchar(255) DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `user_id`, `package_id`, `gateway`, `status`, `stripe_payment_method_id`, `paypal_customer_id`, `paypal_payment_method_id`, `stripe_customer_id`, `stripe_subscription_id`, `expires_at`, `created_at`, `updated_at`) VALUES
(4, 3, 1, 'stripe', 'active', 'pm_1Sus50BAYZzzNl2895kl0BDo', NULL, NULL, 'cus_TsdLVvpj1lyq5S', NULL, '2026-03-01 10:04:07', '2026-01-29 10:04:07', '2026-01-29 10:04:07'),
(8, 9, 2, 'stripe', 'active', 'pm_1SusLoBAYZzzNl28dTW2LnrM', NULL, NULL, 'cus_TsdcH6vkrxoI4d', NULL, '2026-03-01 10:21:30', '2026-01-29 10:19:47', '2026-01-29 10:21:30'),
(9, 11, 1, 'stripe', 'active', NULL, NULL, NULL, NULL, NULL, '2026-03-01 11:24:44', '2026-01-29 11:24:44', '2026-01-29 11:24:44');

-- --------------------------------------------------------

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED DEFAULT NULL,
  `gateway` varchar(255) DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `currency` varchar(255) NOT NULL DEFAULT 'usd',
  `type` varchar(255) NOT NULL DEFAULT 'charge',
  `status` varchar(255) NOT NULL DEFAULT 'completed',
  `stripe_payment_id` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `user_id`, `package_id`, `gateway`, `amount`, `currency`, `type`, `status`, `stripe_payment_id`, `description`, `created_at`, `updated_at`) VALUES
(1, 2, NULL, NULL, 99.99, 'usd', 'charge', 'completed', NULL, 'Monthly Subscription', '2026-01-23 08:07:05', '2026-01-23 08:07:05'),
(2, 2, NULL, NULL, 19.99, 'usd', 'charge', 'pending', NULL, 'Add-on Service', '2026-01-23 08:07:05', '2026-01-23 08:07:05'),
(3, 1, 1, 'stripe', 100.00, 'usd', 'payment', 'completed', 'pi_3StknIBAYZzzNl280QDtLwor', NULL, '2026-01-26 03:05:13', '2026-01-26 03:05:13'),
(4, 1, 1, 'stripe', 100.00, 'usd', 'payment', 'failed', NULL, 'The provided PaymentMethod cannot be attached. To reuse a PaymentMethod, you must attach it to a Customer first.', '2026-01-26 03:14:01', '2026-01-26 03:14:01'),
(5, 1, 1, 'stripe', 100.00, 'usd', 'payment', 'failed', NULL, 'The provided PaymentMethod cannot be attached. To reuse a PaymentMethod, you must attach it to a Customer first.', '2026-01-26 03:16:35', '2026-01-26 03:16:35'),
(6, 1, 1, 'stripe', 100.00, 'usd', 'payment', 'completed', 'pi_3StlBcBAYZzzNl280rXmGk1W', NULL, '2026-01-26 03:30:22', '2026-01-26 03:30:22'),
(7, 1, 1, 'stripe', 100.00, 'usd', 'payment', 'completed', 'pi_3StlEABAYZzzNl2801IvY6tE', 'Automatic renewal (Stripe) successful', '2026-01-26 03:32:54', '2026-01-26 03:32:54'),
(8, 1, 2, 'paypal', 50.00, 'USD', 'payment', 'completed', '8CN82457GG3661634', 'PayPal payment (Vault ID: 2nt15002v2314652b)', '2026-01-26 05:10:44', '2026-01-26 05:10:44'),
(9, 1, 2, 'paypal', 50.00, 'usd', 'payment', 'failed', NULL, 'PayPal renewal failed', '2026-01-26 05:11:10', '2026-01-26 05:11:10'),
(10, 1, 2, 'paypal', 50.00, 'usd', 'payment', 'failed', NULL, 'PayPal renewal failed', '2026-01-26 05:12:10', '2026-01-26 05:12:10'),
(11, 1, 2, 'paypal', 50.00, 'usd', 'payment', 'failed', NULL, 'PayPal renewal failed', '2026-01-26 05:12:40', '2026-01-26 05:12:40'),
(12, 1, 2, 'paypal', 50.00, 'usd', 'payment', 'completed', '2921929364563922L', 'Automatic renewal (PayPal) successful', '2026-01-26 05:22:19', '2026-01-26 05:22:19'),
(13, 1, 2, 'stripe', 50.00, 'usd', 'payment', 'completed', 'pi_3Stp6lBAYZzzNl281dYF2NdS', NULL, '2026-01-26 07:41:52', '2026-01-26 07:41:52'),
(14, 3, 1, 'stripe', 100.00, 'usd', 'payment', 'completed', 'pi_3Sus50BAYZzzNl2807ZmHixo', NULL, '2026-01-29 10:04:07', '2026-01-29 10:04:07'),
(15, 9, 2, 'stripe', 100.00, 'usd', 'payment', 'completed', 'pi_3SusLqBAYZzzNl281F1Xoj94', NULL, '2026-01-29 10:21:30', '2026-01-29 10:21:30');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `stripe_customer_id` varchar(255) DEFAULT NULL,
  `role` varchar(255) NOT NULL DEFAULT 'user',
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `phone` varchar(255) DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `profile_photo_path` varchar(2048) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `stripe_customer_id`, `role`, `status`, `phone`, `email_verified_at`, `password`, `profile_photo_path`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Admin User', 'admin@admin.com', 'cus_TrU9n2RlMTzCSD', 'admin', 'active', NULL, NULL, '$2y$12$QKlrgN/Dpc2QYUnAavxNxe9huw7y0YXGY8ajpbiJSYbm/jgHpvwjW', NULL, 'ScDE79f13dknPikZmBxZs5fwPo8TUJcsyrNQS2bJgsAQWZSS1eFeYbgrJgHe', '2026-01-23 08:07:04', '2026-01-26 03:30:06'),
(2, 'John Doe', 'john@example.com', NULL, 'user', 'active', NULL, NULL, '$2y$12$q7p6s887rV/Hii5a8YcHFu9bpU4F8Bl19C2kvabQjlma0yCoCNBX6', NULL, NULL, '2026-01-23 08:07:05', '2026-01-23 08:07:05'),
(3, 'TYLER VERWORN', 'notedoctors@gmail.com', 'cus_TsdLVvpj1lyq5S', 'user', 'active', NULL, NULL, '$2y$12$s756b6zN7Z1Is/qSR3g6SeR/xRXtDN4aCFnbCKhQ8HQA.DtQiyWOy', NULL, NULL, '2026-01-29 10:01:02', '2026-01-29 10:03:47'),
(4, 'TYLER VERWORN', 'nordicwoodsassistedliving@gmail.com', NULL, 'user', 'active', NULL, NULL, '$2y$12$zYGD/3/CYTlV180B3i7T9eusUl.XhVAmDrPKckIgPV.UQSfhswGj6', NULL, NULL, '2026-01-29 10:01:02', '2026-01-29 10:01:02'),
(5, 'TYLER VERWORN', 'tylerverworn@gmail.com', NULL, 'user', 'active', NULL, NULL, '$2y$12$WBxyXbcukbwdJ64JpsI8KevHju9BSxcPT7ODSoOl1Oga.yafUMQjC', NULL, NULL, '2026-01-29 10:01:02', '2026-01-29 10:01:02'),
(6, 'madiha rani', 'madiharani448@gmail.com', NULL, 'user', 'active', NULL, NULL, '$2y$12$H.DHO658vn/Y4DNQS7MLHOmKWEXtbvCBdC192wmj8uXebx/2NC1.C', NULL, NULL, '2026-01-29 10:08:46', '2026-01-29 10:08:46'),
(7, 'test Test', 'test@gmail.com', NULL, 'user', 'active', NULL, NULL, '$2y$12$fdzPg5JGKKDXKJgfrET2BONufaSLXDTOlpN8pga5VAlc76KGwBbj6', NULL, NULL, '2026-01-29 10:11:45', '2026-01-29 10:12:14'),
(9, 'test test', 'test3@GMAIL.com', 'cus_TsdcH6vkrxoI4d', 'user', 'active', NULL, NULL, '$2y$12$Vd.qHV27Hv2kMwt12JpOZ.ad85vDk9rOJ6IDrpXLWJtz1DIEIJ6nm', NULL, NULL, '2026-01-29 10:19:47', '2026-01-29 10:21:13'),
(10, 'testing', 'bevepeb195@coswz.com', NULL, 'user', 'active', NULL, NULL, '$2y$12$G/zD2lSZ9sQhv5ugKOJn6ui9ADSOaxfbzbdd/0UoDBUXxbD2W8Wmu', NULL, NULL, '2026-01-29 10:28:14', '2026-01-29 10:28:14'),
(11, 'Rehman Ahmad', 'rehmanahmad101@gmail.com', NULL, 'user', 'active', NULL, NULL, '$2y$12$U.wivkHx3NRk9FBq9hzJi..sWcOGGHBRwj8mCxJRJaAIOb.Sd4S.O', NULL, NULL, '2026-01-29 11:24:43', '2026-01-29 11:24:43');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `medical_notes`
--
ALTER TABLE `medical_notes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `medical_notes_user_id_foreign` (`user_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `package_features`
--
ALTER TABLE `package_features`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_features_package_id_foreign` (`package_id`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`),
  ADD KEY `personal_access_tokens_expires_at_index` (`expires_at`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subscriptions_user_id_foreign` (`user_id`),
  ADD KEY `subscriptions_package_id_foreign` (`package_id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transactions_user_id_foreign` (`user_id`),
  ADD KEY `transactions_package_id_foreign` (`package_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `medical_notes`
--
ALTER TABLE `medical_notes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `package_features`
--
ALTER TABLE `package_features`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `subscriptions`
--
ALTER TABLE `subscriptions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `medical_notes`
--
ALTER TABLE `medical_notes`
  ADD CONSTRAINT `medical_notes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_features`
--
ALTER TABLE `package_features`
  ADD CONSTRAINT `package_features_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD CONSTRAINT `subscriptions_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `subscriptions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
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 */;