CREATE TABLE USERS (
  ID INT NOT NULL AUTO INCREMENT,
  NAME VARCHAR(100) NOT NULL,
  USERNAME VARCHAR(20) NOT NULL,
  PASSWORD VARCHAR(100) NOT NULL,
  TYPE TINYINT(4) NOT NULL,
  PRIMARY KEY (ID)
);

CREATE TABLE SERVICES (
  ID INT NOT NULL AUTO INCREMENT,
  PROVIDER_ID NOT NULL,
  NAME VARCHAR(50) NOT NULL,
  DESCRIPTION TEXT NOT NULL,
  TYPE VARCHAR(20) NOT NULL,
  FEE DOUBLE NOT NULL,
  ACTIVE TINYINT(4) NOT NULL DEFAULT 1,
  PRIMARY KEY(ID),
  FOREIGN KEY (PROVIDER_ID) REFERENCES USERS(ID)
);

CREATE TABLE ORDERS (
  ID INT NOT NULL AUTO INCREMENT,
  SERVICE_ID INT NOT NULL,
  TENANT_ID INT NOT NULL,
  STATUS vARCHAR(20) NOT NULL
  ORDER_DATE DATE NOT NULL,
  PRIMARY KEY (ID),
  FOREIGN KEY (SERVICE_ID) REFERENCES SERVICES(ID),
  FOREIGN KEY (TENANT_ID) REFERENCES USERS(ID)
);

CREATE TABLE REVIEWS (
  ID INT NOT NULL AUTO INCREMENT,
  REVIEWER_ID INT NOT NULL,
  SERVICE_ID INT NOT NULL,
  RATE INT NOT NULL,
  REVIEW TEXT NOT NULL,
  PRIMARY KEY (ID),
  FOREIGN KEY (REVIEWER_ID) REFERENCES USERS(ID),
  FOREIGN KEY (SERVICE_ID) REFERENCES SERVICES(ID)
);


USERS
1, UZUMAKI NARUTO, NARUTO, HINATA_143, 0
2, MONKEY D. LUFFY, LUFFY, PIRATE_KING_123, 0
3, DEKU, DEKU, ALL_MIGHT_143, 1
4, ASTA, ASTA, SISTER_LILY_143, 1
5, TANJIRO KAMADO, TANJIRO, WHERE_IS_MUZAN, 1

SERVICES
1, 1, TALK NU JUTSU, I WILL TALK TO YOUR ENEMY AND CONVINCE HIM TO BE A GOOD GUY AGAIN, COUNSELING, 100
2, 2,