create table ServiceType(
       id number(9) primary key,
       icon varchar2(75) not null,
       title varchar2(20) not null
)

select id, icon, title from servicetype

create table Coach (
       coach_id number(9) primary key,
       company varchar2(50),
       photo varchar2(75),
       avatar varchar2(75),
       nickname varchar(50),
       price number(7,2),
       message varchar(300),
       distance varchar2(20)
)

select coach_id, company, photo, avatar, nickname, price, message, distance from coach

create table Service (
       service_id number(9) primary key,
       subject varchar2(75),
       photo varchar2(100),
       coverpath varchar2(100),
       price number(7,2),
       message varchar2(150),
       recommend varchar2(500),
       detail varchar2(800),
       coatch_id number(9) references coach(coach_id),
       serviceType_id number(9) references serviceType(id)
)

select service_id, subject, photo, coverpath, price, message, recommend, detail, coatch_id, servicetype_id 
from service

create table carousels (
       id number(9) primary key,
       icon varchar(75) not null,
       service_id number(9) references service(service_id)
)