Revision 6320
Added by Aaron Marcuse-Kubitza about 12 years ago
| README.TXT | ||
|---|---|---|
| 218 | 218 |
Rename the column: ALTER TABLE <table> RENAME <old> TO <new>; |
| 219 | 219 |
Recreate any foreign key for the column, removing CONSTRAINT <name> |
| 220 | 220 |
This resets the foreign key name using the new column name |
| 221 |
Creating a poster of the ERD: |
|
| 222 |
Measure the fractional height of the text onscreen: |
|
| 223 |
Measure the line height (from the bottom of one line to the bottom |
|
| 224 |
of another): 16.3cm/24 lines = 0.679cm |
|
| 225 |
Measure the height of the ERD: 35.4cm*2 = 70.8cm |
|
| 226 |
Zoom in as far as possible |
|
| 227 |
Measure the height of a capital letter: 3.5mm |
|
| 228 |
Measure the line height: 8.5mm |
|
| 229 |
Calculate the text's fraction of the line height: 3.5mm/8.5mm = 0.41 |
|
| 230 |
Calculate the text height: 0.679cm*0.41 = 0.28cm |
|
| 231 |
Calculate the text height's fraction of the ERD height: |
|
| 232 |
0.28cm/70.8cm = 0.0040 |
|
| 233 |
Measure the text height on the *VegBank* ERD poster: 5.5mm = 0.55cm |
|
| 234 |
Calculate the VegBIEN poster height to make the text the same size: |
|
| 235 |
0.55cm/0.0040 = 137.5cm H; *1in/2.54cm = 54.1in H |
|
| 236 |
The ERD aspect ratio is 11 in W x (2*8.5in H) = 11x17 portrait |
|
| 237 |
Calculate the VegBIEN poster width: 54.1in H*11W/17H = 35.0in W |
|
| 238 |
The minimum VegBIEN poster size is 35x54in portrait |
|
| 221 | 239 |
|
| 222 | 240 |
Testing: |
| 223 | 241 |
Mapping process: make test |
Also available in: Unified diff
README.TXT: Schema changes: Added instructions to calculate the minimum VegBIEN poster size (to make the text as least as big as on the VegBank ERD poster), which is 35x54in portrait