Changes between Version 6 and Version 7 of DDL

Timestamp:

08/13/25 16:01:57 (7 days ago)

Author:

163080

Comment:

--

DDL

@@ -1 +1 @@
 = Entity Sets
 
-- Company(company_id, company_name, address, vat, company_email, created_at, updated_at)
+- Company(company_id, company_name, company_street, company_city, company_state, company_zip, company_vat, company_email, created_at, updated_at)
 
-- User(user_id, user_name, user_email, password, role, company_id)
+- 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, status, iban, cv, photo, notes, project, company_id)
+- 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)
     *Reference: company_id → Company(company_id)
 
-- Candidate(candidate_id, candidate_name, candidate_email, status, cv, interview_stage, notes, company_id)
+- Candidate(candidate_id, candidate_name, candidate_email, candidate_status, candidate_cv_ref, candidate_stage, candidate_notes, company_id, created_at, updated_at)
     *Reference: company_id → Company(company_id)
 
-- Client(client_id, client_representative, client_email, phone, address, vat, logo, company_id)
+- 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)
     *Reference: company_id → Company(company_id)
 
-- Invoice(invoice_id, from, to, issue_date, due_date, notes, status, company_id, client_id)
+- Invoice(invoice_id, invoice_no, invoice_issue_date, invoice_due_date, invoice_notes, invoice_status, company_id, client_id, created_at, updated_at)
     *References:
 company_id → Company(company_id)
 client_id → Client(client_id)
 
-- LineItem(line_item_id, description, quantity, unit_price, currency, total, invoice_id)
+- LineItem(item_id, description, quantity, unit_price, currency, total, invoice_id)
     Reference: invoice_id → Invoice(invoice_id)
 
-- EmailTemplate(template_id, type, subject, body, company_id)
+- EmailTemplate(template_id, type, subject, body, company_id, created_at, updated_at)
     *Reference: company_id → Company(company_id)
 
@@ -55 +55 @@
 - LineItem_Belongs_To_Invoice(line_item_id, invoice_id)
     References:
-line_item_id → LineItem(line_item_id)
+item_id → LineItem(item_id)
 invoice_id → Invoice(invoice_id)