End Points

user_table

GET: GET requests will return all tables in the user schema
POST: POST requests will create a table based on the JSON string passed in through the table_post parameter.

---

user_table_put_delete

POST: POST requests will drop the table that is named with the value in the table-name post parameter

---

user_schema

GET OR POST: Will return all tables with columns in the user schema, along with those tables attached foreign key constraints, primary key constraints, and attached triggers. Example Output:

---

user_table_column

GET: Returns all column information for a specific table. The specific table is the name of the table passed in through the GET table-name parameter

---

user_alter_table_column

POST: Adds a column to an existing column.

PARAMETERS

• table-name: Name of which to add a column.
  
• column-name: Name of the column to be added.
  
• column-type: Data-type of column to be added.
  
• column-size[optional]: Size of column to be added (Required only if specified type requires column length to be specified. Ex. Date does not require a size, but VARCHAR does).
  
• not-null[optional]: Specifies not null constrain at column level
  
• unique[optional]: Specifies unique constraint at column level
  

---

user_alter_table_column_put_delete

GET: Emulates PUT request. Edits an existing column in table.
PARAMETERS

• table-name: Name of which to edit a column.
  
• column-name: Name of the column to be edited.
  
• new-column-type: Data-type of column to be edited.
  
• new-column-size[optional]: Size of column to be added (Required only if specified type requires column length to be specified. Ex. Date does not require a size, but VARCHAR does).
  
• not-null[optional]: Specifies not null constrain at column level
  
• unique[optional]: Specifies unique constraint at column level
  

POST: Emualtes DELETE request. Drops a column from a table.

PARAMETERS

• table-name: Name of table of which to drop column.
  
• column-name: Name of column of which to drop.