1CREATE DATABASE numismatics;
2CREATE TABLE coin (cid INT(8) PRIMARY KEY,
3                       unit VARCHAR(20),
4                       value NUMERIC(8,2),
5                       mintage_year INT(8),
6                       mint_id INT(8),
7                       CONSTRAINT mint_id_fk FOREIGN KEY(id)
8                           REFERENCES mint(mid));
9
10CREATE TABLE mint (mid INT(8) PRIMARY KEY,
11       country VARCHAR(20),
12       city VARCHAR(20));   --+ DBTYPE = HASH
13
14