cs304_sql_v2

SQL> start cs304_project_tables_v2

Table created.

CREATE TABLE VehicleType (
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


    vstatus VARCHAR2(200) CHECK (vstatus IN ("for_sale","for_rent")),
                                                                    *
ERROR at line 9:
ORA-02438: Column check constraint cannot reference other columns


CREATE TABLE EquipType (
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


    estatus VARCHAR2(200) CHECK (estatus IN ("available","rented","not_available")),
                                                                                   *
ERROR at line 4:
ORA-02438: Column check constraint cannot reference other columns


    CONSTRAINT fk_etname FOREIGN KEY (etname) REFERENCES EquipType(etname),
               *
ERROR at line 5:
ORA-02264: name already used by an existing constraint



Table created.

		cellphone VARCHAR1(200),
		                  *
ERROR at line 2:
ORA-00907: missing right parenthesis


CREATE TABLE TimePeriod (
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


CREATE TABLE Reservation (
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


CREATE TABLE ReserveIncludes (
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



Table created.

    CONSTRAINT fk_card FOREIGN KEY (cardNo) REFERENCES CreditCard(cardNo),
                                    *
ERROR at line 13:
ORA-02267: column type incompatible with referenced column type


    CONSTRAINT fk_rent FOREIGN KEY (rid) REFERENCES Rent(rid),
                                                    *
ERROR at line 5:
ORA-00942: table or view does not exist


    fulltank VARCHAR2(1) CHECK (available IN ('T','F')),
                                                       *
ERROR at line 6:
ORA-02438: Column check constraint cannot reference other columns


SQL>