MyPlanner Database Tables

04/13/2024

title: MyPlanner Database Tables created: '2020-04-02T03:16:09.345Z' modified: '2020-04-02T03:56:27.548Z'

MyPlanner Database Tables

Users

id	int, unsigned, not null, unique, auto_increment
email	varchar(50), not null, unique
password	char(30), not null

Labels

id	int, unsigned, not null, unique, auto_increment
user_id	int, unsigned, not null
name	varchar(20)
color	char(7)

Projects

id	int, unsigned, not null, unique, auto_increment
user_id	int, unsigned, not null
name	varchar(100), not null
description	text
datetime_created	datetime, not null
date_due	datetime
display_index	int, unsigned, not null

Project_Notes

id	int, unsigned, not null, unique, auto_increment
project_id	int, unsigned, not null
content	text
display_index	int, unsigned, not null

Project_Checklists

id	int, unsigned, not null, unique, auto_increment
project_id	int, unsigned, not null
name	varchar(100), not null
display_index	int, unsigned, not null

Project_Checklist_Items

id	int, unsigned, not null, unique, auto_increment
project_checklist_id	int, unsigned, not null
content	text
completed	enum('n', 'y'), default 'n', not null
display_index	int, unsigned, not null

Items

id	int, unsigned, not null, unique, auto_increment
project_id	int, unsigned, not null
name	varchar(50), not null
description	text
date_created	datetime, not null
date_due	datetime
completed	enum('n', 'y'), default 'n', not null
display_index	int, unsigned, not null

Item_Labels

item_id	int, unsigned, not null
label_id	int, unsigned, not null

Item_Notes

id	int, unsigned, not null, unique, auto_increment
item_id	int, unsigned, not null
content	text
display_index	int, unsigned, not null

Item_Checklists

id	int, unsigned, not null, unique, auto_increment
item_id	int, unsigned, not null
name	varchar(100), not null
display_index	int, unsigned, not null

Item_Checklist_Items

id	int, unsigned, not null, unique, auto_increment
item_checklist_id	int, unsigned, not null
content	text
completed	enum('n', 'y'), default 'n', not null
display_index	int, unsigned, not null

© 2024 by Ryan Rickgauer