simplerecordingstable.ddl

来自「此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作」· DDL 代码 · 共 14 行

drop table RECORDINGS;

drop sequence RECORDINGS_SEQ;

create table RECORDINGS (
        RECORDING_ID INT not null,
        RECORDING_TITLE VARCHAR2(50) not null,
        RECORDING_ARTIST VARCHAR2(50) not null,
        CATALOG_NUMBER VARCHAR2(20) not null,
        LIST_PRICE DECIMAL(7,2) not null, 
        VERSION INT not null, 
        constraint RECORDINGS_PK primary key (RECORDING_ID) ); 

create sequence RECORDINGS_SEQ;