CREATE TABLE sc_resources_category
(
	id 				NUMBER(19, 0) NOT NULL,
	instanceId 		VARCHAR(50) NOT NULL,
	name 			VARCHAR(50) NOT NULL,
	creationdate 	VARCHAR(20) NOT NULL,
	updatedate 		VARCHAR(20) NOT NULL,
	bookable 		INT,
	form 			VARCHAR(50),
	responsibleid 	INT,
	createrid 		VARCHAR(50),
	updaterid 		VARCHAR(50),
	description 	VARCHAR(2000)
)
;

CREATE TABLE sc_resources_resource
(
	id 				NUMBER(19, 0) NOT NULL,
	instanceId 		VARCHAR(50) NOT NULL,
	categoryid  	NUMBER(19, 0)  NOT NULL,
	name 			VARCHAR(128) NOT NULL,
	creationdate 	VARCHAR(20) NOT NULL,
	updatedate 		VARCHAR(20) NOT NULL,
	bookable 		INT,
	responsibleid 	INT,
	createrid 		VARCHAR(50),
	updaterid 		VARCHAR(50),
	description 	VARCHAR(2000)
)
;

CREATE TABLE sc_resources_reservation
(
	id 				NUMBER(19, 0)  NOT NULL,
	instanceId 		VARCHAR(50) NOT NULL,
	evenement 		VARCHAR(128) NOT NULL,
	userId 			INT NOT NULL,
	creationdate 	VARCHAR(20) NOT NULL,
	updatedate 		VARCHAR(20) NOT NULL,
	begindate 		VARCHAR(20) NOT NULL,
	enddate 		VARCHAR(20) NOT NULL,
	reason			VARCHAR(2000),
	place 			VARCHAR(128),
    status		    VARCHAR(50)
)
;

CREATE TABLE sc_resources_reservedresource
(
	reservationId 	NUMBER(19, 0)  NOT NULL,
	resourceId 		NUMBER(19, 0)  NOT NULL,
    status		    VARCHAR(50)
)
;

CREATE TABLE sc_resources_managers
(
	resourceId 	NUMBER(19, 0) NOT NULL,
	managerId	NUMBER(19, 0) NOT NULL
)
;