ProjectMilestones: Project Milestones |
https://online-sql-editor.com/teamleader/eu/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Teamleader.V1Flat.ProjectMilestones%0D%0Alimit++1000
Name: ProjectMilestones
Catalog: Teamleader
Schema: V1Flat
Label: Project Milestones
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
billing_type |
string |
Billing Type |
☐ |
|
budget |
double |
Budget |
☐ |
|
closed |
boolean |
Closed |
☑ |
|
due_date |
datetime |
Due Date |
☐ |
|
id |
int32 |
ID |
☑ |
|
project_id |
int32 |
ID |
☑ |
|
project_phase |
string |
Phase |
☐ |
|
project_start_date |
datetime |
Start Date |
☐ |
|
project_start_date_formatted |
string(20) |
Start Date (Formatted) |
☐ |
|
project_title |
string |
Title |
☑ |
|
responsible_user_id |
int32 |
Responsible User ID |
☐ |
|
tasks_time_overrun_minutes |
int32 |
Tasks Time Overrun (Minutes) |
☐ |
|
tasks_time_remaining_minutes |
int32 |
Tasks Time Remaining (Minutes) |
☐ |
|
time_tracked_minutes |
int32 |
Time Tracked (Minutes) |
☐ |
|
title |
string |
Title |
☐ |
|
10-09-2020 00:0920.1.206-BETA+2915