I have had mixed results (especially when there are a large number of tables and columns) with the following:
### Postgres SQL tables, with their properties:
# Employee(id(uuid), name(text), department_id(uuid))
# Department(id(uuid), name(text), address(text))
# Salary_Payments(id(uuid), employee_id(uuid), amount(number), date(date))
I’ve also seen that sometimes it is better to leave out the data types while sometimes it is worse. Just wondering what other people’s experiences are with this.