Skills

Create, update, delete, and query from skills table

Table Specific Information

Following is an example to select all entries from Skills table:

SELECT * FROM Skills

You can also select a specific entry from Skills table:

SELECT * FROM Skills WHERE Id = 73000001322

Name is mandatory for creating a new skill. Following is an example of creating a new skill:

INSERT INTO Skills (Name) VALUES ('Example')

Following is an example of how to update a skill:

UPDATE Skills SET Name = 'New name' WHERE Id = 73000001322

Following is an example of how to delete from Skills table:

DELETE FROM Skills WHERE Id = 73000001322


Name	Type	ReadOnly	Description
Id [KEY]	Bigint	False	ID of the skill.
Name	String	False	Name of the skill.
Rank	String	True	Position/Rank of the skill.
Agents	String	False	Agents associated with the skill.
MatchType	String	True	Match type for conditions.
Conditions	String	False	Conditions of the skill.
CreatedAt	Datetime	True	Skills creation timestamp.
UpdatedAt	Datetime	True	Skills updated timestamp.