-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `id` int(11) NOT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` (`id`, `currency`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'USD', 'active', '2021-07-05 01:41:59', '2021-07-05 01:41:59', NULL),
(2, 'INR', 'active', '2021-07-05 01:41:59', '2021-07-05 01:41:59', NULL),
(7, 'AED', NULL, '2021-07-05 18:30:51', '2021-07-05 18:30:51', NULL);

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

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

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

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

--
-- Table structure for table `loans`
--

CREATE TABLE `loans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `bank_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `acc_type` varchar(255) CHARACTER SET utf8 NOT NULL,
  `loan_acc_no` varchar(255) CHARACTER SET utf8 NOT NULL,
  `amount_hkd` varchar(255) CHARACTER SET utf8 NOT NULL,
  `date` date NOT NULL,
  `payment_month` varchar(255) DEFAULT NULL,
  `extra_details` varchar(255) CHARACTER SET utf8 NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `loans`
--

INSERT INTO `loans` (`id`, `name`, `bank_name`, `acc_type`, `loan_acc_no`, `amount_hkd`, `date`, `payment_month`, `extra_details`, `created_at`, `updated_at`) VALUES
(1, 'Lucky Gains Limited', 'BEA', 'HKD Current', '015-523-68-02255-5', '2233.00', '2022-03-24', '4th Month', 'Till Dec\'21', '2022-03-24 07:23:52', '2022-03-24 22:35:17');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0000_00_00_000000_create_settings_table', 1),
(2, '2021_02_03_000000_create_failed_jobs_table', 1),
(3, '2021_02_03_000000_create_users_table', 1),
(4, '2021_02_03_100000_create_password_resets_table', 1),
(5, '2021_06_03_080932_create_company_table', 2),
(6, '2021_06_03_080934_create_employee_table', 2);

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

--
-- Table structure for table `properties`
--

CREATE TABLE `properties` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `location` varchar(255) CHARACTER SET utf8 NOT NULL,
  `address` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `unit_details` text CHARACTER SET utf8 DEFAULT NULL,
  `total_price` varchar(255) CHARACTER SET utf8 NOT NULL,
  `original_buy_price` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `stamp_duty_cost` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `total_cost_with_stamp_duty` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `total_paid_by_sja` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `rental_brokerage` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `properties`
--

INSERT INTO `properties` (`id`, `name`, `location`, `address`, `unit_details`, `total_price`, `original_buy_price`, `stamp_duty_cost`, `total_cost_with_stamp_duty`, `total_paid_by_sja`, `rental_brokerage`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Walnut 9', 'Kowloon, Hong Kong', 'Unit 7, 12th Floor, No 9 Walnut Street, Tai Kok Tsoi', '490 sq ft', 'HK$63,83,627', 'HK$51,43,000', 'HK$3,08,585', 'HK$54,51,585', 'HK$59,77,763', 'HK$4,000', '2022-03-24 07:22:22', '2022-03-29 04:56:25', NULL),
(2, 'Cetus Square Mile', 'Kowloon, Hong Kong', NULL, NULL, 'HK$28,94,490', NULL, NULL, NULL, NULL, NULL, '2022-03-28 01:43:42', '2022-03-28 01:43:42', NULL),
(3, 'W212', 'NT, Hong Kong', NULL, NULL, 'HK$54,92,313', NULL, NULL, NULL, NULL, NULL, '2022-03-28 01:44:37', '2022-03-28 01:44:37', NULL);

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

--
-- Table structure for table `property_payments`
--

CREATE TABLE `property_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `property_id` bigint(20) UNSIGNED NOT NULL,
  `description` varchar(255) CHARACTER SET utf8 NOT NULL,
  `amount` varchar(255) CHARACTER SET utf8 NOT NULL,
  `payment_date` varchar(255) CHARACTER SET utf8 NOT NULL,
  `receipt` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `cheque_number` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `cheque_date` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `cheque_clearance_status` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `reminder_status` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `remarks` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `property_payments`
--

INSERT INTO `property_payments` (`id`, `property_id`, `description`, `amount`, `payment_date`, `receipt`, `cheque_number`, `cheque_date`, `cheque_clearance_status`, `reminder_status`, `remarks`, `created_at`, `updated_at`, `deleted_at`) VALUES
(3, 1, 'Yip Tse Tang', 'HK$2,00,000', '15th June 2018', 'L85978', 'DBS 408565', NULL, NULL, NULL, 'Initial Deposit', '2022-03-29 04:56:25', '2022-03-29 04:56:25', NULL),
(4, 1, 'Yip Tse Tang', 'HK$3,08,585', '20th June 2018', 'L89701', 'DBS 906149', NULL, NULL, NULL, 'Stamp Duty', '2022-03-29 04:56:25', '2022-03-29 04:56:25', NULL);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `type` enum('BOOLEAN','NUMBER','DATE','TEXT','SELECT','FILE','TEXTAREA') COLLATE utf8_unicode_ci NOT NULL,
  `label` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `hidden` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `code`, `type`, `label`, `value`, `hidden`, `created_at`, `updated_at`) VALUES
(1, 'application_logo', 'FILE', 'Application logo', 'hWWNG4bpjU.jpeg', 0, '2019-12-17 07:59:48', '2021-07-16 06:31:42'),
(2, 'application_title', 'TEXT', 'Application Title', 'SMN', 0, '2019-12-17 07:59:48', '2021-07-16 06:31:17'),
(3, 'favicon_logo', 'FILE', 'favicon Logo', 'ThpQpzuvgx.png', 0, '2019-12-17 07:59:48', '2021-07-16 06:31:31'),
(4, 'copyright', 'TEXT', 'Copyright Title', 'SMN', 0, '2019-12-17 07:59:48', '2021-07-16 06:31:08');

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

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `type` enum('inward','outward') DEFAULT NULL,
  `currency_id` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `client` varchar(255) DEFAULT NULL,
  `beneficiaryname` varchar(255) DEFAULT NULL,
  `consignee` varchar(255) DEFAULT NULL,
  `payment_method` enum('bank','cash') DEFAULT NULL,
  `neft` varchar(255) DEFAULT NULL,
  `rtgf` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` (`id`, `date`, `status`, `type`, `currency_id`, `amount`, `client`, `beneficiaryname`, `consignee`, `payment_method`, `neft`, `rtgf`, `created_at`, `updated_at`, `deleted_at`) VALUES
(4, '2021-07-16', 'on_hold', 'inward', '1', '12', '12', '13', '12', 'cash', NULL, NULL, '2021-07-16 05:12:04', '2021-07-16 06:29:09', '2021-07-16 06:29:09'),
(5, '2021-07-16', 'on_hold', 'inward', '1', '12', 'Peter Shilton', 'Peter Shilton', '12', 'cash', NULL, NULL, '2021-07-16 06:29:56', '2021-07-16 06:29:56', NULL),
(6, '2021-07-16', 'on_hold', 'inward', '1', '12', 'Wayne Rooney', 'Wayne Rooney', '12', 'cash', NULL, NULL, '2021-07-16 06:30:24', '2021-07-16 06:30:24', NULL),
(7, '2022-03-26', 'success', 'outward', '1', '12', 'David Beckham', 'David Beckham', '12', 'cash', NULL, NULL, '2021-07-16 06:30:48', '2022-03-26 06:44:55', NULL);

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

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

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

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

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

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

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_code_unique` (`code`);

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

--
-- AUTO_INCREMENT for table `currency`
--
ALTER TABLE `currency`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

