Entity Sets

• Company(company_id, company_name, address, vat, company_email, created_at, updated_at)

• User(user_id, user_name, user_email, password, role, company_id)

*Reference: company_id → Company(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, candidate_name, candidate_email, status, cv, interview_stage, notes, company_id)

*Reference: company_id → Company(company_id)

• Client(client_id, client_representative, client_email, phone, address, vat, logo, company_id)

*Reference: company_id → Company(company_id)

• Invoice(invoice_id, from, to, issue_date, due_date, notes, status, company_id, client_id)

*References:

company_id → Company(company_id) client_id → Client(client_id)

• LineItem(line_item_id, description, quantity, unit_price, currency, total, invoice_id)

Reference: invoice_id → Invoice(invoice_id)

• EmailTemplate(template_id, type, subject, body, company_id)

*Reference: company_id → Company(company_id)

Relationship Sets Between Entities

• Employee_Belongs_To_Company(employee_id, company_id)

References:

employee_id → Employee(employee_id) company_id → Company(company_id)

• Candidate_Belongs_To_Company(candidate_id, company_id)

References:

candidate_id → Candidate(candidate_id) company_id → Company(company_id)

• Client_Belongs_To_Company(client_id, company_id)

References:

client_id → Client(client_id) company_id → Company(company_id)

• Invoice_Belongs_To_Client(invoice_id, client_id)

References:

invoice_id → Invoice(invoice_id) client_id → Client(client_id)

• Invoice_Belongs_To_Company(invoice_id, company_id)

References:

invoice_id → Invoice(invoice_id) company_id → Company(company_id)

• LineItem_Belongs_To_Invoice(line_item_id, invoice_id)

References:

line_item_id → LineItem(line_item_id) invoice_id → Invoice(invoice_id)

• User_Belongs_To_Company(user_id, company_id)

References:

user_id → User(user_id) company_id → Company(company_id)

• EmailTemplate_Belongs_To_Company(template_id, company_id)

References:

template_id → EmailTemplate(template_id) company_id → Company(company_id)

DDL скрипта за бришење и креирање на табелите

https://develop.finki.ukim.mk/projects/agency-os/raw-attachment/wiki/DDL/kreiranje.sql

DML скрипта за пополнување на табелите со податоци

https://develop.finki.ukim.mk/projects/agency-os/raw-attachment/wiki/DDL/dodavanje.sql

Relational Diagram