TUPLE: manufacturer id name ;

TUPLE: color id name ;

TUPLE: car id manufacturer-id color-id year model ;

PERSISTENT: car {
    COLUMN{ { id "foooid" } { INTEGER } { NOT-NULL SERIAL PRIMARY-KEY } }
    COLUMN{ manufacturer-id R{ manufacturer id } 
    COLUMN{ year INTEGER }
    COLUMN{ model VARCHAR }
}

RELATION: car.manufacturer-id manufacturer.id
DEFAULT-RELATION: car manufacturer

RELATION: car.color-id color.id
DEFAULT-RELATION: car color




TUPLE: person id name ;

TUPLE: group id name ;

TUPLE: person-group person-id group-id ;


PERSISTENT: person "person" {
	DEFAULT-ID
	COLUMN{ name { VARCHAR 256 } }
}
PERSISTENT: group "group" {
	DEFAULT-ID
	COLUMN{ name { VARCHAR 256 } }
}

PERSISTENT: person-group {
         COLUMN{ person-id R{ person id } }
         COLUMN{ group-id R{ group id } }
         INDEX{ { person-id group-id } PRIMARY-KEY }
}