Header bar:

• Logo
• Logout.
• Username.

Showing log record

• All actions (execute from the interface of Kaptain) should be recorded.

1. Login

{Username} logged in on {date time}.

2. Logout

{Username} logged out on {datetime}.

3. Select

{Username} selected {full of query string} on {date time}.
{PROJECT NAME}

4. Update

{Username} updated {full of query string} on {datetime}.

5. Delete

{Username} deleted {full of query string} on {datetime}.

Filter

• Make {username} clickable to filter by that user only.
• Make {action} clickable to filter by that kind of action only.

Show more

• 10 items per page.
• Show "Show more" button if there are more items to load.
• Click "Show more" to load next 10 items.

Mockup

Header bar

• Log out/in | Profile icon.

Body

• Show the list of database/project's names.
• Show the list of table's names of a database/project.
• Click on each table name to view a table containing all records on rows (paging if needed).

Table

• 1 or many columns. Scroll horizontally if needed.
• Column name.
• Cell's value.
• Read-only.
• Double click on a row or click view detail button/icon to view the record in detail view.

Record's detail view - read-only mode

• A table of 2 columns.
• 1st column: field name.
• 2nd column: field's value.
• Edit button (to current view to edit mode).
• Delete button (to delete this record).

Record's detail view - edit mode

• User can change value of 2nd column.

Header

• Kaptain logo.
• Username
• Logout button.

Left side menu

• Show list of project name.
• Expand project name to show list of tables.
• Collapse project name to hide all its tables.

Table

• Click table name to show a table and data on the right.
• Table name.
• Column name.
• Row and value, read only.

1. Pagination

• default 10 items per page.
• User can decide how many items showing per page using drop down list (10, 20 and 30).
• Show indicator under the table "Showing {from} to {to} of {total records}". ie: Showing 1 to 10 of 57 entries.
• Next: go to next page.
• Previous: go to previous page.
• First: go to the first page of results.
• Last: go to the last page of results.

2. Sorting

• User can sort rows by any fields (A->Z, Z->A).
• Apply sorting to all rows.
• Click "A->Z" or "Z->A" to start sorting (and close the menu).

3. Filter

• Filter by value.
  
• Search for a value (to filter).
• Select all values (to filter): tick all values.
• Clear values: clear all ticks of showing values. (values returned by searching).
• Tick/Un-tick any value (to filter).
• OK: to get filter working.
• Cancel: to close the menu.

4. Search

• User can search for a record.
• User can search by any fields of table.

4. Action on a record

4.1. Edit

• Click to change selecting row to edit mode (change cells to text fields).
• Enter to save changes for selecting row.
• Hover over icon to show tooltip "Edit".

4.2. Delete.

• Click to delete selecting row.
• Show confirm msg before deleting.
• Hover over icon to show tooltip "Delete".

Mockup

Logo

• A page for user to manage who can do what.
• There are many users able to access to Kaptain. They are granted permission to touch some particular databases and tables and actions.
• There should be some controls for user to set who {user} can do {read/write/delete} on {table name}.

A page showing all activity feeds about query running from every projects. Any action happening to database should be log here.

The sentence format should be:

{user name} {action} {query string} on {date time}

• A query string could be very long. Please consider for a view more button or tooltip.
• There would be a lot of log recorded. Please consider for paging or showing more.