ㅇ
Tables (17)
airport
- airport_num — int(11) — Primary key — NOT NULL
- airport_name — varchar(50) — NOT NULL
- airport_latitude — varchar(30) — NOT NULL
- airport_longitude — varchar(30) — NOT NULL
board_detail_image
- board_image_id — int(11) — Primary key — NOT NULL
- event_num — int(11) — Foreign key → event.event_num
- faq_num — int(11) — Foreign key → faq.faq_num
- notice_num — int(11) — Foreign key → notice.notice_num
- qna_num — int(11)
- qna_answer_num — int(11) — Foreign key → qna_answer.qna_answer_num
- review_num — int(11) — Foreign key → review.review_num
- board_fileName — varchar(200)
- board_reg_id — varchar(20)
- board_fileType — varchar(40)
- board_credate — timestamp
cart
- member_id — varchar(10) — Foreign key → member.member_id — NOT NULL
- goods_code — varchar(12) — Foreign key → goods.goods_code — NOT NULL
- cart_id — int(11) — NOT NULL
- cart_headcount — int(11)
- cart_credate — timestamp — NOT NULL
company
- com_id — varchar(50) — Primary key — NOT NULL — 사업체 아이디
- com_num — int(11) — NOT NULL — 사업체 번호(자동증가)
- com_pw — varchar(50) — NOT NULL — 사업체 비밀번호
- com_name — varchar(50) — NOT NULL — 사업체명
- com_ceo — varchar(20) — NOT NULL — 사업체 대표성함
- com_tel1 — varchar(30) — NOT NULL — 사업체 전화번호
- com_tel2 — varchar(30) — NOT NULL — 사업체 전화번호
- com_tel3 — varchar(30) — NOT NULL — 사업체 전화번호
- com_email — varchar(40) — NOT NULL — 사업체 이메일
- com_crn1 — varchar(13) — NOT NULL — 사업자등록번호
- com_crn2 — varchar(13) — NOT NULL — 사업자등록번호
- com_crn3 — varchar(13) — NOT NULL — 사업자등록번호
- com_email_yn — varchar(5) — NOT NULL — 사업자등록번호 인증 여부
- com_zipcode — varchar(12) — NOT NULL — 사업체 우편번호
- com_road_address — varchar(50) — NOT NULL — 사업체 도로명 주소
- com_local_address — varchar(50) — 사업체 지번 주소
- com_rest_address — varchar(50) — 사업체 나머지 주소
- com_joindate — timestamp — NOT NULL — 사업체 가입일
- com_status — int(11) — NOT NULL — 사업체 상태 1) 가입요청중 2)승인 완료 3) 탈퇴요청 4) 삭제
- com_unregister_date — timestamp
- com_deldate — timestamp
del_goods
- flight_code — int(11)
- hotel_code — int(11)
- rent_code — int(11)
- package_code — int(11)
- com_id — int(11)
del_member
- member_id — int(11)
- com_id — int(11)
event
- com_id — varchar(10) — Foreign key → company.com_id — NOT NULL
- event_num — int(11) — NOT NULL
- event_title — varchar(50) — NOT NULL
- event_content — varchar(500) — NOT NULL
- event_start_date — date — NOT NULL
- event_end_date — date — NOT NULL
- event_write_date — timestamp — NOT NULL
- event_status — int(11) — NOT NULL
- event_category — varchar(10) — NOT NULL
faq
- faq_num — int(11) — NOT NULL
- faq_title — varchar(100) — NOT NULL
- faq_content — varchar(500) — NOT NULL
- faq_write_date — timestamp — NOT NULL
- faq_category — int(11) — NOT NULL
goods
- goods_code — varchar(12) — Primary key — NOT NULL
- com_id — varchar(10) — Foreign key → company.com_id — NOT NULL
- airport_num — int(11) — Foreign key → airport.airport_num
- goods_category — varchar(20) — NOT NULL — 숙박 / 항공 / 렌트 / 패키지
- goods_name — varchar(50)
- package_hotel_name — varchar(50) — 패키지 상품의 호텔 이름
- goods_exp — varchar(2000)
- class_grade — int(11) — 비행기 / 호텔 등급
- goods_location — varchar(255) — NOT NULL
- goods_latitude — varchar(30)
- goods_longitude — varchar(30)
- room_type — varchar(20) — 숙박
- car_model — varchar(20) — 차 모델
- goods_price — int(11) — NOT NULL — 정가
- goods_saleprice — int(20) — NOT NULL — 판매가
- goods_departures — varchar(12)
- goods_departure_date — date
- goods_departure_time — time
- goods_arrivals — varchar(12)
- goods_arrival_date — date
- goods_arrival_time — time
- goods_status — int(11) — NOT NULL
- goods_charge — int(11) — NOT NULL
- goods_mileage — int(11) — NOT NULL
- goods_entered_date — timestamp — NOT NULL
goods_detail_image
- goods_image_id — int(11) — NOT NULL
- goods_code — varchar(10)
- goods_fileName — varchar(50)
- goods_reg_id — varchar(20)
- goods_fileType — varchar(40)
- goods_credate — timestamp
member
- member_id — varchar(50) — Primary key — NOT NULL — 회원 아이디
- member_num — int(11) — NOT NULL — 회원 번호(자동증가)
- member_pw — varchar(50) — NOT NULL — 회원 비밀번호
- member_name — varchar(30) — NOT NULL — 회원 이름
- member_ph1 — varchar(30) — NOT NULL — 회원 핸드폰번호
- member_ph2 — varchar(30) — NOT NULL — 회원 핸드폰번호
- member_ph3 — varchar(30) — NOT NULL — 회원 핸드폰번호
- member_rrn1 — varchar(13) — NOT NULL — 회원 주민등록번호
- member_rrn2 — varchar(13) — NOT NULL — 회원 주민등록번호
- member_email — varchar(30) — NOT NULL — 회원 이메일
- member_email_yn — varchar(5) — NOT NULL — 회원 이메일 인증여부
- member_zipcode — varchar(12) — NOT NULL — 회원 우편번호
- member_road_address — varchar(50) — NOT NULL — 회원 도로명 주소
- member_local_address — varchar(50) — 회원 지번 주소
- member_rest_address — varchar(50) — 회원 나머지 주소
- member_joindate — timestamp — NOT NULL — 회원 가입일
- member_status — int(11) — NOT NULL — 회원 상태 1)가입중 2) 탈퇴요청중 3) 삭제
- member_unregister_date — timestamp
- member_deldate — timestamp
- member_mileage — int(20)
notice
- notice_num — int(11) — NOT NULL
- notice_title — varchar(100) — NOT NULL
- notice_content — varchar(500) — NOT NULL
- notice_write_date — timestamp — NOT NULL
- notice_category — varchar(10) — 1) 일반 2) 안전정보 3) 서비스 4) 당첨자발표
qna
- qna_num — int(11) — Primary key — NOT NULL
- member_id — varchar(10) — Foreign key → member.member_id — NOT NULL
- qna_answer_num — int(11) — Foreign key → qna_answer.qna_answer_num
- good_code — varchar(50) — Foreign key → goods.goods_code
- qna_type — varchar(50)
- qna_title — varchar(50) — NOT NULL
- qna_content — varchar(3000)
- qna_write_date — timestamp — NOT NULL
- qna_status — varchar(50)
- board_fileName — varchar(200)
qna_answer
- member_id — varchar(10) — Foreign key → member.member_id — NOT NULL
- com_id — varchar(10) — Foreign key → company.com_id — NOT NULL
- qna_num — int(11) — Foreign key → qna.qna_num — NOT NULL
- qna_answer_num — int(11) — NOT NULL
- qna_answer_title — varchar(30) — NOT NULL
- qna_answer_content — varchar(500) — NOT NULL
- qna_answer_write_date — timestamp — NOT NULL
reservation
- member_id — varchar(10) — NOT NULL
- goods_code — varchar(12) — Foreign key → goods.goods_code
- order_num — int(11) — NOT NULL
- goods_name — varchar(50)
- goods_category — varchar(50)
- order_date — timestamp
- order_status — int(11)
- pay_status — int(11)
- pay_order_time — timestamp
- goods_saleprice — int(20)
- card_com_name — varchar(50)
- card_pay_month — varchar(50)
- refund_price — int(11)
- total_charge_price — int(11)
- use_mileage — int(11)
- plus_mileage — int(11)
- license_id — varchar(13)
- license_date — varchar(50)
- reser_start_date — datetime
- reser_end_date — datetime
- reser_period — varchar(10) — ex) 1일 8시간
- reser_headcount — int(11)
review
- review_num — int(11) — Primary key — NOT NULL
- member_id — varchar(10) — Foreign key → member.member_id — NOT NULL
- parent_num — int(11)
- goods_code — varchar(12) — Foreign key → goods.goods_code
- review_title — varchar(50) — NOT NULL
- review_content — varchar(500) — NOT NULL
- review_write_date — timestamp — NOT NULL
- imageFileName — varchar(50)
sales
- com_id — varchar(10) — Foreign key → company.com_id — NOT NULL
- member_id — varchar(10) — Foreign key → member.member_id — NOT NULL
- flight_code — varchar(10) — NOT NULL
- hotel_code — varchar(10) — NOT NULL
- package_code — varchar(10) — NOT NULL
- rent_code — varchar(10) — NOT NULL