-- --------------------------------------------------------
-- Hôte:                         127.0.0.1
-- Version du serveur:           10.4.14-MariaDB - mariadb.org binary distribution
-- SE du serveur:                Win64
-- HeidiSQL Version:             11.2.0.6213
-- --------------------------------------------------------


-- Listage de la structure de la table notaires. acheteurs
CREATE TABLE IF NOT EXISTS `acheteurs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_client` int(11) DEFAULT NULL,
  `id_dossier` int(11) DEFAULT NULL,
  `signe` int(11) NOT NULL DEFAULT 0,
  `date_signe` date DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.acheteurs : ~0 rows (environ)

-- Listage de la structure de la table notaires. cat_proprietes
CREATE TABLE IF NOT EXISTS `cat_proprietes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `Cat` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.cat_proprietes : ~0 rows (environ)
INSERT INTO `cat_proprietes` (`id`, `Cat`, `id_admin`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'test', NULL, NULL, '2021-03-24 15:13:23', '2021-03-24 15:13:23');

-- Listage de la structure de la table notaires. charges
CREATE TABLE IF NOT EXISTS `charges` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_dossier` int(11) DEFAULT NULL,
  `designation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mode_reg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num_cheque` int(11) DEFAULT NULL,
  `montant` int(11) DEFAULT NULL,
  `date_charge` date DEFAULT NULL,
  `remarque` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.charges : ~0 rows (environ)

-- Listage de la structure de la table notaires. comptes
CREATE TABLE IF NOT EXISTS `comptes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nomCompt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `munCompt` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.comptes : ~0 rows (environ)
INSERT INTO `comptes` (`id`, `nomCompt`, `munCompt`, `id_admin`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'cih', '100321456320123647895230', NULL, NULL, '2021-03-24 15:14:10', '2021-03-24 15:14:10');

-- Listage de la structure de la table notaires. conservation_foncieres
CREATE TABLE IF NOT EXISTS `conservation_foncieres` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `conservationFonciere` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.conservation_foncieres : ~0 rows (environ)
INSERT INTO `conservation_foncieres` (`id`, `conservationFonciere`, `id_admin`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'ggggg', NULL, NULL, '2021-03-24 15:14:28', '2021-03-24 15:14:28');

-- Listage de la structure de la table notaires. detail_devis
CREATE TABLE IF NOT EXISTS `detail_devis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_devis` int(11) DEFAULT NULL,
  `id_produit` int(11) DEFAULT NULL,
  `remise` int(11) DEFAULT NULL,
  `prix` double DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.detail_devis : ~0 rows (environ)

-- Listage de la structure de la table notaires. devis
CREATE TABLE IF NOT EXISTS `devis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_dossier` int(11) DEFAULT NULL,
  `id_client` int(11) DEFAULT NULL,
  `montant` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_devis` date DEFAULT NULL,
  `remarque` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.devis : ~0 rows (environ)

-- Listage de la structure de la table notaires. dossiers
CREATE TABLE IF NOT EXISTS `dossiers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_propriete` int(11) DEFAULT NULL,
  `id_etape` int(11) DEFAULT NULL,
  `num_dossier` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num_affaire` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num_repertoire` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_dossier` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nature_doperation` int(11) DEFAULT NULL,
  `hypotheque` tinyint(4) DEFAULT 0,
  `mainlevee` tinyint(4) DEFAULT 0,
  `credit` tinyint(4) DEFAULT 0,
  `qfiscale` tinyint(4) DEFAULT 0,
  `id_compt` int(11) DEFAULT NULL,
  `tva` double(8,2) DEFAULT NULL,
  `montant_global_acte` double(8,2) DEFAULT NULL,
  `montant_quittance_partielle` double(8,2) DEFAULT NULL,
  `montant_vue` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `montant_nonvue` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remarque` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.dossiers : ~0 rows (environ)

-- Listage de la structure de la table notaires. etapes
CREATE TABLE IF NOT EXISTS `etapes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nom` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.etapes : ~0 rows (environ)
INSERT INTO `etapes` (`id`, `nom`, `id_admin`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'test', NULL, NULL, '2021-03-24 15:14:35', '2021-03-24 15:14:35');

-- Listage de la structure de la table notaires. factures
CREATE TABLE IF NOT EXISTS `factures` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_devis` int(11) DEFAULT NULL,
  `num_facture` int(11) DEFAULT NULL,
  `date_facture` date DEFAULT NULL,
  `remarque` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.factures : ~0 rows (environ)

-- Listage de la structure de la table notaires. fichiers
CREATE TABLE IF NOT EXISTS `fichiers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_typefichier` int(11) DEFAULT NULL,
  `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_dossier` int(11) DEFAULT NULL,
  `id_client` int(11) DEFAULT NULL,
  `id_charge` int(11) DEFAULT NULL,
  `id_proprite` int(11) DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.fichiers : ~0 rows (environ)

-- Listage de la structure de la table notaires. migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.migrations : ~24 rows (environ)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(69, '2014_10_12_000000_create_users_table', 1),
	(70, '2014_10_12_100000_create_password_resets_table', 1),
	(71, '2020_03_31_091522_create_admins_table', 1),
	(72, '2020_12_15_214126_create_proprietes_table', 1),
	(73, '2020_12_16_132617_create_cat_proprietes_table', 1),
	(74, '2020_12_16_135805_create_conservation_foncieres_table', 1),
	(75, '2020_12_20_162349_create_dossiers_table', 1),
	(76, '2020_12_20_170311_create_nature_operations_table', 1),
	(77, '2020_12_23_135311_create_fichiers_table', 1),
	(78, '2020_12_23_141055_create_type_fichier_table', 1),
	(79, '2020_12_24_094015_create_reglements_table', 1),
	(80, '2020_12_24_094654_create_proprietaires_table', 1),
	(81, '2020_12_29_142811_create_comptes_table', 1),
	(82, '2020_12_29_143921_create_etapes_table', 1),
	(83, '2020_12_29_163233_create_acheteurs_table', 1),
	(84, '2020_12_30_082035_create_vendeurs_table', 1),
	(85, '2021_01_30_105856_create_produits_table', 1),
	(86, '2021_01_30_125216_create_charges_table', 1),
	(87, '2021_02_02_185630_create_devis_table', 1),
	(88, '2021_02_02_185651_create_detail_devis_table', 1),
	(89, '2021_02_04_143336_create_user_reglements_table', 1),
	(90, '2021_02_06_114231_create_factures_table', 1),
	(91, '2021_03_12_154638_create_role_preiorites_table', 1),
	(92, '2021_03_13_105820_create_roles_table', 1);

-- Listage de la structure de la table notaires. nature_operations
CREATE TABLE IF NOT EXISTS `nature_operations` (
  `id_operation` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nature_doperation` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_operation`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.nature_operations : ~0 rows (environ)
INSERT INTO `nature_operations` (`id_operation`, `nature_doperation`, `id_admin`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'nature', NULL, NULL, '2021-03-24 15:13:11', '2021-03-24 15:13:11');

-- Listage de la structure de la table notaires. produits
CREATE TABLE IF NOT EXISTS `produits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `designation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remise` int(11) DEFAULT NULL,
  `prix` double DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.produits : ~0 rows (environ)

-- Listage de la structure de la table notaires. proprietaires
CREATE TABLE IF NOT EXISTS `proprietaires` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_cli` int(11) NOT NULL,
  `id_propriete` int(11) NOT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.proprietaires : ~0 rows (environ)

-- Listage de la structure de la table notaires. proprietes
CREATE TABLE IF NOT EXISTS `proprietes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `categorie` int(11) NOT NULL,
  `denomination` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `titreFoncier` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `conservationFonciere` int(11) DEFAULT NULL,
  `originePropriete` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `super` double(8,2) NOT NULL DEFAULT 0.00,
  `unit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `complement` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ville` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desc` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.proprietes : ~0 rows (environ)

-- Listage de la structure de la table notaires. reglements
CREATE TABLE IF NOT EXISTS `reglements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `mode_reg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_reg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reg` double DEFAULT NULL,
  `cheque_effect_n` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_dos` int(11) DEFAULT NULL,
  `num_reg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_echeance` date DEFAULT NULL,
  `valid` tinyint(4) NOT NULL DEFAULT 0,
  `id_compt` int(11) DEFAULT NULL,
  `remarque` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.reglements : ~0 rows (environ)

-- Listage de la structure de la table notaires. roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `desc` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.roles : ~0 rows (environ)

-- Listage de la structure de la table notaires. role_preiorites
CREATE TABLE IF NOT EXISTS `role_preiorites` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `addclient` int(11) NOT NULL DEFAULT 0,
  `seeclient` int(11) NOT NULL DEFAULT 0,
  `addpropr` int(11) NOT NULL DEFAULT 0,
  `seepropr` int(11) NOT NULL DEFAULT 0,
  `adddossier` int(11) NOT NULL DEFAULT 0,
  `seedossier` int(11) NOT NULL DEFAULT 0,
  `addcharge` int(11) NOT NULL DEFAULT 0,
  `seecharge` int(11) NOT NULL DEFAULT 0,
  `addregl` int(11) NOT NULL DEFAULT 0,
  `seeregl` int(11) NOT NULL DEFAULT 0,
  `addprod` int(11) NOT NULL DEFAULT 0,
  `seeprod` int(11) NOT NULL DEFAULT 0,
  `adddevis` int(11) NOT NULL DEFAULT 0,
  `seedevis` int(11) NOT NULL DEFAULT 0,
  `addfacture` int(11) NOT NULL DEFAULT 0,
  `seefacture` int(11) NOT NULL DEFAULT 0,
  `parameter` int(11) NOT NULL DEFAULT 0,
  `role` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.role_preiorites : ~1 rows (environ)
INSERT INTO `role_preiorites` (`id`, `id_user`, `addclient`, `seeclient`, `addpropr`, `seepropr`, `adddossier`, `seedossier`, `addcharge`, `seecharge`, `addregl`, `seeregl`, `addprod`, `seeprod`, `adddevis`, `seedevis`, `addfacture`, `seefacture`, `parameter`, `role`, `created_at`, `updated_at`) VALUES
	(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '2021-03-24 16:08:52', '2021-03-24 16:08:53');

-- Listage de la structure de la table notaires. type_fichier
CREATE TABLE IF NOT EXISTS `type_fichier` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nom` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.type_fichier : ~0 rows (environ)
INSERT INTO `type_fichier` (`id`, `nom`, `id_admin`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'ttest', NULL, NULL, '2021-03-24 15:14:41', '2021-03-24 15:14:41');

-- Listage de la structure de la table notaires. user_reglements
CREATE TABLE IF NOT EXISTS `user_reglements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_acheteur` int(11) DEFAULT NULL,
  `id_vendeur` int(11) DEFAULT NULL,
  `id_reg` int(11) DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.user_reglements : ~0 rows (environ)

-- Listage de la structure de la table notaires. vendeurs
CREATE TABLE IF NOT EXISTS `vendeurs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_client` int(11) DEFAULT NULL,
  `id_dossier` int(11) DEFAULT NULL,
  `signe` int(11) NOT NULL DEFAULT 0,
  `date_signe` date DEFAULT NULL,
  `id_admin` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Listage des données de la table notaires.vendeurs : ~0 rows (environ)

