Multiple contacts per client #22

New issue

Closed

opened 2021-11-22 08:59:06 +00:00 by jonasclaes · 2 comments

jonasclaes commented

2021-11-22 08:59:06 +00:00

(Migrated from github.com)

The client requested to be able to enlist multiple contacts for a given client. This should include the person's name, role (Manager, IT Admin, Financial manager, etc.), email and phone number.

jonasclaes commented

2021-11-23 08:47:32 +00:00

(Migrated from github.com)

To be changed:

Table: clients
- Remove contactEmail
- Remove contactPhoneNumber
Table: clientContacts (new)
- Structure:
  - id
  - clientId FK
  - firstName varchar255
  - lastName varchar255
  - role varchar255
  - email varchar255
  - phoneNumber varchar30
Clients page must show all of the contacts
Files page must show all of the contacts

To be changed: - Table: clients - Remove contactEmail - Remove contactPhoneNumber - Table: clientContacts (new) - Structure: - id - clientId FK - firstName varchar255 - lastName varchar255 - role varchar255 - email varchar255 - phoneNumber varchar30 - Clients page must show all of the contacts - Files page must show all of the contacts

jonasclaes commented

2021-12-02 15:35:12 +00:00

(Migrated from github.com)

Fixed in 5bb7e85ddd.

Fixed in 5bb7e85ddd7b95d5842d218f0c2727971a641216.