Projects table

Column Type

Id

Integer

Url

URI

Currency

String

Name

String

Budget_Units

String

Contact_Id

String

Contact

URI

Contact_Name

String

Billing_Period

String

Status

String

Uses_Project_Invoice_Sequence

Boolean

Created_At

Timestamp

Contract_Po_Reference

String

Updated_At

Timestamp

Starts_On

String

Is_Ir35

Boolean

Ends_On

String

Include_Unbilled_Time_In_Profitability

Boolean

Budget

Integer

Hours_Per_Day

Decimal

Normal_Billing_Rate

Decimal

Is_Deletable

Boolean

Examples

SELECT
    *
FROM
    Projects
WHERE
    Status = 'Active'

INSERT INTO
    Projects (
        [Name],
        Contact,
        [Status],
        Currency,
        Budget_Units,
        Budget,
        Starts_On,
        Is_Deletable
    )
VALUES
    (
        'Consultancy to add features.',
        'https://api.freeagent.com/v2/contacts/18494140',
        'Active',
        'USD',
        'Monetary',
        '9999',
        '2025-01-03',
        'true'
    )

UPDATE Projects
SET
    Name = 'New Features'
WHERE
    Id = '4088693'

DELETE FROM Projects
WHERE
    Id = '4088697'