It would be great to have a data dictionary section where all the “root” columns can be defined for consistency and ability to cascade changes quickly. For eg.
dictionary dict {
id varchar(25) [Note: ’ All primary key Ids will be 25 chars’]
name varchar(30)
create_date datetime [default: ‘now()’]
}
table names {
id dict.id
name dict.name
crt_dt dict.create_date
}