I'm in need of a management UI for a database consisting of the following tables:
User:
| Column Name | Type | Extra Info |
|---|---|---|
| id | String | UUID. |
| String. Should be searchable by this field | ||
| name | String. Should be searchable by this field | |
| accountType | Enum("Personal", "Business") | Should be a dropdown on UI to pick between |
| createdOn | Date | DateTime Picker on UI |
| updatedOn | String | DateTime Picker on UI |
| stripeId | String | |
| active | Boolean |
This table the management UI shouldn't be able to create new records for, only update them. Deleting should not be permitted either(setting active to false will count as being deleted, a manual deleting from the DB is performed for legal requirements).
User Bandwidth Commit
| Column Name | Type | Extra Info |
|---|---|---|
| id | String | UUID. Maps to User("id") field |
| commitMBPS | Integer | Will be megabits per second. Stored as int, but UI should let user input in mbps/gbps (no tbps customers yet.) |
| librenmsURL | String | In the UI, please just make this a box that a user can input into and when they do another box opens up, and should be saved as a string with all the values in the boxes concatenated together and the rest of the URL |
No delete functionality. Setting the active field to false is considered deleting.
Service
| Column Name | Type | Extra Info |
|---|---|---|
| id | String | UUID. Should auto generate a new UUID4 when saving new |
| userId | String | UUID. Maps to User("id") field |
| serviceName | String. Should be searchable by this field | |
| serviceType | ENUM(SEEBELOWFOROPTIONS) | Drop down for one of the service types |
| monthlyCost | Decimal | |
| oneTimeCost | Decimal | |
| createdOn | DateTime | |
| updatedOn | DateTime | |
| nextInvoiceDue | DateTime | Currently unused |
| active | Boolean | On/Off switch on UI |
| stripeId | String |
Service type options: server colocation transit managedService ipv4 ipv6 domain custom
Full CRUD functionality on this one.
Domain
| Column Name | Type | Extra Info |
|---|---|---|
| id | String | UUID. Should auto generate a new UUID4 when saving new |
| serviceID | String | UUID. Maps to Service("id") field. UI should let a existing service be selected or create a new one if none is selected |
| domain | String | User's domain name. Should be searchable by this field |
| dnsOnly | Boolean | On/Off switch |
Full CRUD functionality on this one.
On top of that, ability to search each thing by their id, or name is required. Both backend and frontend need to be created
This is a post created on the open genie platform you can view it best on this user interface: https://genie.peakd.com/@rishi556/create-a-web-based-management-ui-1734127645386