DIRPATHS PathID - INT, NOT NULL, AUTOINC PathName - VARCHAR(16) # Adjust to taste ParentDir - INT # PathID of the parent directory, null for / TABLELIST TableID - INT, NOT NULL, AUTOINC TableName - VARCHAR(16) # Adjust to tase PathID - INT # Linking Field pointing to DIRPATHS # Add'l fields, e.g. Description, LastUpdate, BackedUpOn, etc. FIELDNAMES TableID - INT, NOT NULL # Link to match in TABLELIST FieldNo - INT, NOT NULL, # Field Position Name - VARCHAR(32) # Adjust to taste. # Description and other fields as needed ENTITIES LocalID - INT, NOT NULL, AUTOINC EntityName - VARCHAR(32) # Adjust to need/taste EntityType - ENUMERATED SET (Note: I prefer lookup tables): 0 - directory 1 - table 2 - field 3 - Etc EntityID - INT # ID from the appropriate table listed earlier