-- ============================김민영 테이블 ================================
--스터디 카테고리 테이블--
create table study_category(
sc_idx number(5) primary key,
sc_name varchar2(100))
create sequence study_category_idx
-- 카테고리 데이터
insert into study_category values(sc_idx.nextval, '코딩')
insert into study_category values(sc_idx.nextval, '언어')
insert into study_category values(sc_idx.nextval, '학업')
insert into study_category values(sc_idx.nextval, '자격증')
insert into study_category values(sc_idx.nextval, '취업')
--강의 테이블--
create table lecture(
lecture_idx number(5) primary key,
lecture_name varchar2(100),
lecture_lecturer varchar2(100),
lecture_content varchar2(3000),
lecture_like number(5),
lecture_hate number(5),
lecture_date Date,
lecture_file varchar2(200),
sc_idx number(5)
)
create sequence lecture_idx
insert into lecture values(
lecture_idx.nextval,
'뜨개질 기초 기법',
'김민영',
'누구나 따라할 수 있는 뜨개질 기초 영상',
0,0,sysdate,'minyeong.mp4',5)
insert into lecture values(
lecture_idx.nextval,
'크롬 브라우저 200% 활용하기',
'양진유',
'누구나 쉽게 컴퓨터 고수가 될 수 있습니다.',
0,0,sysdate,'jinyu.mp4',3)
insert into lecture values(
lecture_idx.nextval,
'정보처리기사 필기의 비결',
'유준상',
'sqld 완전 합격 ddl, dml, dcl문 완벽정리
1타 강사의 데이터베이스를 준비해보세요',
0,0,sysdate,'junsang.mp4',4)
insert into lecture values(
lecture_idx.nextval,
'홈서버 구축하기',
'양재인',
'제곧네.',
0,0,sysdate,'jaein.mp4',1)
insert into lecture values(
lecture_idx.nextval,
'ai로 만든 행복한 미래',
'양상연',
'ai와 함께하는 미래를 행복하게 상상해보고 같이 만들어가보세요 ai가 미랩니다.(feat. juho lee) ',
0,0,sysdate,'sangyeon.mp4',3)
insert into lecture values(
lecture_idx.nextval,
'급등 코인 추천"이 종목"무조건 간다',
'김성지',
'대한민국 수익률 압도적 1위 강의에 오신걸 환영합니다. 영상이 도움이 되셨다면 좋아요 댓글 필수입니다.',
0,0,sysdate,'seongji.mp4',5)
insert into lecture values(
lecture_idx.nextval,
'Sqld 완전 합격 비결',
'이주호',
'sqld 완전 합격 ddl, dml, dcl문 완벽정리
1타 강사의 데이터베이스를 준비해보세요 ',
0,0,sysdate,'juho.mp4',1)
--강의 싫어요 테이블--
create table lecture_hate(
hate_idx number(5) primary key,
user_idx number(5),
lecture_idx number(5)
)
create sequence lecture_hate_idx
--강의 좋아요 테이블--
create table lecture_like(
like_idx number(5) primary key,
user_idx number(5),
lecture_idx number(5))
create sequence lecture_like_idx
--강의 리뷰 테이블--
create table lecture_review(
review_idx number(5) primary key,
review_title varchar2(50) NOT NULL,
review_content varchar2(3000),
review_score number(5),
review_date Date,
user_idx number(5),
lecture_idx number(5))
create sequence lecture_review_idx
--강의 메모 테이블--
create table lecture_note(
note_idx number(5) primary key,
note_title varchar2(50) NOT NULL,
note_content varchar2(3000),
user_idx number(5),
lecture_idx number(5))
create sequence lecture_note_idx
--멤버십 테이블
create table membership(
membership_idx number(5) primary key,
membership_name varchar2(50))
create sequence membership_idx
insert into membership values(1,'일반')
insert into membership values(2,'프리미엄')
--멤버십 결제 테이블--
create table membership_payment(
payment_idx number(5) primary key,
payNum varchar2(100),
payment_method varchar2(50),
payment_status varchar2(50),
payment_amount number(10),
payment_date Date,
tax_free number(10), --비과세 금액,
end_date Date,
user_idx number(5),
membership_idx number(5))
create sequence membership_payment_idx
--일정 테이블
create table schedule(
schedule_idx number(5) primary key,
s_title varchar2(50),
s_content varchar2(3000),
s_end_date Date,
s_start_date Date,
user_idx number(5),
study_idx number(5)
)
create sequence schedule_idx
--찜 목록
create table wish_list(
wish_idx number(5) primary key,
w_target_type varchar2(50),
w_date Date,
w_target_idx number(5),
user_idx number(5)
)
create sequence wish_list_idx
--마이페이지
CREATE TABLE mypage (
profile_idx NUMBER(5) primary key, -- 기본키 (PK)
user_idx NUMBER(5) UNIQUE NOT NULL, -- 회원 테이블 참조 (FK), Unique
user_intro VARCHAR2(3000), -- 자기소개
profile_img VARCHAR2(1000)) -- 프로필 사진 경로);
CREATE SEQUENCE mypage_idx_seq
-- ============================ 서준범 테이블 ================================
-- study
create table study (
study_idx number (5)primary key,
study_title varchar2(100),
study_content varchar2(3000) ,
study_start_date date,
study_end_date date,
study_current_members number(5),
study_max_members number(5),
study_location_lng double precision,
study_location_lat double precision,
study_addr varchar2(255),
study_upload_img varchar2(200),
sc_idx number(5),
user_idx number (5),
study_begin_date date,
study_total_weeks number(5),
study_status number(1)
)
-- study 시퀀스
create sequence study_idx
-- study_application
create table study_application(
sa_idx number(5) primary key,
sa_intro varchar2(100),
sa_status varchar2(50),
sa_reason varchar2(100),
user_idx number(5),
study_idx number(5),
join_date date,
login_time date,
logout_time date
)
-- study_application 시퀀스
create sequence sa_idx
-- assignment
create table assignment(
a_idx number(5) primary key,
a_title varchar2(100),
a_content varchar2(3000),
a_fname varchar2(250),
a_start_date date,
a_end_date date,
a_weeks number(5),
user_idx number(5),
study_idx number(5)
)
-- assignment 시퀀스
create sequence a_idx
-- assugnment_submit
create table assignment_submit(
as_idx number(5) primary key,
as_content varchar2(3000),
as_fname varchar2(100),
as_status varchar2(50),
as_start_date date,
as_update_date date,
user_idx number(5),
a_idx number(5)
)
-- assugnment_submit 시퀀스
create sequence as_idx
--notifications
create table notifications(
n_idx number(5) primary key,
n_sender_idx number(5),
n_type varchar2(50),
n_title varchar2(100),
n_content varchar2(3000),
n_read varchar2(50),
n_date date,
user_idx number(5)
)
--notifications 시퀀스
create sequence n_idx
-- ============================양상연 테이블 ================================
--멘토링 리뷰--
CREATE TABLE mentoring_review (
review_id NUMBER(5) PRIMARY KEY,
match_id NUMBER(5) NOT NULL,
mentoring_idx NUMBER(5) NOT NULL,
mentee_user_idx NUMBER(5) NOT NULL,
rating NUMBER(2,1),
review_content VARCHAR2(3000),
review_date DATE,);
CREATE TABLE mentoring_skill (
skill_id NUMBER(5) PRIMARY KEY,
skill_name VARCHAR2(50)
);
--멘토링 스킬맵--
CREATE TABLE mentoring_skill_map (
mentoring_idx NUMBER(5) NOT NULL,
skill_idx NUMBER(5) NOT NULL,
);
--멘토링 스케줄--
CREATE TABLE mentoring_schedule (
schedule_id NUMBER(5) PRIMARY KEY,
status VARCHAR2(50) NOT NULL,
mentoring_starttime DATE,
mentoring_endtime DATE,
mentoring_id NUMBER(5) NOT NULL,
);
--멘토링 매치--
CREATE TABLE mentoring_match (
match_id NUMBER(5) PRIMARY KEY,
mentoring_idx NUMBER(5) NOT NULL,
matched_time DATE,
status VARCHAR2(50),
mentor_idx NUMBER(5) NOT NULL,
mentee_user_idx NUMBER(5) NOT NULL,
);
--멘토링 신청--
CREATE TABLE mentoring_application (
ma_id NUMBER(5) PRIMARY KEY,
apply_content VARCHAR2(3000),
status VARCHAR2(50),
reject_reason VARCHAR2(3000),
created_at DATE,
updated_at DATE,
mentoring_idx NUMBER(5) NOT NULL,
mentee_user_idx NUMBER(5) NOT NULL,
);
-멘토링
CREATE TABLE mentoring (
mentoring_idx NUMBER(5) PRIMARY KEY,
mentoring_title VARCHAR2(100),
job_group VARCHAR2(100),
job_role VARCHAR2(100),
career_years NUMBER,
company_name VARCHAR2(100),
contact_phone_public VARCHAR2(100),
contact_email_public VARCHAR2(100),
session_minutes NUMBER,
description VARCHAR2(3000),
pre_notice VARCHAR2(1000),
status VARCHAR2(20),
created_at DATE,
mentor_idx NUMBER(5) NOT NULL,
sc_idx NUMBER(5),
);
-멘토 프로필
CREATE TABLE mento_profile (
mentor_idx NUMBER(5) PRIMARY KEY,
user_idx NUMBER(5) NOT NULL,
mentor_tel VARCHAR2(100),
sc_idx NUMBER(5) NOT NULL,
mentor_intro VARCHAR2(100),
mentor_link VARCHAR2(100),
);
--멘토 관련 테이블 시퀀스 --
CREATE SEQUENCE seq_mento_profile START WITH 1 INCREMENT BY 1 NOCACHE;
CREATE SEQUENCE seq_mentoring START WITH 1 INCREMENT BY 1 NOCACHE;
CREATE SEQUENCE seq_mentoring_application START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE seq_mentoring_match START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE seq_mentoring_schedule START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE seq_mentoring_review START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE SEQ_MENTORING_SKILL;
CREATE SEQUENCE seq_ma_id;
CREATE SEQUENCE mentor_idx;
-- ============================ 유준상 테이블 ================================
-- 1. 역할 테이블 (role)
CREATE TABLE role (
role_idx NUMBER(5) PRIMARY KEY,
role_name VARCHAR2(50) NOT NULL
)
-- 2. 회원 번호 시퀀스 (명세서의 user_idx.nextval 반영)
CREATE SEQUENCE user_idx START WITH 1 INCREMENT BY 1
-- 3. 회원 테이블 (user)
CREATE TABLE usertb(
user_idx NUMBER(5) PRIMARY KEY,
user_id VARCHAR2(50) NOT NULL UNIQUE,
user_pw VARCHAR2(100) NOT NULL,
user_name VARCHAR2(100) NOT NULL,
user_birthdate DATE NOT NULL,
user_tel VARCHAR2(100) UNIQUE NOT NULL,
user_email varchar2(200) UNIQUE NOT NULL,
role_idx NUMBER(5) DEFAULT 2
)
INSERT INTO role VALUES (1, '관리자')
INSERT INTO role VALUES (2, '일반회원')
-- ============================김성지 테이블 ================================
--자주묻는질문 카테고리 테이블 -- (faq_category로 바꿀까?)
create table menu_category(
menu_category_idx number(5),
menu_category_name varchar2(20)
)
--자주묻는질문 카테고리 데이터--
INSERT INTO menu_category (menu_category_idx, menu_category_name) VALUES (1, '예약/결제');
INSERT INTO menu_category (menu_category_idx, menu_category_name) VALUES (2, '환불');
INSERT INTO menu_category (menu_category_idx, menu_category_name) VALUES (3, '시설문의');
INSERT INTO menu_category (menu_category_idx, menu_category_name) VALUES (4, '기타');
--자주묻는질문 테이블--
create table faq(
faq_idx number(5),
menu_category_idx number(5),
faq_title varchar2(100),
faq_content varchar2(3000)
)
create sequence faq_idx
--공지사항 카테고리 테이블--
create table notice_category(
notice_category_idx number(5),
notice_category_name varchar2(20)
)
--공지사항 카테고리 데이터--
INSERT INTO notice_category (notice_category_idx, notice_category_name) VALUES (1, '일반');
INSERT INTO notice_category (notice_category_idx, notice_category_name) VALUES (2, '점검');
INSERT INTO notice_category (notice_category_idx, notice_category_name) VALUES (3, '이벤트');
INSERT INTO notice_category (notice_category_idx, notice_category_name) VALUES (4, '긴급');
--공지사항 테이블 --
create table notice (
notice_idx number(5),
user_idx number(5),
notice_title varchar2(100),
notice_content varchar2(3000),
notice_file varchar2(1000),
notice_writedate date,
notice_category_idx number(5)
)
create sequence notice_idx
--신고 테이블 --
CREATE TABLE report (
report_idx NUMBER PRIMARY KEY,
report_type VARCHAR2(20),
target_idx NUMBER(5),
reporter_idx NUMBER(5),
report_content VARCHAR2(1000),
report_date DATE DEFAULT SYSDATE,
report_status VARCHAR2(20) DEFAULT '대기',
report_photo varchar(100)
)
create sequence report_idx
--문의사항 카테고리 테이블 --
create table inquiry_category(
inquiry_category_idx number(5) PRIMARY KEY,
inquiry_category_name varchar(10)
)
--문의사항 카테고리 데이터 --
INSERT INTO inquiry_category VALUES (1, '스터디');
INSERT INTO inquiry_category VALUES (2, '멘토링');
INSERT INTO inquiry_category VALUES (3, '스터디카페');
INSERT INTO inquiry_category VALUES (4, '강의');
INSERT INTO inquiry_category VALUES (5, 'LMS');
--문의사항 테이블 --
create table inquiry (
inquiry_idx NUMBER(10) PRIMARY KEY,
user_idx NUMBER(5),
inquiry_category_idx NUMBER(5),
inquiry_title VARCHAR2(200),
inquiry_content varchar2(3000),
inquiry_date DATE,
inquiry_status VARCHAR2(20),
inquiry_reply varchar2(3000),
inquiry_reply_date date
)
create sequence inquiry_idx
-- ============================이주호 테이블 ================================
create table studycafe_pay(
paymentId varchar2(100) primary key,
storeId varchar2(100),
orderNamevarchar2(100),
paid number,
user_idx number(5),
pay_method varchar2(100),
pay_status varchar2(50),
statuschangedat timestamp,
paidat timestamp,
totalAmount number,
pgProvider varchar2(100),
vat number,
supply number
)
create table studycafe_reply(
review_idx number primary key,
user_idx number(5),
studycafe_idx number(5),
studycafe_reply varchar2(100),
studycafe_rating double precision,
created_at date
)
create table studycafe_reply_file(
review_file_idx number primary key,
review_idx number,
file_path varchar2(100),
file_type varchar2(50),
file_order number,
created_at date
)
create table studycafe_reservation(
reservation_idx number(10) primary key,
user_idx number(5),
seat_idx number(5),
reservation_starttime timestamp,
reservation_endtime timestamp,
reservation_status varchar2(50),
ticket_idx number(5),
paymentId varchar2(100),
)
create table seat(
seat_idx number(5) primary key,
seat_num varchar2(50),
seat_type varchar2(50),
seat_status varchar2(50),
seat_x double precision,
seat_y double precision,
seat_w double precision,
seat_h double precision,
studycafe_idx number(5)
)
create table studycafe_ticket(
ticket_idx number(5) primary key,
ticket_category_idx number(5),
ticket_amount number UNIQUE NOT NULL,
ticket_name varchar2(100),
ticket_time number,
studycafe_idx number(5)
)
create table ticket_category(
ticket_category_idx number(5),
ticket_category_name varchar2(50)
)
insert into ticket_category values(1,'시간권')
insert into ticket_category values(2,'종일권')
insert into ticket_category values(3,'정기권')
create table studycafe (
studycafe_idx number(5),
studycafe_name varchar2(200),
studycafe_lat double precision,
studycafe_lng double precision,
studycafe_addr varchar2(100)
)
CREATE TABLE studycafe_layout (
layout_idx NUMBER(5) PRIMARY KEY,
studycafe_idx NUMBER(5),
layout_x DOUBLE PRECISION,
layout_y DOUBLE PRECISION,
layout_w DOUBLE PRECISION,
layout_h DOUBLE PRECISION,
layout_type VARCHAR2(50)
);
insert into studycafe_layout values (1, 1, 0, 0, 1200, 10, 'WALL');
insert into studycafe_layout values (2, 1, 0, 790, 1200, 10, 'WALL');
insert into studycafe_layout values (3, 1, 0, 0, 10, 800, 'WALL');
insert into studycafe_layout values (4, 1, 1190, 0, 10, 800, 'WALL');
insert into studycafe_layout values (5, 1, 480, 0, 120, 10, 'DOOR');
insert into studycafe_layout values (6, 1, 700, 560, 12, 70, 'DOOR');
insert into studycafe_layout values (7, 1, 700, 400, 12, 80, 'DOOR');
insert into studycafe_layout values (8, 1, 460, 10, 180, 800, 'HALL');
insert into studycafe_layout values (9, 1, 40, 60, 360, 220, 'ZONE_A');
insert into studycafe_layout values (10, 1, 40, 360, 360, 220, 'ZONE_B');
insert into studycafe_layout values (11, 1, 70, 600, 300, 150, 'ROOM_SMALL');
--seat에 들어가야함
insert into studycafe_layout values (12, 1, 720, 670, 300, 80, 'ROOM');
insert into studycafe_layout values (13, 1, 700, 60, 350, 250, 'SINGLE_ROOM');
INSERT INTO studycafe_layout VALUES
(1, 1, 80, 80, 300, 300, 'ZONE', '일반존 A');
INSERT INTO studycafe_layout VALUES
(2, 1, 800, 80, 300, 300, 'ZONE', '일반존 B');
INSERT INTO studycafe_layout VALUES
(3, 1, 80, 480, 400, 200, 'ROOM', '1인 독방');
INSERT INTO studycafe_layout VALUES
(4, 1, 800, 480, 300, 200, 'GROUP', '스터디룸');
INSERT INTO studycafe_layout VALUES
(5, 1, 500, 50, 200, 80, 'COUNTER', '카운터');
INSERT INTO studycafe_layout VALUES
(100, 1, 0, 0, 1200, 20, 'WALL', '상단벽');
INSERT INTO studycafe_layout VALUES
(101, 1, 0, 760, 1200, 20, 'WALL', '하단벽');
INSERT INTO studycafe_layout VALUES
(102, 1, 0, 0, 20, 800, 'WALL', '좌측벽');
INSERT INTO studycafe_layout VALUES
(103, 1, 1180, 0, 20, 800, 'WALL', '우측벽');
-- seat
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'L01', 70, 90, 40, 40, 'LAPTOP', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'L02', 150, 90, 40, 40, 'LAPTOP', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'L03', 230, 90, 40, 40, 'LAPTOP', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'L04', 310, 90, 40, 40, 'LAPTOP', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'L05', 70, 170, 40, 40, 'LAPTOP', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'L06', 150, 170, 40, 40, 'LAPTOP', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'L07', 230, 170, 40, 40, 'LAPTOP', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'L08', 310, 170, 40, 40, 'LAPTOP', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'A01', 70, 390, 45, 45, 'GENERAL_A', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'A02', 150, 390, 45, 45, 'GENERAL_A', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'A03', 230, 390, 45, 45, 'GENERAL_A', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'A04', 310, 390, 45, 45, 'GENERAL_A', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'A05', 70, 470, 45, 45, 'GENERAL_A', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'A06', 150, 470, 45, 45, 'GENERAL_A', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'A07', 230, 470, 45, 45, 'GENERAL_A', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'A08', 310, 470, 45, 45, 'GENERAL_A', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'B01', 730, 100, 45, 45, 'GENERAL_B', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'B02', 810, 100, 45, 45, 'GENERAL_B', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'B03', 890, 100, 45, 45, 'GENERAL_B', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'B04', 970, 100, 45, 45, 'GENERAL_B', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'B05', 810, 180, 45, 45, 'GENERAL_B', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'B06', 890, 180, 45, 45, 'GENERAL_B', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'S01', 740, 370, 70, 70, 'SINGLE_ROOM', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'S02', 830, 370, 70, 70, 'SINGLE_ROOM', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'S03', 920, 370, 70, 70, 'SINGLE_ROOM', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'S04', 740, 450, 70, 70, 'SINGLE_ROOM', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'S05', 830, 450, 70, 70, 'SINGLE_ROOM', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'S06', 920, 450, 70, 70, 'SINGLE_ROOM', 1, 'FREE');
INSERT INTO seat(seat_idx, seat_num, seat_x, seat_y, seat_w, seat_h, seat_type, studycafe_idx, seat_status) VALUES (seat_idx.nextval, 'R-C', 720, 520, 300, 80, 'ROOM', 1, 'FREE');
-- 스터디 카페 데이터
insert into studycafe(studycafe_idx, studycafe_name, studycafe_lat, studycafe_lng)
values(studycafe_idx.nextval, 'histudy 1호점', 37.5565408655241, 126.91953257283)
INSERT INTO studycafe (studycafe_idx, studycafe_name, studycafe_lat, studycafe_lng, studycafe_addr)
VALUES (1, '하이 스터디카페 2호점', 37.4979, 127.0276, '서울 강남구 테헤란로 123');
INSERT INTO seat VALUES (1, 'A1', 'NORMAL', 'FREE', 100, 110, 40, 40, 2);
INSERT INTO seat VALUES (2, 'A2', 'NORMAL', 'FREE', 160, 110, 40, 40, 2);
INSERT INTO seat VALUES (3, 'A3', 'NORMAL', 'FREE', 220, 110, 40, 40, 2);
INSERT INTO seat VALUES (4, 'A4', 'NORMAL', 'FREE', 280, 110, 40, 40, 2);
INSERT INTO seat VALUES (5, 'A5', 'NORMAL', 'FREE', 100, 180, 40, 40, 2);
INSERT INTO seat VALUES (6, 'A6', 'NORMAL', 'FREE', 160, 180, 40, 40, 2);
INSERT INTO seat VALUES (7, 'A7', 'NORMAL', 'FREE', 220, 180, 40, 40, 2);
INSERT INTO seat VALUES (8, 'A8', 'NORMAL', 'FREE', 280, 180, 40, 40, 2);
INSERT INTO seat VALUES (9, 'A9', 'NORMAL', 'FREE', 100, 250, 40, 40, 2);
INSERT INTO seat VALUES (10, 'A10', 'NORMAL', 'FREE', 160, 250, 40, 40, 2);
INSERT INTO seat VALUES (11, 'A11', 'NORMAL', 'FREE', 220, 250, 40, 40, 2);
INSERT INTO seat VALUES (12, 'A12', 'NORMAL', 'FREE', 280, 250, 40, 40, 2);
INSERT INTO seat VALUES (13, 'B1', 'NORMAL', 'FREE', 830, 110, 40, 40, 2);
INSERT INTO seat VALUES (14, 'B2', 'NORMAL', 'FREE', 890, 110, 40, 40, 2);
INSERT INTO seat VALUES (15, 'B3', 'NORMAL', 'FREE', 950, 110, 40, 40, 2);
INSERT INTO seat VALUES (16, 'B4', 'NORMAL', 'FREE', 1010, 110, 40, 40, 2);
INSERT INTO seat VALUES (17, 'B5', 'NORMAL', 'FREE', 830, 180, 40, 40, 2);
INSERT INTO seat VALUES (18, 'B6', 'NORMAL', 'FREE', 890, 180, 40, 40, 2);
INSERT INTO seat VALUES (19, 'B7', 'NORMAL', 'FREE', 950, 180, 40, 40, 2);
INSERT INTO seat VALUES (20, 'B8', 'NORMAL', 'FREE', 1010, 180, 40, 40, 2);
INSERT INTO seat VALUES (21, 'B9', 'NORMAL', 'FREE', 830, 250, 40, 40, 2);
INSERT INTO seat VALUES (22, 'B10', 'NORMAL', 'FREE', 890, 250, 40, 40, 2);
INSERT INTO seat VALUES (23, 'B11', 'NORMAL', 'FREE', 950, 250, 40, 40, 2);
INSERT INTO seat VALUES (24, 'B12', 'NORMAL', 'FREE', 1010, 250, 40, 40, 2);
INSERT INTO seat VALUES (25, 'R1', 'ROOM', 'FREE', 120, 520, 60, 60, 2);
INSERT INTO seat VALUES (26, 'R2', 'ROOM', 'FREE', 200, 520, 60, 60, 2);
INSERT INTO seat VALUES (27, 'R3', 'ROOM', 'FREE', 280, 520, 60, 60, 2);
INSERT INTO seat VALUES (28, 'R4', 'ROOM', 'FREE', 360, 520, 60, 60, 2);
INSERT INTO seat VALUES (29, 'STUDY1', 'GROUP', 'FREE', 860, 520, 200, 120, 2);
create sequence review_idx
create sequence review_file_idx
create sequence seat_idx
create sequence studycafe_idx
create sequence studycafe_ticket_idx
create sequence reservation_idx