모닥불

테이블 (28)

booking

  • id — long — 기본 키 — NOT NULL
  • member_id — long — NOT NULL
  • campground_id — long — NOT NULL
  • campsite_id — long — NOT NULL
  • price — int
  • check_in_date — date
  • check_out_date — date
  • booking_status — int
  • id (id2) — long — 외래 키 → campsite.id — NOT NULL
  • id (id3) — long — 외래 키 → campground.id — NOT NULL
  • id (id4) — long — 외래 키 → member.id — NOT NULL

campground

  • id — long — 기본 키 — NOT NULL
  • location_detail_id — int — NOT NULL
  • host_id — long — NOT NULL
  • campground_name — VARCHAR(255) — NOT NULL
  • postcode — VARCHAR(255)
  • address — VARCHAR(255)
  • detail_address — VARCHAR(255)
  • extra_address — VARCHAR(255)
  • approve — int
  • phone — VARCHAR(255)
  • member_id — long — 외래 키 → host.member_id — NOT NULL
  • id (id2) — int — 외래 키 → location_detail.id — NOT NULL

campground_image

  • id — long — 기본 키 — NOT NULL
  • campground_id — long — NOT NULL
  • file_name — VARCHAR(255)
  • save_file_name — VARCHAR(255)
  • iamge_path — VARCHAR(255)
  • image_order — int
  • id (id2) — long — 외래 키 → campground.id — NOT NULL

campground_option

  • id — int — 기본 키 — NOT NULL
  • option_name — VARCHAR(255)

campground_option_link

  • id — long — 기본 키 — NOT NULL
  • campground_suboption_id — int — NOT NULL
  • campground_id — long — NOT NULL
  • is_exist — bool
  • id (id2) — long — 외래 키 → campground.id — NOT NULL
  • id (id3) — int — 외래 키 → campground_suboption.id — NOT NULL

campground_suboption

  • id — int — 기본 키 — NOT NULL
  • campground_option_id — int — NOT NULL
  • option_name — varchar(255)
  • id (id2) — int — 외래 키 → campground_option.id — NOT NULL

campsite

  • id — long — 기본 키 — NOT NULL
  • campground_id — long — NOT NULL
  • campsite_name — VARCHAR(255)
  • campsite_description — VARCHAR(255)
  • head_count — VARCHAR(255)
  • weekday_price — int
  • weekend_price — int
  • campsite_number — int
  • id (id2) — long — 외래 키 → campground.id — NOT NULL

campsite_image

  • id — long — 기본 키 — NOT NULL
  • campsite_id — VARCHAR(255) — NOT NULL
  • file_name — VARCHAR(255)
  • save_file_name — VARCHAR(255)
  • iamge_path — VARCHAR(255)
  • image_order — VARCHAR(255)
  • id (id2) — long — 외래 키 → campsite.id — NOT NULL

campsite_option

  • id — int — 기본 키 — NOT NULL
  • option_name — VARCHAR(255)

campsite_option_link

  • id — long — 기본 키 — NOT NULL
  • campsite_id — long — NOT NULL
  • campsite_suboption_id — int — NOT NULL
  • is_exist — bool
  • id (id2) — long — 외래 키 → campsite.id — NOT NULL
  • id (id3) — int — 외래 키 → campsite_suboption.id — NOT NULL

campsite_price

  • price_date — date — 기본 키 — NOT NULL
  • campsite_id — long — 외래 키 → campsite.id — NOT NULL
  • price — int

campsite_suboption

  • id — int — 기본 키 — NOT NULL
  • campsite_option_id — int — NOT NULL
  • option_name — varchar(255)
  • id (id2) — int — 외래 키 → campsite_option.id — NOT NULL

cancel_reason

  • id — int — 기본 키 — NOT NULL
  • reason — varchar(50)

chat_message

  • id — long — 기본 키 — NOT NULL
  • chat_room_id — long — NOT NULL
  • member_id — long — NOT NULL
  • message — varchar(500)
  • read_status — bool
  • created_at — timestamp

chat_room

  • id — long — 기본 키 — NOT NULL
  • created_at — timestamp
  • campground_id — long — NOT NULL
  • member_id — long — NOT NULL
  • id (id2) — long — 외래 키 → campground.id — NOT NULL

coupon

  • id — int — 기본 키 — NOT NULL
  • coupon_name — varchar(50)
  • coupon_code — varchar(50)
  • discount_amount — int
  • coupon_type — int
  • is_active — bool

freeboard

  • id — long — 기본 키 — NOT NULL
  • member_id — long — NOT NULL
  • title — varchar(100)
  • content — varchar(1000)
  • created_at — timestamp
  • upated_at — timestamp
  • id (id2) — long — 외래 키 → member.id — NOT NULL

freeboard_comment

  • id — long — 기본 키 — NOT NULL
  • parent_id — long — NOT NULL
  • freeboard_id — long — NOT NULL
  • member_id — long — NOT NULL
  • content — varchar(255)
  • created_at — timestamp
  • id (id2) — long — 외래 키 → member.id — NOT NULL
  • id (id3) — long — 외래 키 → freeboard.id — NOT NULL

freeboard_image

  • id — long — 기본 키 — NOT NULL
  • freeboard_id — long — NOT NULL
  • file_name — VARCHAR(255)
  • save_file_name — VARCHAR(255)
  • iamge_path — VARCHAR(255)
  • image_order — VARCHAR(255)
  • id (id2) — long — 외래 키 → freeboard.id — NOT NULL

host

  • member_id — long — 외래 키 → member.id — NOT NULL
  • bank_name — VARCHAR(255)
  • account — VARCHAR(255)
  • account_holder — VARCHAR(255)

location

  • id — int — 기본 키 — NOT NULL
  • sido — VARCHAR(255)

location_detail

  • id — int — 기본 키 — NOT NULL
  • location_id — int — NOT NULL
  • sigungu — VARCHAR(255)
  • id (id2) — int — 외래 키 → location.id — NOT NULL

member

  • id — long — 기본 키 — NOT NULL
  • membership_id — long — NOT NULL
  • user_id — VARCHAR(255)
  • password — varchar(50)
  • user_name — VARCHAR(255)
  • phone — VARCHAR(255)
  • mail — VARCHAR(255)
  • role — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • membership_start_date — date
  • membership_end_date — date
  • provider — varchar(10)
  • id (id2) — int — 외래 키 → membership.id — NOT NULL

member_coupon

  • id — int — 기본 키 — NOT NULL
  • member_id — long — NOT NULL
  • coupon_id — int — NOT NULL
  • is_used — bool
  • used_at — timestamp
  • start_date — timestamp
  • end_date — timestamp
  • id (id2) — long — 외래 키 → member.id — NOT NULL
  • id (id3) — int — 외래 키 → coupon.id — NOT NULL

membership

  • id — int — 기본 키 — NOT NULL
  • membership_name — varchar(255)
  • discount_rate — int

payment

  • id — long — 기본 키 — NOT NULL
  • booking_id — long — NOT NULL
  • member_id — long — NOT NULL
  • member_coupon_id — long — NOT NULL
  • order_number — long — unique
  • amount — int
  • payment_method — varchar(50)
  • payment_status — int
  • payment_date — timestamp
  • approve_date — timestamp
  • payment_tid — varchar(40)
  • id (id2) — int — 외래 키 → member_coupon.id — NOT NULL
  • id (id3) — long — 외래 키 → member.id — NOT NULL
  • id (id4) — long — 외래 키 → booking.id — NOT NULL

payment_cancel

  • id — long — 기본 키 — NOT NULL
  • payment_id — long — 외래 키 → payment.id — NOT NULL
  • cancel_reason_id — int — NOT NULL
  • cancellation_fee — int
  • refund_amount — int
  • canceled_at — timestamp
  • payment_tid — varchar(40)
  • id (id2) — int — 외래 키 → cancel_reason.id — NOT NULL

review

  • booking_id — long — 외래 키 → booking.id — NOT NULL
  • member_id — long — NOT NULL
  • message — VARCHAR(255)
  • rating — int
  • created_at — timestamp