Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||||||||
|
|
|
|
Sorry, no photos available for this element of time.
|
|
Notes:
|
On a phone call with Calvin going over page level settings. This is where you take an entire database table and break it into each and every field or column name. We talked about using JSON or a real look-up table. We decided on a normal database table for the settings. Here are some of the table specs: (just ideas) db_setting_id int(10) auto increment key field corp_id int(10) default 1 unsigned db_table_name varchar(100) default null db_field_name varchar(100) default null db_field_type varchar(25) default null - (values like numeric, string, or date - not too techy) db_field_alias varchar (150) default null db_field_show tinyInt(1) default 1 (1=show 0=hide) db_field_required tinyInt(1) default 0 (1=required 0=not required) db_field_default varchar(100) default null db_field_rules_max int(10) default 0 (0=skip - any other number either means a max length or a max number) db_field_rules_min int(10) default 0 (0=skip - any other number either means a min length or a min number) db_field_sort int(10) default 100 (let them manually sort the fields as need) db_field_instructions varchar(255) default null (use for any special verbage and/or instructions) db_field_drop_down varchar(255) default null (this could be a list of items to help load a drop down - example: cat|dog|mouse|horse We would want to index the corp_id and the db_table_name. |