restaurants
	restaurant_id
	added_on
	restaurant_name
	address
	city
	state
	country
	zipcode
	email
	phone
	logo

modules
	module_id
	module_name
	is_delete
	is_modify
	is_add
	is_list
	list_file
	detail_file
	script_file

role_permissions
	permission_id
	role_id
	module_id
	can_delete
	can_modify
	can_add
	can_list

login_roles	
	role_id
	restaurant_id
	role
	
logins
	login_id
	restaurant_id
	email
	password
	role_id

users
	user_id
	added_on
	restaurant_id
	email
	password
	first_name
	last_name
	mobile
	dob
	email_verified
	ref_code
	invited_by
	active

invitations
	invitation_id
	restaurant_id	
	sent_on
	sent_by
	ref_code
	email
	name
	status	P: Pending, A: Accepted
	accepted_on

club_membership_plans
	membership_plan_id
	restaurant_id
	title
	monthly_price
	quarterly_price
	half_yearly_price
	yearly_price
	monthly_loyalty_points
	quarterly_loyalty_points
	half_yearly_loyalty_points
	yearly_loyalty_points
	summary

user_memberships
	membership_id
	restaurant_id
	user_id
	membership_plan_id
	price
	summary
	duration
	start_date
	last_renewed_on
	expiry_date
	subscription_id
	status	P: Pending, C: Canceled, A: Active, F: Failed
	failed_reason

membership_payments
	membership_payment_id
	restaurant_id
	membership_id
	user_id
	payment_date
	price
	payment_status	P: Pending, S: Success, F: Failed
	payment_message	
	transaction_id

club_items
	club_item_id
	restaurant_id
	item_name
	image
	price
	summary
	loyalty_points
	
item_orders
	item_order_id
	restaurant_id
	user_id
	order_date
	order_amount
	delivery_status	P: Pending, D: Delivered, C: Canceled, R: Returned
	cancel_reason
	payment_status	P: Pending, S: Success, F: Failed
	payment_message
	transaction_id

item_order_details
	item_order_detail_id
	item_order_id
	club_item_id
	qty
	price

user_points
	point_id
	user_id
	restaurant_id
	type
	points
	summary
	point_type	I: Item Order, M: Membership, F: Food Order
	order_id
---------------------------------------------------------------------------------
notifications
	notification_id
	restaurant_id
	sent_on
	user_id
	title
	summary
	read_by

events
	event_id
	restaurant_id
	added_on
	title
	summary
	event_date
	event_time
	image

food_categories
	category_id
	restaurant_id
	category_name
	rank

food_items
	food_item_id
	restaurant_id
	menu_type	F: Food, D: Drink, W: Wine
	allow_order	B: Beach Order, T: Table Order, B: Both
	category_id
	item_name
	summary
	image
	price
	loyalty_points

food_orders
	food_order_id
	restaurant_id
	user_id
	order_date
	order_amount
	order_type		O: Online, T: Table Order
	delivery_status
	payment_status
	payment_message
	transaction_id

food_order_details
	food_order_detail_id
	food_order_id
	food_item_id
	qty
	price