Changes between Version 5 and Version 6 of DDL

Timestamp:

02/07/25 17:34:37 (2 weeks ago)

Author:

163080

Comment:

--

DDL

@@ -1 +1 @@
 = Entity Sets
 
-- Company(company_id, name, address, vat, email, created_at, updated_at)
+- Company(company_id, company_name, address, vat, company_email, created_at, updated_at)
 
-- User(user_id, name, email, password, role, company_id)
+- User(user_id, user_name, user_email, password, role, company_id)
     *Reference: company_id → Company(company_id)
 
-- Employee(employee_id, name, email, status, iban, cv, photo, notes, project, company_id)
+- Employee(employee_id, employee_name, employee_email, status, iban, cv, photo, notes, project, company_id)
     *Reference: company_id → Company(company_id)
 
-- Candidate(candidate_id, name, email, status, cv, interview_stage, notes, company_id)
+- Candidate(candidate_id, candidate_name, candidate_email, status, cv, interview_stage, notes, company_id)
     *Reference: company_id → Company(company_id)
 
-- Client(client_id, name, representative, email, phone, address, vat, logo, company_id)
+- Client(client_id, client_representative, client_email, phone, address, vat, logo, company_id)
     *Reference: company_id → Company(company_id)