 --
 
 CREATE TABLE `appointment` (
-  `user_id` int(11) NOT NULL,
-  `client_id` int(11) NOT NULL,
+  `id` int(11) NOT NULL,
+  `user_id_fk` int(11) NOT NULL,
+  `client_id_fk` int(11) NOT NULL,
   `date` date NOT NULL,
   `start_time` time NOT NULL,
   `end_time` time NOT NULL,
   `type` int(11) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `appointment`
+--
+
+INSERT INTO `appointment` (`id`, `user_id_fk`, `client_id_fk`, `date`, `start_time`, `end_time`, `type`) VALUES
+(1, 1, 1, '2018-02-28', '10:30:00', '11:00:00', 1),
+(2, 1, 2, '2018-02-27', '11:00:00', '11:30:00', 2),
+(3, 2, 2, '2018-02-09', '12:15:00', '13:00:00', 2);
 
 -- --------------------------------------------------------
 

  `notes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--

-- Indexes for table `appointment`
--
ALTER TABLE `appointment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `client_fk` (`client_id_fk`),
  ADD KEY `user_fk` (`user_id_fk`);

--
-- Indexes for table `client`
