DinaAyuAisyah
/
Reservasi-Cafe
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Reservasi-Cafe/dindin-reserv(1).sql

804 lines
28 KiB
SQL
Raw Permalink Blame History

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 30, 2025 at 05:55 AM
-- Server version: 8.0.30
-- PHP Version: 8.1.10
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: `dindin-reserv`
--
-- --------------------------------------------------------
--
-- Table structure for table `cache`
--
CREATE TABLE `cache` (
`key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
`expiration` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `cache_locks`
--
CREATE TABLE `cache_locks` (
`key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`expiration` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `carousel_images`
--
CREATE TABLE `carousel_images` (
`id` bigint UNSIGNED NOT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `carts`
--
CREATE TABLE `carts` (
`id` bigint UNSIGNED NOT NULL,
`user_id` bigint UNSIGNED NOT NULL,
`menu_id` bigint UNSIGNED NOT NULL,
`quantity` int NOT NULL,
`price` decimal(10,2) NOT NULL,
`subtotal` decimal(10,2) NOT NULL,
`notes` varchar(255) COLLATE utf8mb4_unicode_ci 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 `carts`
--
INSERT INTO `carts` (`id`, `user_id`, `menu_id`, `quantity`, `price`, `subtotal`, `notes`, `created_at`, `updated_at`) VALUES
(4, 3, 1, 1, '22000.00', '22000.00', NULL, '2025-05-29 22:44:30', '2025-05-29 22:44:30');
-- --------------------------------------------------------
--
-- Table structure for table `failed_jobs`
--
CREATE TABLE `failed_jobs` (
`id` bigint UNSIGNED NOT NULL,
`uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `gallery_categories`
--
CREATE TABLE `gallery_categories` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci 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 `gallery_categories`
--
INSERT INTO `gallery_categories` (`id`, `name`, `description`, `thumbnail`, `created_at`, `updated_at`) VALUES
(1, 'Indoor Cafe', 'Nikmati suasana nyaman di dalam ruangan kami yang modern dan elegan.', 'gallery/thumbnails/hoDlR1jaJcycgJn7f1UjZrGZV5dNlIxyCmhv3wio.jpg', '2025-05-25 08:13:31', '2025-05-25 08:14:54'),
(2, 'VIP Indoor', 'Ruangan VIP eksklusif untuk acara privat dan pertemuan khusus.', 'images/vip indoor.jpeg', '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(3, 'Outdoor Cafe', 'Rasakan kesegaran udara terbuka di area outdoor kami yang asri.', 'images/outdoor cafe.jpeg', '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(4, 'VIP Outdoor', 'Area VIP outdoor yang sempurna untuk acara spesial Anda.', 'images/vip outdoor.jpeg', '2025-05-25 08:13:31', '2025-05-25 08:13:31');
-- --------------------------------------------------------
--
-- Table structure for table `gallery_images`
--
CREATE TABLE `gallery_images` (
`id` bigint UNSIGNED NOT NULL,
`category_id` bigint UNSIGNED NOT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`caption` varchar(255) COLLATE utf8mb4_unicode_ci 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 `gallery_images`
--
INSERT INTO `gallery_images` (`id`, `category_id`, `image`, `caption`, `created_at`, `updated_at`) VALUES
(1, 1, 'gallery/images/MumGQbIFKRNtxHFlCt8lBnJokW83itDlN6xF4M7J.jpg', NULL, '2025-05-25 08:14:12', '2025-05-25 08:14:12'),
(2, 1, 'gallery/images/TwEK3TWc7dXxT5qh520l2JotQa315vNv7EyOsBpS.jpg', NULL, '2025-05-25 08:14:38', '2025-05-25 08:14:38');
-- --------------------------------------------------------
--
-- Table structure for table `jobs`
--
CREATE TABLE `jobs` (
`id` bigint UNSIGNED NOT NULL,
`queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`attempts` tinyint UNSIGNED NOT NULL,
`reserved_at` int UNSIGNED DEFAULT NULL,
`available_at` int UNSIGNED NOT NULL,
`created_at` int 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) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`total_jobs` int NOT NULL,
`pending_jobs` int NOT NULL,
`failed_jobs` int NOT NULL,
`failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`options` mediumtext COLLATE utf8mb4_unicode_ci,
`cancelled_at` int DEFAULT NULL,
`created_at` int NOT NULL,
`finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `kritik_saran`
--
CREATE TABLE `kritik_saran` (
`id` bigint UNSIGNED NOT NULL,
`user_id` bigint UNSIGNED DEFAULT NULL,
`nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`jenis` enum('kritik','saran') COLLATE utf8mb4_unicode_ci NOT NULL,
`pesan` text COLLATE utf8mb4_unicode_ci 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 `kritik_saran`
--
INSERT INTO `kritik_saran` (`id`, `user_id`, `nama`, `email`, `jenis`, `pesan`, `created_at`, `updated_at`) VALUES
(1, 1, 'Budi Santoso', 'budi@example.com', 'kritik', 'Pelayanan sudah baik, tapi waktu tunggu makanan masih terlalu lama.', '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(2, NULL, 'Siti Rahayu', 'siti@example.com', 'saran', 'Mohon tambahkan menu vegetarian untuk pengunjung yang tidak makan daging.', '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(3, 2, 'Ahmad Hidayat', 'ahmad@example.com', 'kritik', 'AC di ruangan VIP kurang dingin, mohon untuk diperhatikan.', '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(4, NULL, 'Linda Wijaya', 'linda@example.com', 'saran', 'Sebaiknya ditambahkan live music untuk suasana makan yang lebih menyenangkan.', '2025-05-25 08:13:31', '2025-05-25 08:13:31');
-- --------------------------------------------------------
--
-- Table structure for table `meja`
--
CREATE TABLE `meja` (
`id` bigint UNSIGNED NOT NULL,
`nomor_meja` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`kapasitas` int NOT NULL,
`status` enum('tersedia','dipesan','terisi') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'tersedia',
`kategori` enum('outdoor','vip-outdoor','vip-indoor') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'outdoor',
`deskripsi` text COLLATE utf8mb4_unicode_ci,
`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 `meja`
--
INSERT INTO `meja` (`id`, `nomor_meja`, `kapasitas`, `status`, `kategori`, `deskripsi`, `created_at`, `updated_at`) VALUES
(1, '001', 4, 'tersedia', 'outdoor', 'Meja outdoor untuk 4 orang', '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(2, '002', 2, 'dipesan', 'outdoor', 'Meja outdoor untuk 2 orang', '2025-05-25 08:13:31', '2025-05-29 22:38:37'),
(3, '003', 6, 'tersedia', 'vip-outdoor', 'Meja VIP outdoor untuk 6 orang', '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(4, '004', 4, 'tersedia', 'vip-indoor', 'Meja VIP indoor untuk 4 orang', '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(5, '005', 8, 'tersedia', 'vip-indoor', 'Meja VIP indoor untuk 8 orang', '2025-05-25 08:13:31', '2025-05-25 08:13:31');
-- --------------------------------------------------------
--
-- Table structure for table `menu_categories`
--
CREATE TABLE `menu_categories` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci 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 `menu_categories`
--
INSERT INTO `menu_categories` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Food', '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(2, 'Drink', '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(3, 'Snack', '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(4, 'Makanan', '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(5, 'Minuman', '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(6, 'Cemilan', '2025-05-25 08:13:31', '2025-05-25 08:13:31');
-- --------------------------------------------------------
--
-- Table structure for table `menu_items`
--
CREATE TABLE `menu_items` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci,
`price` decimal(10,2) NOT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`category_id` bigint UNSIGNED NOT NULL,
`is_available` tinyint(1) NOT NULL DEFAULT '1',
`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 `menu_items`
--
INSERT INTO `menu_items` (`id`, `name`, `description`, `price`, `image`, `category_id`, `is_available`, `created_at`, `updated_at`) VALUES
(1, 'Nasi Goreng Special', 'Nasi goreng dengan telur, ayam, dan sayuran segar', '22000.00', '/images/Nasi Goreng.jpg', 1, 1, '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(2, 'Ayam Geprek', 'Ayam crispy geprek dengan sambal pedas', '18000.00', '/images/Ayam Geprek.jpg', 1, 1, '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(3, 'Mie Goreng', 'Mie goreng dengan perpaduan rasa yang manis', '18000.00', '/images/Mie Goreng.jpg', 1, 1, '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(4, 'Spaghetti', 'Spaghetti dengan campuran saus bolognese dan daging sapi', '25000.00', '/images/Spaghetti.jpg', 1, 1, '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(5, 'Lemon Tea', 'Es teh dengan perpaduan lemon yang segar', '12000.00', '/images/Lemon Tea.jpg', 2, 1, '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(6, 'Kopi Susu', 'Kopi dengan campuran susu yang nikmat', '12000.00', '/images/Kopi Susu.jpg', 2, 1, '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(7, 'Es Jeruk', 'Es jeruk dengan perasan jeruk yang segar', '8000.00', '/images/Es Jeruk.jpg', 2, 1, '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(8, 'Es Cincau', 'Es cincau dengan campuran cincau dan sirup', '10000.00', '/images/Es Cincau.jpg', 2, 1, '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(9, 'Kentang Goreng', 'Kentang goreng crispy dengan saus special', '15000.00', '/images/Kentang Goreng.jpg', 3, 1, '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(10, 'Roti Bakar', 'Roti bakar dengan tambahan selai coklat, strawberry, dan blueberry', '12000.00', '/images/Roti Bakar.jpg', 3, 1, '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(11, 'Mix Platter', 'Snack dengan isian nugget, sosis, dan kentang', '18000.00', '/images/Mix Platter.jpg', 3, 1, '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(12, 'Churros', 'Churros dengan tambahan selai coklat, matcha, dan taro', '15000.00', '/images/Churros.jpg', 3, 1, '2025-05-25 08:13:31', '2025-05-25 08:13:31');
-- --------------------------------------------------------
--
-- Table structure for table `migrations`
--
CREATE TABLE `migrations` (
`id` int UNSIGNED NOT NULL,
`migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int 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_000002_create_jobs_table', 1),
(3, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(4, '2024_02_22_000001_create_menu_categories_table', 1),
(5, '2024_02_22_000002_create_menu_items_table', 1),
(6, '2024_02_23_000001_create_meja_table', 1),
(7, '2024_02_24_000001_create_reservasi_table', 1),
(8, '2024_02_25_000001_create_transaksi_table', 1),
(9, '2024_02_25_000002_create_transaksi_items_table', 1),
(10, '2024_03_14_create_kritik_saran_table', 1),
(11, '2024_03_20_000001_create_carousel_images_table', 1),
(12, '2024_03_20_add_phone_to_users_table', 1),
(13, '2024_03_21_000001_create_gallery_categories_table', 1),
(14, '2024_03_21_000002_create_gallery_images_table', 1),
(15, '2025_01_23_050839_create_cache_table', 1),
(16, '2025_02_23_120540_create_carts_table', 1),
(17, '2025_03_19_000553_add_role_to_users_table', 1);
-- --------------------------------------------------------
--
-- Table structure for table `password_reset_tokens`
--
CREATE TABLE `password_reset_tokens` (
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `personal_access_tokens`
--
CREATE TABLE `personal_access_tokens` (
`id` bigint UNSIGNED NOT NULL,
`tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`tokenable_id` bigint UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`abilities` text COLLATE utf8mb4_unicode_ci,
`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;
-- --------------------------------------------------------
--
-- Table structure for table `reservasi`
--
CREATE TABLE `reservasi` (
`id` bigint UNSIGNED NOT NULL,
`user_id` bigint UNSIGNED NOT NULL,
`meja_id` bigint UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`date` date NOT NULL,
`start_time` time NOT NULL,
`end_time` time NOT NULL,
`total_harga` decimal(10,2) NOT NULL DEFAULT '0.00',
`payment_method` enum('cash','transfer','qris') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` enum('pending','confirmed','completed','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
`notes` text COLLATE utf8mb4_unicode_ci,
`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 `reservasi`
--
INSERT INTO `reservasi` (`id`, `user_id`, `meja_id`, `name`, `phone`, `date`, `start_time`, `end_time`, `total_harga`, `payment_method`, `status`, `notes`, `created_at`, `updated_at`) VALUES
(1, 3, 2, 'vicky', '', '2025-05-30', '10:00:00', '11:30:00', '67280.00', NULL, 'pending', NULL, '2025-05-29 22:38:37', '2025-05-29 22:38:37');
-- --------------------------------------------------------
--
-- Table structure for table `sessions`
--
CREATE TABLE `sessions` (
`id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` bigint UNSIGNED DEFAULT NULL,
`ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_agent` text COLLATE utf8mb4_unicode_ci,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `transaksi`
--
CREATE TABLE `transaksi` (
`id` bigint UNSIGNED NOT NULL,
`transaction_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` bigint UNSIGNED NOT NULL,
`reservasi_id` bigint UNSIGNED DEFAULT NULL,
`total_amount` decimal(10,2) NOT NULL,
`tax_amount` decimal(10,2) NOT NULL,
`service_charge` decimal(10,2) NOT NULL,
`final_amount` decimal(10,2) NOT NULL,
`status` enum('pending','paid','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
`payment_method` enum('cash','transfer','qris') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`payment_proof` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`paid_at` timestamp NULL DEFAULT NULL,
`notes` text COLLATE utf8mb4_unicode_ci,
`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 `transaksi`
--
INSERT INTO `transaksi` (`id`, `transaction_code`, `user_id`, `reservasi_id`, `total_amount`, `tax_amount`, `service_charge`, `final_amount`, `status`, `payment_method`, `payment_proof`, `paid_at`, `notes`, `created_at`, `updated_at`) VALUES
(1, 'TRX-20250530-6839445D0572D', 3, 1, '58000.00', '6380.00', '2900.00', '67280.00', 'pending', 'qris', NULL, NULL, NULL, '2025-05-29 22:38:37', '2025-05-29 22:38:37');
-- --------------------------------------------------------
--
-- Table structure for table `transaksi_items`
--
CREATE TABLE `transaksi_items` (
`id` bigint UNSIGNED NOT NULL,
`transaksi_id` bigint UNSIGNED NOT NULL,
`menu_id` bigint UNSIGNED NOT NULL,
`menu_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`quantity` int NOT NULL,
`price` decimal(10,2) NOT NULL,
`subtotal` decimal(10,2) NOT NULL,
`notes` varchar(255) COLLATE utf8mb4_unicode_ci 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 `transaksi_items`
--
INSERT INTO `transaksi_items` (`id`, `transaksi_id`, `menu_id`, `menu_name`, `quantity`, `price`, `subtotal`, `notes`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'Nasi Goreng Special', 1, '22000.00', '22000.00', NULL, '2025-05-29 22:38:37', '2025-05-29 22:38:37'),
(2, 1, 2, 'Ayam Geprek', 1, '18000.00', '18000.00', NULL, '2025-05-29 22:38:37', '2025-05-29 22:38:37'),
(3, 1, 3, 'Mie Goreng', 1, '18000.00', '18000.00', NULL, '2025-05-29 22:38:37', '2025-05-29 22:38:37');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
`phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci 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`, `role`, `phone`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Dina Ayu', 'dinaayu@gmail.com', 'user', NULL, '2025-05-25 08:13:30', '$2y$12$mJ.zbRCMVcp1O78WhUBJFeIUVp8njoiT5Ez..RxoBJVPG5pIhG3jK', 'mqJ49iFASl', '2025-05-25 08:13:30', '2025-05-25 08:13:30'),
(2, 'Admin', 'adminlegacy@gmail.com', 'admin', NULL, NULL, '$2y$12$2S7LqgVIzGDXwY6vK13cVeNX4KbBDyT9U3d6hjLlmft1pN9byyU5y', NULL, '2025-05-25 08:13:31', '2025-05-25 08:13:31'),
(3, 'vicky', 'vickynando12@gmail.com', 'user', NULL, NULL, '$2y$12$qwbA2zorlevplQpcq4K6eeChFy7rxYvt1ZgQ.QF2B/466wkR7dbkC', NULL, '2025-05-29 22:37:32', '2025-05-29 22:37:32');
--
-- 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 `carousel_images`
--
ALTER TABLE `carousel_images`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `carts`
--
ALTER TABLE `carts`
ADD PRIMARY KEY (`id`),
ADD KEY `carts_user_id_foreign` (`user_id`),
ADD KEY `carts_menu_id_foreign` (`menu_id`);
--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);
--
-- Indexes for table `gallery_categories`
--
ALTER TABLE `gallery_categories`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `gallery_images`
--
ALTER TABLE `gallery_images`
ADD PRIMARY KEY (`id`),
ADD KEY `gallery_images_category_id_foreign` (`category_id`);
--
-- 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 `kritik_saran`
--
ALTER TABLE `kritik_saran`
ADD PRIMARY KEY (`id`),
ADD KEY `kritik_saran_user_id_foreign` (`user_id`);
--
-- Indexes for table `meja`
--
ALTER TABLE `meja`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `meja_nomor_meja_unique` (`nomor_meja`);
--
-- Indexes for table `menu_categories`
--
ALTER TABLE `menu_categories`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `menu_items`
--
ALTER TABLE `menu_items`
ADD PRIMARY KEY (`id`),
ADD KEY `menu_items_category_id_foreign` (`category_id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`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`);
--
-- Indexes for table `reservasi`
--
ALTER TABLE `reservasi`
ADD PRIMARY KEY (`id`),
ADD KEY `reservasi_user_id_foreign` (`user_id`),
ADD KEY `reservasi_meja_id_date_status_index` (`meja_id`,`date`,`status`);
--
-- 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 `transaksi`
--
ALTER TABLE `transaksi`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `transaksi_transaction_code_unique` (`transaction_code`),
ADD KEY `transaksi_user_id_foreign` (`user_id`),
ADD KEY `transaksi_reservasi_id_foreign` (`reservasi_id`);
--
-- Indexes for table `transaksi_items`
--
ALTER TABLE `transaksi_items`
ADD PRIMARY KEY (`id`),
ADD KEY `transaksi_items_transaksi_id_foreign` (`transaksi_id`),
ADD KEY `transaksi_items_menu_id_foreign` (`menu_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 `carousel_images`
--
ALTER TABLE `carousel_images`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `carts`
--
ALTER TABLE `carts`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `gallery_categories`
--
ALTER TABLE `gallery_categories`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `gallery_images`
--
ALTER TABLE `gallery_images`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `kritik_saran`
--
ALTER TABLE `kritik_saran`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `meja`
--
ALTER TABLE `meja`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `menu_categories`
--
ALTER TABLE `menu_categories`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `menu_items`
--
ALTER TABLE `menu_items`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `reservasi`
--
ALTER TABLE `reservasi`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `transaksi`
--
ALTER TABLE `transaksi`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `transaksi_items`
--
ALTER TABLE `transaksi_items`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `carts`
--
ALTER TABLE `carts`
ADD CONSTRAINT `carts_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menu_items` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `carts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `gallery_images`
--
ALTER TABLE `gallery_images`
ADD CONSTRAINT `gallery_images_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `gallery_categories` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `kritik_saran`
--
ALTER TABLE `kritik_saran`
ADD CONSTRAINT `kritik_saran_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `menu_items`
--
ALTER TABLE `menu_items`
ADD CONSTRAINT `menu_items_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `menu_categories` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `reservasi`
--
ALTER TABLE `reservasi`
ADD CONSTRAINT `reservasi_meja_id_foreign` FOREIGN KEY (`meja_id`) REFERENCES `meja` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `reservasi_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `transaksi`
--
ALTER TABLE `transaksi`
ADD CONSTRAINT `transaksi_reservasi_id_foreign` FOREIGN KEY (`reservasi_id`) REFERENCES `reservasi` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `transaksi_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `transaksi_items`
--
ALTER TABLE `transaksi_items`
ADD CONSTRAINT `transaksi_items_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menu_items` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `transaksi_items_transaksi_id_foreign` FOREIGN KEY (`transaksi_id`) REFERENCES `transaksi` (`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 */;
Reference in New Issue View Git Blame Copy Permalink