10.123.0.165:3306/INFORMATION_SCHEMA/COLUMNS/		https://pma.us.cloudlogin.co/index.php?route=/database/sql&db=harper_time_tracker

   Showing rows 0 - 78 (79 total, Query took 0.0055 seconds.) [TABLE_NAME: CHECKLIST_ITEM_TAGS... - TASKS...]


SELECT 
    TABLE_NAME,
    COLUMN_NAME,
    COLUMN_TYPE,
    IS_NULLABLE,
    COLUMN_KEY,
    COLUMN_DEFAULT,
    EXTRA
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = "harper_time_tracker"
ORDER BY TABLE_NAME, ORDINAL_POSITION;


TABLE_NAME   	COLUMN_NAME	COLUMN_TYPE	IS_NULLABLE	COLUMN_KEY	COLUMN_DEFAULT	EXTRA	
checklist_item_tags	checklist_item_id	int	NO	PRI	NULL		
checklist_item_tags	tag_id	int	NO	PRI	NULL		
checklist_items	id	int	NO	PRI	NULL	auto_increment	
checklist_items	parent_id	int	YES	MUL	NULL		
checklist_items	task_id	int	YES	MUL	NULL		
checklist_items	content	text	NO		NULL		
checklist_items	is_completed	tinyint(1)	YES		0		
checklist_items	created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED	
checklist_items	sort_order	int	YES		0		
checklist_items	project_id	int	YES	MUL	NULL		
milestones	id	int	NO	PRI	NULL	auto_increment	
milestones	name	varchar(255)	NO		NULL		
milestones	color_code	varchar(7)	YES		#007bff		
note_folders	id	int	NO	PRI	NULL	auto_increment	
note_folders	name	varchar(255)	NO		NULL		
note_folders	parent_id	int	YES	MUL	NULL		
note_folders	created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED	
note_item_tags	note_item_id	int	NO	PRI	NULL		
note_item_tags	tag_id	int	NO	PRI	NULL		
note_items	id	int	NO	PRI	NULL	auto_increment	
note_items	task_id	int	YES	MUL	NULL		
note_items	title	varchar(255)	YES		NULL		
note_items	content	text	NO		NULL		
note_items	is_pinned	tinyint(1)	YES		0		
note_items	created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED	
note_items	sort_order	int	YES		0		
note_items	photo_path	varchar(255)	YES		NULL		
note_items	folder_id	int	YES	MUL	NULL		
project_folders	id	int	NO	PRI	NULL	auto_increment	
project_folders	name	varchar(255)	NO		NULL		
project_folders	parent_id	int	YES	MUL	NULL		
project_folders	created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED	
projects	id	int	NO	PRI	NULL	auto_increment	
projects	name	varchar(255)	NO		NULL		
projects	description	text	YES		NULL		
projects	color_code	varchar(7)	YES		#007bff		
projects	created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED	
projects	folder_id	int	YES	MUL	NULL		
stack_items	id	int	NO	PRI	NULL	auto_increment	
stack_items	stack_id	int	NO	MUL	NULL		
stack_items	item_type	enum('TASK','MILESTONE')	NO		NULL		
stack_items	item_id	int	NO		NULL		
stack_items	sort_order	int	NO		NULL		
stack_items	is_required	tinyint(1)	YES		1		
stack_tasks	id	int	NO	PRI	NULL	auto_increment	
stack_tasks	stack_id	int	NO	MUL	NULL		
stack_tasks	task_id	int	NO	MUL	NULL		
stack_tasks	sort_order	int	NO		NULL		
stacks	id	int	NO	PRI	NULL	auto_increment	
stacks	name	varchar(255)	NO		NULL		
stacks	created_at_utc	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED	
stacks	goal_duration_seconds	int	YES		NULL		
tags	id	int	NO	PRI	NULL	auto_increment	
tags	name	varchar(50)	NO	UNI	NULL		
tags	color_code	varchar(7)	YES		#6c757d		
task_photos	id	int	NO	PRI	NULL	auto_increment	
task_photos	task_id	int	NO	MUL	NULL		
task_photos	photo_path	varchar(255)	NO		NULL		
task_photos	created_at_utc	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED	
task_runs	id	int	NO	PRI	NULL	auto_increment	
task_runs	task_id	int	NO	MUL	NULL		
task_runs	stack_id	int	NO	MUL	NULL		
task_runs	start_time_utc	datetime	NO		NULL		
task_runs	stop_time_utc	datetime	YES		NULL		
task_runs	duration_seconds	int	YES		NULL		
task_runs	status	enum('running','paused','completed')	YES		running		
task_runs	total_paused_seconds	int	YES		0		
task_runs	last_pause_start_utc	datetime	YES		NULL		
task_tags	task_id	int	NO	PRI	NULL		
task_tags	tag_id	int	NO	PRI	NULL		
tasks	id	int	NO	PRI	NULL	auto_increment	
tasks	name	varchar(255)	NO		NULL		
tasks	created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED	
tasks	task_notes	text	YES		NULL		
tasks	stack_id	int	YES		NULL		
tasks	goal_duration_seconds	int	YES		NULL		
tasks	filter_include_tags	varchar(255)	YES		NULL		
tasks	filter_exclude_tags	varchar(255)	YES		NULL		
tasks	filter_match_all	tinyint(1)	YES		0