zaselalk / FOT-Tecmis

3 stars 1 forks source link

Add some sample data for medical table1 #30

Closed zaselalk closed 5 months ago

zaselalk commented 5 months ago
mysql> desc medical;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| medical_id   | int          | NO   | PRI | NULL    | auto_increment |
| student_id   | int          | NO   |     | NULL    |                |
| course_id    | int          | NO   |     | NULL    |                |
| departmentId | int          | NO   |     | NULL    |                |
| startDate    | date         | NO   |     | NULL    |                |
| endDate      | date         | NO   |     | NULL    |                |
| description  | varchar(100) | YES  |     | NULL    |                |
| filePath     | varchar(50)  | YES  |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)
KosalaGunarathna commented 5 months ago
INSERT INTO `medical` (`student_id`, `course_id`, `departmentId`, `startDate`, `endDate`, `description`)
VALUES
  (1, 1, 1, '2024-01-01', '2024-01-01', 'Medical checkup for student'),
  (2, 2, 1, '2024-02-06', '2024-02-08', 'Medical checkup for student'),
  (3, 3, 2, '2024-03-01', '2024-03-04', 'Medical checkup for student');
  (4, 3, 3, '2024-01-01', '2024-01-03', 'Medical checkup for student');
  (5, 3, 3, '2024-01-01', '2024-01-03', 'Medical checkup for student');
zaselalk commented 5 months ago

Thanks @KosalaGunarathna