drop table B_TYPE cascade constraints;
drop table BOAT cascade constraints;
drop table SAILOR cascade constraints;
drop table CUSTOMER cascade constraints;
drop table REG_LINE cascade constraints;
drop table REG_LINE_REL cascade constraints;
drop table REG_LINE_REL_COVER cascade constraints;
drop table RESERVATION cascade constraints;
drop table SAIL_WITH_GUIDE cascade constraints;

create table B_TYPE (
	TYPE  VARCHAR2(20),
	C_CAPACITY   NUMBER(4),
	CAPACITY  NUMBER(4),
	M_SPEED  NUMBER(4));

create table BOAT (
	BID  NUMBER(3),
	BNAME  VARCHAR2(20) not null,
	BTYPE  VARCHAR2(20),
	COLOR  VARCHAR2(20));

create table SAILOR (
	SID  NUMBER(3),
	SNAME  VARCHAR2(20) not null,
	AGE  NUMBER(3),
	RATE  NUMBER(2));

create table CUSTOMER (
	CID  NUMBER(3),
	CNAME  VARCHAR2(20));

create table REG_LINE (
	LID  NUMBER(3),
	STRT  VARCHAR2(20),
	DEST  VARCHAR2(20));

create table REG_LINE_REL (
	LID  NUMBER(3) ,
	RID  NUMBER(3),
	LTIME DATE);

create table REG_LINE_REL_COVER (
	LID  NUMBER(3),
	RID  NUMBER(3),
	COV_DATE  DATE,
	BID  NUMBER(3),
	SID  NUMBER(3));

create table RESERVATION (
	BID  NUMBER(3),
	SID  NUMBER(3),
	RES_DATE  DATE);

create table SAIL_WITH_GUIDE (
	CID  NUMBER(3),
	BID  NUMBER(3),
	SID  NUMBER(3),
	SAIL_DATE  DATE);