VPN: database reorganization plan

17/08/12

Permalink 08:11:21 am, by mholmes, 116 words, 48 views   English (CA)
Categories: Activity log; Mins. worked: 30

VPN: database reorganization plan

I'm just mapping out what I have so far from AC, based on our recent discussions. This will probably change a lot before implementation.

  1. Convert "authors" to "people", so it can also include engravers and illustrators. They will therefore inherit all the fields already available for authors automatically.
  2. Add an "illustrations" table consisting of:
    • id
    • illustration title (if there is one)
    • illustration description
    • medium (MdhStrLookupField)
    • organ
    • vol
    • num
    • page(s)
    • illustrators (one-to-many link to "people" table)
    • engravers (ditto)
    • associated poem(s) (one-to-many link to "poems" table)
    (Possibly also "anonymous" and "unsigned", as we have for the poems?)
  3. Add a one-to-many "illustrations" field to the "poems" table.
  4. Remove the following fields from the "poems" table:
    • illustrator
    • illustrations

Pingbacks:

No Pingbacks for this post yet...

Depts

This blog is for work done for academic departments which does not fall under other categories.

Reports

Categories

June 2013
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
            1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30            

XML Feeds