Changes between Version 10 and Version 11 of DDL


Ignore:
Timestamp:
08/28/25 13:08:57 (11 days ago)
Author:
163080
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DDL

    v10 v11  
    11= Entity Sets
    22
    3 - Company(company_id, company_name, company_street, company_city, company_state, company_zip, company_vat, company_email, created_at, updated_at)
     3- Company(company_id, company_name, company_address, company_vat, company_bank_accounts, company_email, created_at, updated_at)
    44
    55- User(user_id, user_name, user_email, password, user_role, company_id, created_at, updated_at)
    66    *Reference: company_id → Company(company_id)
    77
    8 - Employee(employee_id, employee_name, employee_email, employee_role, employee_status, employee_street, employee_city, employee_state, employee_zip, employee_iban, employee_bank_name, employee_swift, employee_cv_ref, employee_photo_ref, company_id, created_at, updated_at)
     8- 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)
    99    *Reference: company_id → Company(company_id)
    1010
     
    1212    *Reference: company_id → Company(company_id)
    1313
    14 - Client(client_id, client_name, client_representative, client_email, client_street, client_city, client_state, client_zip, client_vat, client_logo_url, company_id, created_at, updated_at)
     14- Client(client_id, client_name, client_representative, client_email, client_address, client_vat, client_logo_url, company_id, created_at, updated_at)
    1515    *Reference: company_id → Company(company_id)
    1616