FOCUS
Now you are ready to add your table to your schema. Create your new table and copy the fields from another table. Listed below are the main fields that are in each table.
| Field Name | Type | Comments |
|---|---|---|
| ID | Text | Indexed, Auto-enter Calculation, Can't Modify Auto, Always Validate, Unique, Allow Override |
| RECORD_ID | Text | Auto-enter Calculation replaces existing value, Can't Modify Auto |
| TIMESTAMP_CREATED | Text | Auto-enter Calculation replaces existing value, Can't Modify Auto |
| CREATED_BY | Text | Auto-enter Calculation replaces existing value, Can't Modify Auto |
| TIMESTAMP_MODIFIED | Text | Auto-enter Calculation replaces existing value, Can't Modify Auto |
| MODIFIED_BY | Text | Auto-enter Calculation replaces existing value, Can't Modify Auto |
| PRIVILEGE_SET_NAME | Text | Auto-enter Calculation replaces existing value, Can't Modify Auto |
| NIC_CREATED | Text | Auto-enter Calculation, Can't Modify Auto |
Now that you have added your new table, you will also see its table occurrence on your graph. Rename that table occurrence with an “ERD_” prefix. Save your work.
You should now have new layout for this new table. Rename the layout to “# ” (yes that is a space after the # symbol). With this new layout, you can go into browse mode and even start entering data.
Comments