search

yudisentosa / SBDProjectSchool

0 stars 0 forks source link

Table - period #24

Closed marcelinalinaa closed 3 years ago

marcelinalinaa commented 3 years ago

DROP TABLE IF EXISTS period; CREATE TABLE period( period_id VARCHAR(4) NOT NULL PRIMARY KEY ,start_hour NUMERIC(6,2) NOT NULL ,end_hour NUMERIC(5,2) NOT NULL ,status VARCHAR(23) NOT NULL ); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P001',07.00,08.30,'in class'); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P002',08.30,10.00,'in class'); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P003',10.00,10.30,'break'); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P004',10.30,12.00,'in class'); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P005',12.00,12.15,'break'); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P006',12.15,13.45,'in class'); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P007',14.00,15.30,'after school activities');

yudisentosa commented 3 years ago

DROP TABLE IF EXISTS period; CREATE TABLE period( period_id VARCHAR(4) NOT NULL PRIMARY KEY ,start_hour VARCHAR(5) NOT NULL ,end_hour VARCHAR(5) NOT NULL ,status VARCHAR(23) NOT NULL ); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P001','7:00','8:30','in class'); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P002','8:30','10:00','in class'); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P003','10:00','10:30','break'); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P004','10:30','12:00','in class'); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P005','12:00','12:15','break'); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P006','12:15','13:45','in class'); INSERT INTO period(period_id,start_hour,end_hour,status) VALUES ('P007','14:00','15:30','after school activities');