projects
| Column |
Type |
PK |
Required |
Default |
| uniform_resource_id |
TEXT |
No |
No |
|
| project_id |
|
No |
No |
|
| project_name |
|
No |
No |
|
| description |
|
No |
No |
|
| created_by |
|
No |
No |
|
| created_at |
|
No |
No |
|
| last_updated_at |
|
No |
No |
|
| status |
|
No |
No |
|
| tags |
|
No |
No |
|
| linked_requirements |
|
No |
No |
|
| dependencies |
|
No |
No |
|
| goals |
|
No |
No |
|
| critical_milestones |
|
No |
No |
|
Foreign Keys
Indexes
SQL DDL
CREATE TABLE projects(
uniform_resource_id TEXT,
project_id,
project_name,
description,
created_by,
created_at,
last_updated_at,
status,
tags,
linked_requirements,
dependencies,
goals,
critical_milestones
)