addrbook

1 CREATE TABLE contact ( 2 contact_id INTEGER PRIMARY KEY, 3 name, 4 added, 5 notes 6 ); 7 8 -- A contact may have zero or any number of the following: 9 CREATE TABLE email ( contact_id INTEGER, email); 10 CREATE TABLE phone ( contact_id INTEGER, phone); 11 CREATE TABLE url ( contact_id INTEGER, url);