Columns

Columns

AllTablesViewsComments

Search:

Table	Type	Column	Type	Size	Nullable	Auto	Default	Comments
product	Table	calories	INT UNSIGNED	10			null
product	Table	category	VARCHAR	50			null
store	Table	city	VARCHAR	255			null
client	Table	city	VARCHAR	255			null
review	Table	client_id	INT UNSIGNED	10			null
order	Table	client_id	INT UNSIGNED	10	√		null
comment	Table	comment_id	INT UNSIGNED	10		√	null
store	Table	coordinate	GEOMETRY	65535			null
product	Table	created_date	DATETIME	19			CURRENT_TIMESTAMP
comment	Table	created_date	DATETIME	19			CURRENT_TIMESTAMP
order	Table	created_date	DATETIME	19			CURRENT_TIMESTAMP
review	Table	created_date	DATETIME	19			CURRENT_TIMESTAMP
order_product	Table	cup_size	enum('small', 'medium', 'large')	6			null
product	Table	description	TEXT	65535			null
client	Table	district_id	INT UNSIGNED	10			null
district	Table	district_id	INT UNSIGNED	10		√	null
store	Table	district_id	INT UNSIGNED	10			null
user	Table	email	VARCHAR	320			null
password_change_request	Table	expiry_date	DATETIME	19			null
user	Table	first_name	VARCHAR	255			null
product	Table	img_alt_text	VARCHAR	150			null
product	Table	img_url	VARCHAR	255			null
administrator	Table	is_super_admin	BIT	1			0
administrator	Table	job_title	VARCHAR	255			null
user	Table	last_name	VARCHAR	255			null
order_product	Table	milk_type	enum('almond', 'coconut', 'oat', 'soy')	7			null
product	Table	name	VARCHAR	255			null
district	Table	name	enum('Moka', 'Port Louis', 'Flacq', 'Curepipe', 'Black River', 'Savanne', 'Grand Port', 'Riviere du Rempart', 'Pamplemousses', 'Mahebourg', 'Plaines Wilhems')	18			null
order_product	Table	order_id	INT UNSIGNED	10			null
order	Table	order_id	INT UNSIGNED	10		√	null
comment	Table	parent_comment_id	INT UNSIGNED	10	√		null
user	Table	password	VARCHAR	255			null
user	Table	phone_no	VARCHAR	255			null
store	Table	phone_no	VARCHAR	255			null
order	Table	pickup_date	DATETIME	19	√		null	Date when client picks up his order at the store
product	Table	price	DECIMAL	10			null
store_product	Table	product_id	INT UNSIGNED	10			null
order_product	Table	product_id	INT UNSIGNED	10			null
product	Table	product_id	INT UNSIGNED	10		√	null
review	Table	product_id	INT UNSIGNED	10			null
order_product	Table	quantity	INT UNSIGNED	10			null
review	Table	rating	INT UNSIGNED	10			null
password_change_request	Table	request_id	INT UNSIGNED	10		√	null
comment	Table	review_id	INT UNSIGNED	10			null	ID of review under which comment is found
review	Table	review_id	INT UNSIGNED	10		√	null
order	Table	status	enum('pending', 'cancelled', 'completed')	9			pending
store_product	Table	stock_level	INT UNSIGNED	10			0
order	Table	store_id	INT UNSIGNED	10			null
store	Table	store_id	INT UNSIGNED	10		√	null
store_product	Table	store_id	INT UNSIGNED	10			null

Showing 1 to 50 of 62 entries

• Previous
• 1
• 2
• Next