Changes between Version 13 and Version 14 of DDL

Timestamp:

08/28/25 14:43:15 (11 days ago)

Author:

163080

Comment:

--

DDL

@@ -1 +1 @@
 = Entity Sets
 
-- Company(company_id, company_name, company_address, company_vat, company_bank_accounts, company_email, created_at, updated_at)
+- Company(company_id, company_no, company_name, company_representative, company_logo_url, company_address, company_vat, company_bank_accounts, company_email, created_at, updated_at)
 
 - User(user_id, user_name, user_email, password, user_role, company_id, created_at, updated_at)
     *Reference: company_id → Company(company_id)
 
-- Employee(employee_id, employee_name, employee_email, employee_role, employee_status, employee_address, employee_bank_info, employee_cv_ref, employee_photo_ref, company_id, created_at, updated_at)
+- Employee(employee_id, employee_name, employee_email, employee_role, employee_status, employee_address, employee_iban, employee_cv_ref, employee_photo_ref, company_id, created_at, updated_at)
     *Reference: company_id → Company(company_id)
 
@@ -15 +15 @@
     *Reference: company_id → Company(company_id)
 
-- Invoice(invoice_id, invoice_no, invoice_issue_date, invoice_due_date, invoice_notes, invoice_status, company_id, client_id, created_at, updated_at)
+- Invoice(invoice_id, invoice_no, invoice_issue_date, invoice_due_date, invoice_notes, invoice_status, invoice_currency, invoice_taxes, invoice_quantity_type, invoice_discount, invoice_month, invoice_pdf_ref, company_id, client_id, created_at, updated_at)
     *References:
 company_id → Company(company_id)