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.     |
| email     | 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<br><br>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