ㅇ

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