asd

Tables (14)

coupon

  • discount_limit — numeric(38,2)
  • discount_price — numeric(38,2)
  • discount_rate — double
  • is_registered — boolean
  • is_valid — boolean
  • minimum_price — numeric(38,2)
  • validity_end_date — date
  • validity_start_date — date
  • created_date — timestamp(6)
  • id — bigint — NOT NULL
  • modified_date — timestamp(6)
  • room_id — bigint
  • description — character
  • name — character
  • region — character
  • room_type — character
  • RENT::character — varying
  • ALL::character — varying)::text)))

main_region

  • created_date — timestamp(6)
  • id — bigint — NOT NULL
  • modified_date — timestamp(6)
  • name — character

member

  • promotional_consent — boolean
  • id — bigint — NOT NULL
  • email — character
  • nick_name — character
  • phone_number — character
  • provider — character
  • provider_id — character

member_coupon

  • is_used — boolean
  • coupon_id — bigint
  • created_date — timestamp(6)
  • id — bigint — NOT NULL
  • member_id — bigint
  • modified_date — timestamp(6)

place

  • created_date — timestamp(6)
  • id — bigint — NOT NULL
  • modified_date — timestamp(6)
  • sub_region_id — bigint
  • address — character
  • category — character
  • description — character
  • event — character
  • name — character
  • thumbnail_image_url — character
  • PENSION_VILLA::character — varying
  • MOTEL::character — varying)::text)))

place_image

  • id — bigint — NOT NULL
  • place_id — bigint — NOT NULL
  • image_url — character

purchase

  • price — numeric(38,2)
  • created_date — timestamp(6)
  • id — bigint — NOT NULL
  • modified_date — timestamp(6)
  • reservation_id — bigint
  • payment_status — character
  • COMPLETED::character — varying
  • CANCELED::character — varying)::text)))

reservation

  • end_date — date
  • start_date — date
  • created_date — timestamp(6)
  • id — bigint — NOT NULL
  • member_id — bigint
  • modified_date — timestamp(6)
  • room_id — bigint
  • reservation_status — character
  • reserve_number — character
  • CANCEL::character — varying)::text)))

review

  • cleanliness_rate — double
  • convenience_rate — double
  • kindness_rate — double
  • location_rate — double
  • total_rate — double
  • created_date — timestamp(6)
  • id — bigint — NOT NULL
  • member_id — bigint
  • modified_date — timestamp(6)
  • place_id — bigint
  • room_id — bigint
  • content — character

review_image

  • id — bigint — NOT NULL
  • review_id — bigint — NOT NULL
  • image_url — character

room

  • capacity — integer
  • total_room_count — integer
  • weekday_check_in_time — time(6)
  • weekday_check_out_time — time(6)
  • weekday_rent_end_time — time(6)
  • weekday_rent_price — integer
  • weekday_rent_start_time — time(6)
  • weekday_rent_time — time(6)
  • weekday_stay_price — integer
  • weekend_check_in_time — time(6)
  • weekend_check_out_time — time(6)
  • weekend_rent_end_time — time(6)
  • weekend_rent_price — integer
  • weekend_rent_start_time — time(6)
  • weekend_rent_time — time(6)
  • weekend_stay_price — integer
  • created_date — timestamp(6)
  • id — bigint — NOT NULL
  • modified_date — timestamp(6)
  • place_id — bigint — NOT NULL
  • category — character
  • name — character
  • thumbnail_image — character

room_image

  • id — bigint — NOT NULL
  • room_id — bigint — NOT NULL
  • image_url — character

sub_region

  • created_date — timestamp(6)
  • id — bigint — NOT NULL
  • main_region_id — bigint
  • modified_date — timestamp(6)
  • name — character

theme

  • id — bigint — NOT NULL
  • place_id — bigint
  • type — character
  • POOL::character — varying
  • PET::character — varying
  • BARBEQUE::character — varying
  • BREAKFAST::character — varying
  • KIDS::character — varying
  • PARKING::character — varying
  • OTT::character — varying
  • PARTY_ROOM::character — varying
  • MIRROR::character — varying
  • KARAOKE::character — varying
  • GAME::character — varying
  • WIFI::character — varying
  • MEDICINE::character — varying
  • BATH::character — varying
  • KITCHEN::character — varying)::text)))