VDB Documentation

Here i have collected references for myself so that i know what im doing;-)

Diagram:

ER

Work order:
1: Add to Object_ID
2: If not present add Feature
3: Add to obj_feat
4: If not present add Museum
5: If not present add mus_mus
6: If not present add site_feat
7: If not present add Publications
8: If not present add obj_publ
9: Add object to type table
10: If not present add Dating
11: Add to right date method table
12: Goto 1

Log:
20110819 VDB 0.1a
*Created:
-Coindate:Date_ID,Name, max_date, min_date
-Dating: Date_ID, Date_method
-Dendro_date: Date_ID, Wood_type, Lab_name, sample_ID, T_value, Notes
-Feature: Feature_ID, Feature_name, Feature_type
-Museum: MuseumID, mus_name, contact, mus_nation
-ObjectID: Object_ID, Museum_NR, Date update, notes
-Publications: Publication_ID, pub_type, Title, Author, publication_year, Volume, Edition, ISBN
-Radiodate: Date_ID, Lab_name, Lab_ID, Age_BP, Age_cal, date_err
-Rel_chron: Date_ID, Date_type, Chronology, date_max, date_min
-Shield_table: boss_height, boss_diameter, boss_neck, boss_top, boss_flange, boss_type, boss_decorations, boss_material, boss_rivets, handle_length,
handle_width, handle_material, handle_decoration, board_diameter, board_center_thickness, board_edge_thickness, board_material, cover_material,
cover_decoration, Notes, Object_ID, board_decoration.

-Site: Site_ID, Site_name, lon_dec, lat_dec, national_site_ID, Country, County, site_description
-date_obj: Date_ID, Object_ID, dat_obj_ID
-mus_mus: MuseumID, Museum_NR
-obj_feat: obj_feat_ID, Object_ID, Feature_ID
-obj_publ: Object_ID, Publication_ID, objpub_ID
-site_feat: Site_ID, Feature_ID, site_feat_ID

*Fixed:
Coupling postgres-Base

20110820 VDB 0.1.1a
*Created:
-Spear: Object_ID, shead_length, shead_width, shead_weigth, shead_type, shead_decorations, notes
-Shield_table: boss_weight
-Sword: Object_ID, sw_length, sw_weigth, hilt_length, hilt_grip, hilt_type, blade_length, blade_width,
blade_fuller, blade_decoration, blade_type, complete
-Arrows: Object_ID, number, type
-Feature: notes
-Axe: Object_ID, ax_type

TODO
base frontend

Transfer data from old shield DB and shield Norway DB.