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);