module_configuration

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
module_config_id	INT UNSIGNED	10		√	null

|

| | | module_id | INT UNSIGNED | 10 | | | null |

|

| | | field_name | VARCHAR | 45 | | | null |

|

| | | field_value | VARCHAR | 255 | | | null |

|

| | | created_by | BIGINT | 19 | √ | | NULL |

|

|

users.id the user that first created this record

| | date_added | DATETIME | 19 | √ | | NULL |

|

|

Datetime the record was initially created

| | updated_by | BIGINT | 19 | √ | | NULL |

|

|

users.id the user that last modified this record

| | date_modified | DATETIME | 19 | √ | | current_timestamp() |

|

|

Datetime the record was last modified

| | date_created | DATETIME | 19 | √ | | NULL |

|

|

Datetime the record was created

|

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	module_config_id

Relationships

Close relationships within degrees of separation