search

cohoe / starrs

System Technology Accounting and Resource Registration Solution
grantcohoe.com/projects/starrs
Other
16 stars 6 forks source link

Restructure Code #137

Closed cohoe closed 12 years ago

cohoe commented 12 years ago

Group things by entities:

systems.interfaces
-Table
-Constraints
-Triggers
-API
dns.a
-Table
-Constraints
-Triggers
-API
cohoe commented 12 years ago

Should help eliminate pointless functions that have no purpose anymore.

cohoe commented 12 years ago

Each object should have an API call for "CREATE","MODIFY","REMOVE","GET" that is based on a unique key from the table (not necessarily the PK)

cohoe commented 12 years ago

Files: Schema-level Files

Setup.sql - Setup

Object-level Files

DB.sql - Tables, Constraints, Privileges, Types
Triggers.sql - Triggers and their function definitions
API.sql - CREATE,MODIFY,REMOVE,GET
Populate.sql - Base
README.md
cohoe commented 12 years ago

Utility functions go under Schema-level files (API.sql)