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)))