Nicolas
Data model
Table of contents
Version 1.0
Version 2.0
Table Ticket
| Attribute | Type | Properties |
|---|---|---|
| ticket_id | INTEGER | PRIMARY KEY, NOT NULL, AUTOINCREMENT |
| ticket_name | VARCHAR(80) | NOT NULL |
| sprint_number | INTEGER | |
| workload | FLOAT | |
| description | TEXT | |
| ticket_status | VARCHAR(17) | DEFAULT ‘Inbox’ |
| assigned | VARCHAR(30) | |
| notes | TEXT |
Table User
| Attribute | Type | Properties |
|---|---|---|
| id | INTEGER | PRIMARY KEY, NOT NULL, AUTOINCREMENT |
| username | VARCHAR(80) | NOT NULL |
| VARCHAR(80) | NOT NULL | |
| password | VARCHAR(128) | NOT NULL |