

-- Generated by Relational Schema Center on Mon Sep 16 10:16:09 CDT 2002


CREATE TABLE ACCOUNT
  (ACCOUNTNUMBER INTEGER NOT NULL,
   BALANCE REAL NOT NULL,
   TYPE INTEGER NOT NULL,
   ACCOUNTSINVERSE_CUSTOMERNUMBER BIGINT);

ALTER TABLE ACCOUNT
  ADD CONSTRAINT PK_ACCOUNT PRIMARY KEY (ACCOUNTNUMBER);

CREATE TABLE CUSTOMER
  (CUSTOMERNUMBER BIGINT NOT NULL,
   NAME VARCHAR(250),
   TAXID VARCHAR(250));

ALTER TABLE CUSTOMER
  ADD CONSTRAINT PK_CUSTOMER PRIMARY KEY (CUSTOMERNUMBER);