Notes table

Column Type

Id

Integer

Url

URI

Project

String

Contact

String

Note

String

Parent_Id

Integer

Parent_Url

URI

Author

String

Created_At

Timestamp

Updated_At

Timestamp

Examples

SELECT
    *
FROM
    Notes
WHERE
    Contact = 'https://api.freeagent.com/v2/contacts/18494140'
INSERT INTO
    Notes (Note, Contact)
VALUES
    (
        'A new note',
        'https://api.freeagent.com/v2/contacts/18494140'
    )

UPDATE Notes
SET
    Name = 'Thomas Axen'
WHERE
    Id = '906732'

DELETE FROM Notes
WHERE
    Id = '906732'