added full postgres schema for the backend implementation
documentation: patterns and postgres