CREATE TABLE pet( id NUMBER(11), master_id NUMBER(11) NOT NULL, name NVARCHAR2(50), type_id NUMBER(11) NOT NULL, health NUMBER(11) DEFAULT 100 NOT NULL, love NUMBER(11) DEFAULT 100 NOT NULL, prop1 NVARCHAR2(100), prop2 NVARCHAR2(100), prop3 NVARCHAR2(100), adopt_time DATE NOT NULL, status CHAR(1) DEFAULT 1 NOT NULL, CONSTRAINT pet_pk PRIMARY KEY(id), CONSTRAINT master_fk FOREIGN KEY (master_id) REFERENCES master(id), CONSTRAINT type_fk FOREIGN KEY (type_id) REFERENCES pet_type(id) );
