database schema - adbms project

schema

user_type
	id int primary key
	type varchar


doctors
	id int primary key
	name varchar
	designation varchar
	title varchar
	available_hours array(time)
	join_date datetime
	date_of_birth datetime
	specialization varchar
	type varchar
	
patients
	id int primary
	name varchar
	date_of_admin varchar
	disease varchar
	critical_level int
	release_date datetime
	address varchar
	

doctor_type
	id int primary
	type varchar

patient_type
	id int primary 
	type varchar

disease_type
	id int primary key
	type varchar