Scribd
Upload
3 views2 pages

Database Structure for Task Manager

The document outlines the database structure for a smart task manager, detailing the tables and their respective columns, types, nullability, and defaults. Key tables include attachment, calendarevent, comment, notification, role, tag, task, tasklist, task_tag, and user. Each table serves a specific function related to task management, such as storing user information, task details, and event scheduling.

Uploaded by

IT'ss Mę
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
3 views2 pages

Database Structure for Task Manager

The document outlines the database structure for a smart task manager, detailing the tables and their respective columns, types, nullability, and defaults. Key tables include attachment, calendarevent, comment, notification, role, tag, task, tasklist, task_tag, and user. Each table serves a specific function related to task management, such as storing user information, task details, and event scheduling.

Uploaded by

IT'ss Mę
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

===Database smarttaskmanager

== Table structure for table attachment

|------
|Column|Type|Null|Default
|------
|//**id**//|bigint(20)|No|
|filename|varchar(255)|Yes|NULL
|contentType|varchar(100)|Yes|NULL
|size|bigint(20)|Yes|NULL
|data|blob|Yes|NULL
|task_id|bigint(20)|Yes|NULL
== Dumping data for table attachment

== Table structure for table calendarevent

|------
|Column|Type|Null|Default
|------
|//**id**//|bigint(20)|No|
|title|varchar(255)|Yes|NULL
|startDateTime|datetime|Yes|NULL
|endDateTime|datetime|Yes|NULL
|taskList_id|bigint(20)|Yes|NULL
== Dumping data for table calendarevent

== Table structure for table comment

|------
|Column|Type|Null|Default
|------
|//**id**//|bigint(20)|No|
|content|text|Yes|NULL
|createdAt|datetime|Yes|NULL
|task_id|bigint(20)|Yes|NULL
== Dumping data for table comment

== Table structure for table notification

|------
|Column|Type|Null|Default
|------
|//**id**//|bigint(20)|No|
|message|text|Yes|NULL
|createdAt|datetime|Yes|NULL
|read|tinyint(1)|Yes|NULL
|user_id|bigint(20)|Yes|NULL
== Dumping data for table notification

== Table structure for table role

|------
|Column|Type|Null|Default
|------
|//**id**//|bigint(20)|No|
|name|varchar(255)|Yes|NULL
== Dumping data for table role
== Table structure for table tag

|------
|Column|Type|Null|Default
|------
|//**id**//|bigint(20)|No|
|name|varchar(255)|Yes|NULL
== Dumping data for table tag

== Table structure for table task

|------
|Column|Type|Null|Default
|------
|//**id**//|bigint(20)|No|
|name|varchar(255)|Yes|NULL
|description|text|Yes|NULL
|dueDate|date|Yes|NULL
|priority|varchar(50)|Yes|NULL
|taskList_id|bigint(20)|Yes|NULL
== Dumping data for table task

== Table structure for table tasklist

|------
|Column|Type|Null|Default
|------
|//**id**//|bigint(20)|No|
|name|varchar(255)|Yes|NULL
|user_id|bigint(20)|Yes|NULL
== Dumping data for table tasklist

== Table structure for table task_tag

|------
|Column|Type|Null|Default
|------
|//**task_id**//|bigint(20)|No|
|//**tag_id**//|bigint(20)|No|
== Dumping data for table task_tag

== Table structure for table user

|------
|Column|Type|Null|Default
|------
|//**id**//|bigint(20)|No|
|username|varchar(255)|Yes|NULL
|password|varchar(255)|Yes|NULL
|email|varchar(255)|Yes|NULL
|role_id|bigint(20)|Yes|NULL
== Dumping data for table user

You might also like