Changes between Version 10 and Version 11 of ERModel

Timestamp:

08/28/25 12:51:37 (11 days ago)

Author:

163080

Comment:

--

ERModel

@@ -9 +9 @@
 - company_id: Numeric, primary key.
 - company_name: Text, required.
-- company_street: Text, optional.
-- company_city: Text, optional.
-- company_state: Text, optional.
-- company_zip: Text, optional.
-- company_vat: Text, optional.
+- company_address: Json, optional.
+- company_bank_info: Json, optional.
 - company_email: Text, required.
 - created_at: Date, required.
@@ -40 +37 @@
 - employee_role: Text, optional.
 - employee_status: Enum (Active, Inactive, Terminated), required.
-- employee_street: Text, optional.
-- employee_city: Text, optional.
-- employee_state: Text, optional.
-- employee_zip: Text, optional.
-- employee_iban: Text, optional.
-- employee_bank_name: Text, optional.
-- employee_swift: Text, optional.
+- employee_address: Json, optional.
+- employee_bank_info: Json, optional.
 - employee_cv_ref: Text, optional (file path or URL).
 - employee_photo_ref: Text, optional (file path or URL).
@@ -76 +68 @@
 - client_representative: Text, required.
 - client_email: Text, unique, required.
-- client_street: Text, optional.
-- client_city: Text, optional.
-- client_state: Text, optional.
-- client_zip: Text, optional.
+- client_address: Json, required.
 - client_vat: Text, optional.
 - client_logo_url: Text, optional (file path or URL).