Having seen how the tables are related together, and the fields that are used to do that, we can now look at the other fields that make up each table. Each table definition contains:
Field name
Field type, width and any additional information (such as auto_increment)
If a null value is allowed
Index details—this will either be PRI—primary index, or MUL—duplicate entries allowed
The default value
Field Name |
Field Type |
Null Allowed |
Index |
Default Value |
---|---|---|---|---|
id |
char(36) |
PRI | ||
date_entered |
datetime |
0000-00-00 00:00:00 | ||
date_modified |
datetime |
0000-00-00 00:00:00 | ||
modified_user_id |
char(36) | |||
assigned_user_id |
char(36) |
YES |
NULL | |
created_by |
char(36) |
YES |
NULL | |
name |
varchar(150) |
YES |
NULL | |
parent_id |
char(36) |
YES |
MUL |
NULL |
account_type |
varchar(25) |
YES |
NULL | |
industry |
varchar(25) |
YES |
NULL | |
annual_revenue |
varchar(25) |
YES |
NULL | |
phone_fax |
varchar(25) |
YES |
NULL | |
billing_address_street |
varchar(150) |
YES |
NULL | |
billing_address_city ... |