Changes between Version 13 and Version 14 of ERModel

Timestamp:

08/28/25 14:35:23 (11 days ago)

Author:

163080

Comment:

--

ERModel

@@ -3 +3 @@
 = Entities
 
-= 1. Company (Tenant)
+= 1. Tenant (Company)
 Represents the company/tenant in the system.
 
@@ -9 +9 @@
 - company_id: Numeric, primary key.
 - company_name: Text, required.
+- company_no: Integer, required.
 - company_address: Json, optional.
-- company_bank_info: Json, optional.
+- company_phone_number: Text, optional.
+- company_vat: Text, optional.
+- company_logo_url: Text, optional.
+- company_bank_accounts: Json, optional.
+- company_representative: Text, optional.
 - company_email: Text, required.
+- company_last_invoice_number: Text, required.
 - created_at: Date, required.
 - updated_at: Date, required.
@@ -22 +28 @@
 - user_name: Text, required.
 - user_email: Text, unique, required.
-- password: Text, required.
 - user_role: Enum (Admin, HR, Finance Manager), required.
 - company_id: Foreign key to Company.
@@ -85 +90 @@
 - invoice_notes: Text, optional.
 - invoice_status: Enum (Draft, Pending, Paid, Overdue), required.
+- invoice_currency: Enum (EUR, USD).
+- invoice_taxes: Decimal, optional.
+- invoice_discount: Integer, optional.
+- invoice_month: Text, required.
+- invoice_pdf_red: Text, required.
+- invoice_total_amount: Decimal, required.
 - company_id: Foreign key to Company.
 - client_id: Foreign key to Client.