Fit Flamingo | Database

Database structure

• CUSTOMER
  This table contains the data on the regular customers of Print Works.
  • CUSTOMER_ID INTEGER
    The unique identifier of the customer.
  • NAME TEXT
    The name of the customer
  • TAX_ID TEXT
    The tax ID of the company.
  • ADDRESS_STREET TEXT
    The address of the company (street).
  • ADDRESS_NUMBER TEXT
    The address of the company (number).
  • ADDRESS_POSTAL TEXT
    The address of the company (postal code).
  • ADDRESS_CITY TEXT
    The address of the company (city).
• EMPLOYEE
  This table contains the data on the employees of Print Works.
  • EMPLOYEE_ID INTEGER
    The unique identifier of the employee.
  • FIRST_NAME TEXT
    The first name of the employee.
  • LAST_NAME TEXT
    The last name of the employee.
  • DATE_OF_BIRTH DATE
    This is the birth day of the employee, stored as a text representation in the form of YYYY-MM-DD.
• EMPLOYEE_CONTRACT
  This table contains the data on the contracts signed by the employees of Print Works.
  • CONTRACT_ID INTEGER
    The unique identifier of the contract.
  • EMPLOYEE_ID INTEGER
    The identifier of the employee. A single employee can have multiple contracts.
  • CONTRACT_TYPE TEXT
    The type of the contract.
  • POSITION TEXT
    The position held by the employee.
  • BASE_SALARY DECIMAL(10, 2)
    The base monthly salary of the employee.
  • VALID_FROM DATE
    This beginning of the contract.
  • VALID_TO DATE
    This end of the contract. For current contracts, it is 9999-12-31.