CreateEvent Endpoint - Githubissues

Software-Engineering-Group-9 / Back-End-API

Spring Boot. Backend of Doable Calendar - Endpoints, JDBC, etc.

0 stars 0 forks source link

CreateEvent Endpoint #13

Closed BoKlassen closed 3 years ago

BoKlassen commented 3 years ago

Begin working on this endpoint
Update event DB table schema to match front-ends fetch request
update SQL commands related to Event Table

MingHaoC commented 3 years ago

the new schema for the event table is: CREATE TABLE event( eid VARCHAR2(100) NOT NULL, title VARCHAR2(40), color VARCHAR2(7), duedate VARCHAR2(10), duetime VARCHAR2(6), userid VARCHAR2(50), PRIMARY KEY (eid), FOREIGN KEY (userid) REFERENCES user(uuid) );