db.txt

-- drop table customers;

-- drop table videos;

-- drop table rental;

create table customers(

  id varchar(10) primary key,

  name varchar(10) not null,

  joinDate char(8) not null

);

insert into customers values('hkd','홍길동','20160201');

insert into customers values('lss','이순신','20160603');

insert into customers values('wg','왕건','20170101');

--select * from customers;

create table videos(

  v_id varchar(10) primary key,

  v_name varchar(10) not null,

  v_type varchar(10) not null,

  v_price number not null -- 대여비

)

insert into videos values('20160001','트랜스포머','SF',1000);

insert into videos values('20160002','라라랜드','드라마',2000);

insert into videos values('20170001','로그원','SF',3000);

-- select * from videos;

create table rental(

  r_id varchar(10) primary key,

  id varchar(10) not null,

  v_id varchar(10) not null,

  rentDate char(8) not null

);

insert into rental values('r0001','hkd','20160001','20161101');

insert into rental values('r0002','lss','20160002','20161201');

insert into rental values('r0003','wg','20170001','20170102');

-- select * from rental;