check in

Tables (68)

Account

  • id — INT — Primary key — NOT NULL
  • provider — VARCHAR(30) — NOT NULL — OAuth 제공자
  • provider_account_id — VARCHAR(300) — NOT NULL — OAuth 계정id
  • Field (name) — VARCHAR(50) — 유저실제이름
  • Field (sex) — VARCHAR(10) — NOT NULL — 유저성별
  • Field (birthday) — DATETIME — 생년월일
  • Field (address) — VARCHAR(300) — 주소
  • Field (profile_image) — VARCHAR(2048) — 프로필사진URL
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (is_admin) — BOOLEAN — NOT NULL — 어드민여부
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (nick_name) — VARCHAR(50) — NOT NULL — 닉네임,uk
  • Field (phone_number) — VARCHAR(50) — NOT NULL — 휴대폰번호,uk
  • Field (email) — VARCHAR(300) — NOT NULL — 이메일
  • Field (agree_mkt_push) — BOOLEAN — NOT NULL — 마케팅 푸시 수신 여부
  • Field (agree_mkt_email) — BOOLEAN — NOT NULL — 마케팅 이메일 수신 여부
  • Field (agree_mkt_sms) — BOOLEAN — NOT NULL — 마케팅 SMS 수신 여부
  • Field (point) — INT — NOT NULL — 소지 포인트

Copy Of Account (AccountArchive)

  • id — INT — Primary key — NOT NULL — pk
  • id (account_id) — INT — Foreign key → Account.id — NOT NULL — 계졍id
  • provider (digest) — VARCHAR(64) — NOT NULL — email다이제스트
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간

Copy Of Copy Of Account (LeaveReason)

  • id — INT — Primary key — NOT NULL — pk
  • id (archive_id) — INT — Foreign key → Copy Of Account.id — NOT NULL — 아카이브id
  • Field (reasons) — VARCHAR(1024) — 선택 이유
  • Field (description) — VARCHAR(1024) — 이유추가설명
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간

Copy Of Copy Of Copy Of Account (Session)

  • id — UUID — Primary key — NOT NULL — pk
  • id (account_id) — INT — Foreign key → Account.id — NOT NULL — 계정id
  • Field (expires_in) — DATETIME — NOT NULL — 만료기간
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간

Copy Of Copy Of Copy Of Account2 (RecentKeyword)

  • id — INT — Primary key — NOT NULL — pk
  • id (account_id) — INT — Foreign key → Account.id — NOT NULL — 계정id
  • Field (keyword) — VARCHAR(1024) — NOT NULL — 검색어
  • Field (from_date) — VARCHAR(50) — NOT NULL — 체크인일
  • Field (to_date) — VARCHAR(50) — NOT NULL — 체크아웃일
  • Field (capacity) — INT — NOT NULL — 인원
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부

Copy Of Copy Of Copy Of Copy Of Account (Property)

  • id — INT — Primary key — NOT NULL — pk
  • Field (onda_id) — INT — NOT NULL — 온다숙소ID
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (name) — VARCHAR(100) — NOT NULL — 숙소이름
  • Field2 (vendor_id) — INT — NOT NULL — 공급사ID
  • Field3 (classifications) — JSON — NOT NULL — 업체분류
  • Field4 (rating) — INT — NOT NULL — ONDA 자체점수
  • Field (email) — VARCHAR(300) — NOT NULL — 숙소이메일
  • Field (phone) — VARCHAR(50) — NOT NULL — 숙소전화번호
  • Field (website) — VARCHAR(2048) — NOT NULL — 숙소홈페이지
  • Field (address) — VARCHAR(300) — NOT NULL — 주소
  • Field (detail_address) — VARCHAR(300) — 상세주소
  • Field (postal_code) — VARCHAR(100) — NOT NULL — 우편번호
  • Field (lat) — DECIMAL(13,10) — NOT NULL — 위도
  • Field (lng) — DECIMAL(13,10) — NOT NULL — 경도
  • Field (checkin) — VARCHAR(100) — NOT NULL — 입실시간
  • Field (checkout) — VARCHAR(100) — NOT NULL — 퇴실시간
  • Field (property_description) — TEXT — 숙소안내
  • Field2 (reservation_description) — TEXT — 예약안내
  • Field (notice_description) — TEXT — 공지안내
  • Field (refund_description) — TEXT — 환불안내
  • Field (refund_percentage) — JSON — 환불퍼센트
  • Field (property_tags) — JSON — 업체 태그
  • Field (facility_tags) — JSON — 구비시설태그
  • Field (service_tags) — JSON — 서비스태그
  • Field (attraction_tags) — JSON — 관광지/테마 태그
  • Field (keywords) — JSON — 키워드
  • Field (business_info) — JSON — 인허가/사업자 정보

Copy Of Copy Of Copy Of Copy Of Account2 (PropertyPhoto1)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부

Copy Of Copy Of Copy Of Copy Of Account3 (AccountBlock)

  • id — INT — Primary key — NOT NULL — pk
  • Field (blocker) — INT — 차단한사람ID
  • Field2 (blocked) — INT — 차단당한사람ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간

Copy Of Copy Of Copy Of Copy Of Copy Of Account2 (PropertyPhoto)

  • id — INT — Primary key — NOT NULL — pk
  • id (property_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Account.id — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (url) — VARCHAR(2048) — NOT NULL — 사진URL
  • Field2 (description) — VARCHAR(300) — 사진설명
  • Field3 (order) — INT — NOT NULL — 사진순서

Copy Of Copy Of Copy Of Copy Of Copy Of Account210 (RateplanDailyStatus)

  • id — INT — Primary key — NOT NULL — pk
  • id (rateplan_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account23.id — NOT NULL — 패키지ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (date) — VARCHAR(50) — NOT NULL — 일자
  • Field (vacancy) — INT — NOT NULL — 판매가능 재고 수
  • Field (base_price) — INT — NOT NULL — 기본가
  • Field (sale_price) — INT — NOT NULL — 판매가
  • Field (extra_adult) — INT — NOT NULL — 성인 추가 비용
  • Field (extra_child) — INT — NOT NULL — 아동 추가 비용
  • Field (extra_infant) — INT — NOT NULL — 유아 추가 비용
  • Field (checkin) — VARCHAR(50) — NOT NULL — 입실 시간
  • Field (checkout) — VARCHAR(50) — NOT NULL — 퇴실 시간
  • Field (min_los) — INT — NOT NULL — 최소 예약 가능 기간
  • Field (max_los) — INT — NOT NULL — 최대 예약 가능 기간 (0=unlimited)
  • Field

Copy Of Copy Of Copy Of Copy Of Copy Of Account211 (PointEvent)

  • id — INT — Primary key — NOT NULL — pk
  • id (account_id) — INT — Foreign key → Account.id — NOT NULL — 계정ID
  • Field (reservation_id) — INT — 예약ID
  • Field (status) — VARCHAR(20) — NOT NULL — 상태(적립,유효기간만료, 사용)
  • Field (amount) — INT — NOT NULL — 변동금액
  • Field (description) — VARCHAR(1000) — NOT NULL — 변동사유
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (effective_to) — DATETIME — NOT NULL — 유효기간 끝

Copy Of Copy Of Copy Of Copy Of Copy Of Account212 (BookingStatusLog)

  • id — INT — Primary key — NOT NULL — pk
  • id (booking_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account29.id — NOT NULL
  • id (id2) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account29.id — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (booking_status) — VARCHAR(100) — NOT NULL — 예약상태 (사용전, 사용중, 사용후, 취소됨)

Copy Of Copy Of Copy Of Copy Of Copy Of Account213 (Coupon)

  • id — INT — Primary key — NOT NULL — pk
  • id (campaign_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account213.id — NOT NULL — 캠페인id
  • id (account_id) — INT — Foreign key → Account.id — 유저id
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (coupon_code) — VARCHAR(100) — NOT NULL — 쿠폰코드(static일 경우 캠페인의 것을 사용.)
  • Field (is_used) — BOOLEAN — NOT NULL — 사용여부
  • Field (used_date) — DATETIME — 사용시점
  • Field (effective_from) — DATETIME — NOT NULL — 쿠폰 유효기간 : 시작 (쿠폰 발급 시점)
  • Field (effective_to) — DATETIME — 쿠폰 유효기간 : 끝

Copy Of Copy Of Copy Of Copy Of Copy Of Account214 (Payment)

  • id — INT — Primary key — NOT NULL — pk
  • id (booking_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account29.id — NOT NULL — 예약id
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (pg) — VARCHAR(30) — PG사
  • Field (pay_method) — VARCHAR(50) — 결제방식 - CODE_TYPE: PAYMETHOD
  • Field (method) — VARCHAR(50) — 결제수단ALIAS(부트페이 method)
  • Field (unit) — VARCHAR(50) — 결제단위
  • Field (receipt_id) — VARCHAR(500) — 영수증ID
  • Field (price) — INT — 결제금액
  • Field (cancel_price) — INT — 취소금액
  • Field (tax_free) — INT — 면세금액
  • Field (remain_tax_free) — INT — 남은 면세금액
  • Field (cancel_tax_free) — INT — 총취소된면세금액
  • Field (req_date) — DATETIME — 결제요청일
  • Field (pay_date) — DATETIME — 결제승인일
  • Field (cancel_date) — DATETIME — 결제취소일
  • Field (phone) — VARCHAR(50) — 결제전화번호
  • Field (card_name) — VARCHAR(50) — 카드사명
  • Field (card_no) — VARCHAR(50) — 카드번호
  • Field (card_quota) — VARCHAR(50) — 할부개월수
  • Field (card_code) — VARCHAR(50) — 카드사코드
  • Field (card_auth) — VARCHAR(50) — 카드승인번호
  • Field (bank_name) — VARCHAR(50) — 은행명(계좌이체, 가상계좌)
  • Field (cash_receipt) — VARCHAR(500) — 현금영수증번호(계좌이체, 가상계좌)
  • Field (v_account_holder) — VARCHAR(50) — 예금주(가상계좌)
  • Field (v_account_number) — VARCHAR(50) — 가상계좌번호(가상계좌)
  • Field (v_expire_date) — VARCHAR(50) — 입금만료시간(가상계좌)
  • Field (v_username) — VARCHAR(50) — 입금자명(가상계좌. 일부 PG는 전달안됨)

Copy Of Copy Of Copy Of Copy Of Copy Of Account215 (Review)

  • id — INT — Primary key — NOT NULL — pk
  • id (booking_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account29.id — NOT NULL — 예약ID
  • id (account_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account29.id — NOT NULL — 유저ID
  • id (rateplan_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account29.id — NOT NULL — 패키지ID
  • id (roomtype_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account29.id — NOT NULL — 객실ID
  • id (property_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account29.id — NOT NULL — 숙소ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (is_best) — BOOLEAN — NOT NULL — 베스트여부
  • Field (description) — VARCHAR(2048) — NOT NULL — 내용
  • Field (is_photo) — BOOLEAN — NOT NULL — 포토리뷰여부
  • Field (like_cnt) — INT — NOT NULL — 좋아요 수
  • Field (comment_cnt) — INT — NOT NULL — 댓글 수
  • Field (sale_cnt) — INT — NOT NULL — 판매 수
  • Field (sale_amount) — INT — NOT NULL — 총 판매 금액
  • Field (rating) — INT — NOT NULL

Copy Of Copy Of Copy Of Copy Of Copy Of Account216 (ReviewPhoto)

  • id — INT — Primary key — NOT NULL — pk
  • id (review_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account215.id — NOT NULL — 리뷰ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (sequence) — INT — NOT NULL — 사진순서
  • Field (URL) — VARCHAR(1000) — NOT NULL — 사진URL

Copy Of Copy Of Copy Of Copy Of Copy Of Account217 (ReviewComment)

  • id — INT — Primary key — NOT NULL — pk
  • id (review_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account215.id — NOT NULL — 리뷰ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (account_id) — INT — NOT NULL — 댓글작성자
  • Field (parent_id) — INT — 부모댓글id
  • Field (like_cnt) — INT — NOT NULL — 댓글좋아요수

Copy Of Copy Of Copy Of Copy Of Copy Of Account218 (ReviewLike)

  • id — INT — Primary key — NOT NULL — pk
  • id (review_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account215.id — NOT NULL — 리뷰ID
  • id (account_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account215.id — NOT NULL — 유저ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부

Copy Of Copy Of Copy Of Copy Of Copy Of Account219 (NotiCampaign)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (content_type) — VARCHAR(50) — NOT NULL — 내용 유형 (info, ad)
  • Field (sender_type) — VARCHAR(50) — NOT NULL — 전송자 유형 (manual, system)
  • Field2 (target_type) — VARCHAR(50) — NOT NULL — 전송대상 유형(all, filter, individual)
  • Field (user_ids) — TEXT — individual 타깃 시 유저 id 목록
  • Field (title) — VARCHAR(100) — 알림 제목
  • Field (description) — VARCHAR(1000) — NOT NULL — 알림 내용
  • Field (link_page_type) — VARCHAR(100) — NOT NULL — 랜딩할 페이지 타입
  • Field (link_page_query) — VARCHAR(2048) — NOT NULL — url query
  • Field (admin_id) — INT — NOT NULL — 만든사람id

Copy Of Copy Of Copy Of Copy Of Copy Of Account22 (Roomtype)

  • id — INT — Primary key — NOT NULL — pk, 객실ID
  • id (property_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Account.id — NOT NULL — 숙소ID
  • Field (sequence) — INT — 객실순서
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (name) — VARCHAR(100) — NOT NULL — 객실이름
  • Field2 (description) — TEXT — 객실설명
  • Field3 (size) — INT — 객실크기(단위:m2)
  • Field4 (standard_capacity) — INT — 기준인원
  • Field5 (max_capacity) — INT — 최대인원
  • Field6 (roomtype_tags) — JSON — 객실태그
  • Field (view_tags) — JSON — 전망태그
  • Field (amenity_tags) — JSON — 구비시설태그
  • Field (room) — INT — 총 방 갯수
  • Field (ondolroom) — INT — 온돌방 수
  • Field (bedroom) — INT — 침대방 수
  • Field (livingroom) — INT — 거실 수
  • Field (kitchen) — INT — 주방 수
  • Field (bathroom) — INT — 화장실 수
  • Field (single_beds) — INT — 싱글침대 수
  • Field (super_single_beds) — INT — 슈퍼 싱글 침대 수
  • Field (double_beds) — INT — 더블 침대 수
  • Field (queen_beds) — INT — 퀸 침대 수
  • Field (king_beds) — INT — 킹 침대 수
  • Field (sofa_beds) — INT — 소파 침대 수
  • Field (air_beds) — INT — 에어 침대 수

Copy Of Copy Of Copy Of Copy Of Copy Of Account220 (HomeComponent)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (admin_id) — id — NOT NULL — 만든 어드민계정
  • Field (is_using) — BOOLEAN — NOT NULL — 현재 사용중 여부
  • Field (title) — VARCHAR(100) — NOT NULL — 타이틀
  • Field (data) — TEXT — NOT NULL — 컴포넌트 데이터

Copy Of Copy Of Copy Of Copy Of Copy Of Account221 (UserSuggestion)

  • id — INT — Primary key — NOT NULL — pk
  • id (account_id) — INT — Foreign key → Account.id — 계정ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (type) — VARCHAR(50) — NOT NULL — 제안유형
  • Field (description) — VARCHAR(50) — NOT NULL — 제안내용

Copy Of Copy Of Copy Of Copy Of Copy Of Account222 (AreaCode)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (address) — VARCHAR(100) — NOT NULL — 주소
  • Field (weather_address) — VARCHAR(100) — 날씨용 주소
  • Field (area_code) — VARCHAR(100) — NOT NULL — 지역코드
  • Field (admin_id) — INT — 어드민계정id
  • Field (region) — VARCHAR(100) — 권역명
  • Field2 (front_key) — VAHCHAR(100) — 앱 상 노출명

Copy Of Copy Of Copy Of Copy Of Copy Of Account223 (Curation)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (admin_id) — INT(11) — NOT NULL — 어드민ID
  • Field2 (title) — VARCHAR(50) — NOT NULL — 제목
  • Field3 (sub_title) — VARCHAR(50) — NOT NULL — 소제목
  • Field (category) — VARCHAR(50) — 카테고리(null = ALL)
  • Field (is_recommend) — BOOL — 추천여부

Copy Of Copy Of Copy Of Copy Of Copy Of Account23 (Rateplan)

  • id — INT — Primary key — NOT NULL — 패키지ID
  • id (roomtype_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account22.id — NOT NULL — 객실ID
  • id (property_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account22.id — NOT NULL — 숙소ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (rateplan_name) — VARCHAR(300) — 패키지 이름
  • Field2 (rateplan_from) — VARCHAR(30) — 노출 시작일. 설정 되어 있을 경우 'yyyy-mm-dd', 상시 노출 및 Room only일 경우 'null'.
  • Field3 (rateplan_to) — VARCHAR(30) — 노출 종료일. 설정 되어 있을 경우 'yyyy-mm-dd', 상시 노출 및 Room only일 경우 'null'.
  • Field4 (rateplan_description) — TEXT — 패키지 설명
  • Field5 (breakfast) — BOOLEAN — 조식 포함 여부. true or false. false 일 경우에도 식사포함 패키지 일 수 있습니다. 정보성으로 활용.
  • Field6 (lunch) — BOOLEAN — 중식 포함 여부. true or false. false 일 경우에도 식사포함 패키지 일 수 있습니다. 정보성으로 활용.
  • Field7 (dinner) — BOOLEAN — 석식 포함 여부. true or false. false 일 경우에도 식사포함 패키지 일 수 있습니다. 정보성으로 활용.
  • Field8 (meal_count) — VARCHAR(100) — 이용가능 인원 수
  • Field (refundable) — BOOLEAN — 환불 가능/불가능 여부
  • Field

Copy Of Copy Of Copy Of Copy Of Copy Of Account24 (Notification)

  • id — INT — Primary key — NOT NULL — pk
  • id (campaign_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account219.id — NOT NULL — 캠페인ID
  • id (account_id) — INT — Foreign key → Account.id — NOT NULL — 계정ID
  • Field (opponent_id) — INT — 상대 id (only SNS)
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (is_clicked) — BOOLEAN — NOT NULL — 알림클릭여부
  • Field (type) — VARCHAR(50) — 1차분류
  • Field2 (sub_type) — VARCHAR(50) — 2차분류
  • Field (title) — VARCHAR(100) — 알림 제목
  • Field (description) — VARCHAR(1000) — NOT NULL — 알림 내용
  • Field (link_page_type) — VARCHAR(50) — 랜딩할 페이지 타입
  • Field (link_page_query) — VARCHAR(2048) — NOT NULL — url query

Copy Of Copy Of Copy Of Copy Of Copy Of Account25 (FAQ)

  • id — INT — Primary key — NOT NULL — pk
  • id (category_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account24.id — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (question) — VARCHAR(300) — NOT NULL — FAQ 질문
  • Field (answer) — TEXT — NOT NULL — FAQ 답변
  • Field (sort) — INT — NOT NULL — FAQ 순서

Copy Of Copy Of Copy Of Copy Of Copy Of Account26 (PropertyWish)

  • id — INT — Primary key — NOT NULL — pk
  • id (account_id) — INT — Foreign key → Account.id — NOT NULL — 계정id
  • id (property_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Account.id — NOT NULL — 숙소id
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부

Copy Of Copy Of Copy Of Copy Of Copy Of Account27 (Event)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (title) — VARCHAR(100) — NOT NULL — 제목
  • Field (sub_title) — VARCHAR(100) — NOT NULL — 소제목
  • Field (img_url) — VARCHAR(2048) — NOT NULL — 이미지 URL
  • Field (link_url) — VARCHAR(2048) — NOT NULL — 링크 URL
  • Field (event_from) — DATETIME — NOT NULL — 적용 시작일
  • Field (event_to) — DATETIME — 적용 종료일 (종료일이 없을 경우 null)

Copy Of Copy Of Copy Of Copy Of Copy Of Account28 (Announcement)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (title) — STRING(300) — NOT NULL — 제목
  • Field (description) — TEXT — NOT NULL — 내용(HTML)
  • Field (category) — VARCHAR(100) — NOT NULL — 카테고리(공지,발표,이벤트)

Copy Of Copy Of Copy Of Copy Of Copy Of Account29 (Booking)

  • id — INT — Primary key — NOT NULL — pk
  • id (account_id) — INT — Foreign key → Account.id — NOT NULL — 유저ID
  • id (rateplan_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account23.id — NOT NULL — 패키지ID
  • id (roomtype_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account23.id — NOT NULL — 객실ID
  • id (property_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account23.id — NOT NULL — 숙소ID
  • id (coupon_id) — VARCHAR(100) — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account213.id — 사용한 쿠폰ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (booking_number) — VARCHAR(100) — NOT NULL — 예약번호(OD11)
  • Field (booking_type) — VARCHAR(100) — NOT NULL — 예약타입(대실,숙박)
  • Field (booking_status) — VARCHAR(100) — NOT NULL — 예약상태 (사용전, 사용중, 사용후, 취소됨)
  • Field (currency) — VARCHAR(50) — NOT NULL — 환종(KRW)
  • Field (checkin_date) — VARCHAR(50) — NOT NULL — 입실날짜/시간
  • Field (checkout_date) — VARCHAR(50) — NOT NULL — 퇴실날짜/시간
  • Field (base_price) — INT — NOT NULL — 기본가격(onda와 동일)
  • Field (total_price) — INT — NOT NULL — 최종판매가격 (total_price + point + coupon 금액 = base_price))
  • Field (guest_name) — VARCHAR(100) — NOT NULL — 입실자이름
  • Field (guest_nationality) — VARCHAR(50) — NOT NULL — 입실자국적
  • Field (guest_adult) — INT — NOT NULL — 입실자 성인 수
  • Field (guest_child_age) — JSON — NOT NULL — 아동,유아 나이
  • Field (booker_name) — VARCHAR(100) — NOT NULL — 예약자 이름
  • Field (booker_email) — VARCHAR(1000) — NOT NULL — 예약자 이메일
  • Field (booker_phone) — VARCHAR(100) — NOT NULL — 예약자 전화번호
  • Field (booker_nationality) — VARCHAR(50) — NOT NULL — 예약자 국적
  • Field (booker_timezone) — VARCHAR(50) — NOT NULL — 예약자 시간대
  • Field (point) — INT — NOT NULL — 사용한 포인트
  • Field (coupon_amount) — INT — NOT NULL — 할인된 쿠폰 금액

Copy Of Copy Of Copy Of Copy Of Copy Of Account3 (PropertyImg)

  • id — INT — Primary key — NOT NULL — pk
  • Field (onda_id) — INT — 숙소ONDAID
  • Field2 (url) — VARCHAR(2048) — URL
  • Field (order) — INT — 노출순서
  • Field (description) — VARCHAR(500) — 설명
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account2 (RoomtypePhoto)

  • id — INT — Primary key — NOT NULL — pk
  • id (roomtype_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account22.id — NOT NULL — 객실ID
  • id (property_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account22.id — NOT NULL — 숙소ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (url) — VARCHAR(2048) — NOT NULL — 사진URL
  • Field2 (description) — VARCHAR(300) — 사진설명
  • Field3 (order) — INT — NOT NULL — 사진순서

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account211 (PointDetail)

  • id — INT — Primary key — NOT NULL — pk
  • id (account_id) — INT — Foreign key → Account.id — NOT NULL — 계정ID
  • id (event_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account211.id — NOT NULL — 포인트이벤트ID
  • Field (status) — VARCHAR(20) — NOT NULL — 상태(적립,유효기간만료, 사용,회수)
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (amount) — INT — NOT NULL — 변동금액
  • Field (increment_id) — INT — NOT NULL — 상세 적립 아이디
  • Field (decrement_id) — INT — NOT NULL — 상세 취소 ID
  • Field (effective_to) — DATETIME — NOT NULL — 유효기간 끝
  • Field (ref_id) — VARCHAR(100) — NOT NULL — 참조 ID

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account213 (CouponCampaign)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (code_type) — VARCHAR(100) — NOT NULL — code 유형 (static, dynamic)
  • Field (date_limit_type) — VARCHAR — NOT NULL — 날짜 제한 타입 (days, datetime)
  • Field (discount_type) — VARCHAR(50) — NOT NULL — 할인유형(정액/정률)
  • Field (name) — VARCHAR(300) — NOT NULL — 캠페인명
  • Field (discount_amount) — INT — 할인금액 - 쿠폰종류가 정액할인인 경우 입력
  • Field (discount_rate) — INT — 할인율 - 쿠폰종류가 정률할인인 경우 입력
  • Field (max_discount) — INT — 최대할인금액 - 쿠폰종류가 정률할인인 경우 입력
  • Field (min_order_amount) — INT — NOT NULL — 최소주문금액
  • Field (effective_from) — DATETIME — NOT NULL — 쿠폰발급가능기간: 시작
  • Field (effective_to) — DATETIME — 쿠폰발급가능기간: 종료
  • Field (limit_count) — INT — NOT NULL — 쿠폰 발급 제한 갯수(0=무제한)
  • Field (reg_admin_id) — INT — NOT NULL — 캠페인 생성한 관리자id
  • Field (update_admin_id) — INT — 캠페인 수정한 관리자id
  • Field (static_coupon_code) — VARCHAR(100) — 정적 쿠폰 코드(발급유형이 static일때만 입력)
  • Field (coupon_usable_days) — INT — 발급 시 사용 가능한 날 수 (지나면 만료됨. 0=무제한)
  • Field (coupon_reg_count) — INT — NOT NULL — 쿠폰 발급 횟수
  • Field (coupon_effective_from) — DATETIME — 쿠폰 유효기한 시작시점
  • Field (coupon_effective_to) — DATETIME — 쿠폰 유효기한 종료지점
  • Field (duplicate_issue_ok) — BOOLEAN — NOT NULL — 쿠폰 동일 유저 중복 발행 가능 여부

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account2132 (MomentKeyword)

  • id — INT — Primary key — NOT NULL — pk
  • id (moment_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account211.id — NOT NULL — 모먼트ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (keyword) — VARCHAR(100) — NOT NULL — 키워드

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account214 (Payment_log)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (pg) — VARCHAR(30) — PG사
  • Field (pay_method) — VARCHAR(50) — 결제방식 - CODE_TYPE: PAYMETHOD
  • Field (method) — VARCHAR(50) — 결제수단ALIAS(부트페이 method)
  • Field (unit) — VARCHAR(50) — 결제단위
  • Field (receipt_id) — VARCHAR(500) — 영수증ID
  • Field (price) — INT — 결제금액
  • Field (cancel_price) — INT — 취소금액
  • Field (tax_free) — INT — 면세금액
  • Field (remain_tax_free) — INT — 남은 면세금액
  • Field (cancel_tax_free) — INT — 총취소된면세금액
  • Field (req_date) — DATETIME — 결제요청일
  • Field (pay_date) — DATETIME — 결제승인일
  • Field (cancel_date) — DATETIME — 결제취소일
  • Field (phone) — VARCHAR(50) — 결제전화번호
  • Field (card_name) — VARCHAR(50) — 카드사명
  • Field (card_no) — VARCHAR(50) — 카드번호
  • Field (card_quota) — VARCHAR(50) — 할부개월수
  • Field (card_code) — VARCHAR(50) — 카드사코드
  • Field (card_auth) — VARCHAR(50) — 카드승인번호
  • Field (bank_name) — VARCHAR(50) — 은행명(계좌이체, 가상계좌)
  • Field (cash_receipt) — VARCHAR(500) — 현금영수증번호(계좌이체, 가상계좌)
  • Field (v_account_holder) — VARCHAR(50) — 예금주(가상계좌)
  • Field (v_account_number) — VARCHAR(50) — 가상계좌번호(가상계좌)
  • Field (v_expire_date) — VARCHAR(50) — 입금만료시간(가상계좌)
  • Field (v_username) — VARCHAR(50) — 입금자명(가상계좌. 일부 PG는 전달안됨)
  • Field (pay_status) — VARCHAR(50) — 결제상태값
  • Field2 (pay_status_msg) — VARCHAR(300) — 결제상태설명

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account218 (ReviewBookmark)

  • id — INT — Primary key — NOT NULL — pk
  • id (review_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account215.id — NOT NULL — 리뷰ID
  • id (account_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account215.id — NOT NULL — 유저ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account22 (LocationWeather)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field3 (region_1depth) — VARCHAR(50) — NOT NULL — ex)서울
  • Field (region_2depth) — VARCHAR(50) — NOT NULL — ex)송파구
  • Field (nx) — INT — NOT NULL — 격자 X (for 단기조회)
  • Field (ny) — INT — NOT NULL — 격자 Y (for 단기조회)
  • Field (land_code) — VARCHAR(50) — NOT NULL — 중기육상예보구역 코드
  • Field (temperature_code) — VARCHAR(50) — NOT NULL — 중기기온예보구역 코드
  • Field (weather) — TEXT — NOT NULL — 날씨 데이터 : Json string
  • Field (lat) — DECIMAL(10,6) — NOT NULL — 위도
  • Field (lng) — DECIMAL(10,6) — NOT NULL — 경도

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account222 (SubwayCode)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (region) — VARCHAR(50) — NOT NULL — 권역명
  • Field (line) — VARCHAR(50) — NOT NULL — 노선명
  • Field (address) — VARCHAR(100) — NOT NULL — 주소
  • Field (name) — VARCHAR(100) — NOT NULL — 역명
  • Field (code) — VARCHAR(100) — NOT NULL — 코드
  • Field (lat) — DECIMAL(10,6) — 위도
  • Field (lng) — DECIMAL(10,6) — 경도
  • Field (admin_id) — INT — 수정한 어드민ID

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account2222 (AreaCodeWish)

  • id — INT — Primary key — NOT NULL — pk
  • id (account_id) — INT — Foreign key → Account.id — NOT NULL — 계정 ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (area_code) — VARCHAR(100) — NOT NULL — 지역코드

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account2223 (CategoryAreaCode)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (area_code) — VARCHAR(100) — NOT NULL — 지역코드
  • Field (admin_id) — INT — 어드민계정id
  • Field (region) — VARCHAR(100) — 권역명
  • Field2 (front_key) — VAHCHAR(100) — 앱 상 노출명
  • Field (category) — VARCHAR(100) — 숙박 카테고리

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account223 (CurationItem)

  • id — INT — Primary key — NOT NULL — pk
  • id (property_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Account.id — NOT NULL — 숙소ID
  • id (curation_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Account223.id — NOT NULL — 큐레이션ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account2232 (PropertyFilter)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (admin_id) — INT(11) — NOT NULL — 어드민ID
  • Field2 (classification) — VARCHAR(50) — NOT NULL — 유형
  • Field3 (data) — VARCHAR(2048) — NOT NULL — 필터json

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account24 (FAQCategory)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (sort) — INT — NOT NULL — 노출순서
  • Field (name) — VARCHAR(100) — NOT NULL — FAQ카테고리명

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account242 (Config)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (key) — VARCHAR(100) — NOT NULL — 키
  • Field2 (value) — VARCHAR(1000) — NOT NULL — 값

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account243 (Device)

  • id — INT — Primary key — NOT NULL — pk
  • id (account_id) — INT — Foreign key → Account.id — 계정 ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (device_unique_id) — VARCHAR(1000) — 디바이스고유ID
  • Field (platform) — VARCHAR(50) — 플랫폼명
  • Field (model) — VARCHAR(100) — 기기모델명
  • Field (os_version) — VARCHAR(100) — 기기OS버전
  • Field (app_version) — VARCHAR(50) — 앱버전
  • Field (token) — VARCHAR(2048) — Firebase 토큰
  • Field (user_agent) — VARCHAR(1000) — 웹 useragent
  • Field (is_disabled_token) — BOOLEAN — 토큰 불능 여부
  • Field (ip) — VARCHAR(100) — ip

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account26 (PropertyViewLog)

  • id — INT — Primary key — NOT NULL — pk
  • id (account_id) — INT — Foreign key → Account.id — NOT NULL — 계정id
  • id (property_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Account.id — NOT NULL — 숙소 onda id
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account28 (question)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (title) — STRING(300) — NOT NULL — 제목
  • Field (description) — TEXT — NOT NULL — 내용
  • Field (category) — VARCHAR(100) — NOT NULL — 카테고리(제안, 취소/환불, 이벤트, 예약/결제, 이용문의, 회원정보, 리뷰, 기타)
  • Field (is_answered) — BOOLEAN — NOT NULL — 답변여부
  • Field (account_id) — BIGINT — NOT NULL — 유저

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account282 (EventPageMap)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (page) — VARCHAR(100) — NOT NULL — 페이지명
  • Field (event_list) — VARCHAR(300) — NOT NULL — event id list

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account211 (Moment)

  • id — INT — Primary key — NOT NULL — pk
  • id (account_id) — INT — Foreign key → Account.id — NOT NULL — 계정ID
  • Field (video_url) — VARCHAR(1000) — NOT NULL — 비디오 URL
  • Field (thumbnail) — VARCHAR(1000) — NOT NULL — 썸네일 URL
  • Field (view) — VARCHAR(100) — NOT NULL — 뷰 타입
  • Field (concept) — VARCHAR(100) — NOT NULL — 컨셉
  • Field (color) — VARCHAR(100) — NOT NULL — 숙소테마컬러
  • Field (partner) — VARCHAR(100) — NOT NULL — 파트너
  • Field (season) — VARCHAR(100) — NOT NULL — 계절
  • Field (title) — VARCHAR(100) — NOT NULL — 모먼트 타이틀
  • Field (location) — VARCHAR(100) — 지역명
  • Field2 (property_id) — INT — 숙소 ID
  • Field (property_name) — VARCHAR(100) — 숙소명
  • Field (is_reservation) — BOOLEAN — NOT NULL — 체크인예약여부
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account2132 (MomentStat)

  • id — INT — Primary key — NOT NULL — pk
  • id (moment_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account211.id — NOT NULL — 모먼트ID
  • Field (like) — INT — NOT NULL — 좋아요 수
  • Field (watch) — INT — NOT NULL — 조회수
  • Field (share) — INT — NOT NULL — 공유수
  • Field (comment) — INT — NOT NULL — 댓글수
  • Field (is_active)
  • Field2 (created_at)
  • Field3 (updated_at)

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account21322 (MomentReport)

  • id — INT — Primary key — NOT NULL — pk
  • id (moment_id) — VARCHAR — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account211.id — NOT NULL — 모먼트ID
  • Field (account_id) — INT — NOT NULL — 유저ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (type) — VARCHAR(100) — NOT NULL — 신고유형
  • Field (description) — VARCHAR(1000) — 내용

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account22 (CoordRegionMap)

  • id — INT — Primary key — NOT NULL — pk
  • id (location_weather_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account22.id — NOT NULL — 지역ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (lat) — DECIMAL(10,6) — NOT NULL — 위도 (소수점 2자리까지)
  • Field (lng) — DECIMAL(10,6) — NOT NULL — 경도 (소수점 2자리까지)

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account222 (SubwayCodeWish)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (account_id) — INT — NOT NULL — 계정ID
  • Field (code) — VARCHAR(100) — NOT NULL — 코드

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account2222 (KeywordRanking)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (ranking) — TEXT — NOT NULL — 랭킹데이터

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account22222 (restaurant)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (category) — VARCHAR(100) — NOT NULL — 카테고리
  • Field (name) — VARCHAR(1000) — NOT NULL — 이름
  • Field (road_addr) — VARCHAR(300) — 도로명주소
  • Field (addr) — VARCHAR(300) — 지번주소
  • Field (phone) — VARCHAR(50) — 휴대폰번호
  • Field (lat) — DECIMAL(10,6) — 위도
  • Field (lng) — DECIMAL(10,6) — 경도
  • Field (naver_url) — VARCHAR(2048) — NOT NULL — 네이버지도 URL
  • Field (is_cafe) — BOOL — NOT NULL — 카페여부

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account22223 (restaurant_img)

  • id — INT — Primary key — NOT NULL — pk
  • id (restaurant_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account22222.id — NOT NULL — 식당 id
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (url) — VARCHAR(2048) — NOT NULL

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account2223 (PremiumProperty)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (property_id) — VARCHAR(100) — NOT NULL — 숙소id
  • Field (bg_url) — VARCHAR(2048) — 배경 이미지 url
  • Field (logo_url) — VARCHAR(2048) — 로고 url
  • Field2 (name) — VAHCHAR(100) — 숙소명
  • Field (roomtype) — VARCHAR(100) — 객실명
  • Field (rateplan) — VARCHAR(100) — 패키지명

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account28 (answer)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (description) — TEXT — NOT NULL — 내용
  • Field (question_id) — INT — NOT NULL — 질문 id
  • Field (admin_id) — INT — NOT NULL — 답변어드민id

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account2132 (MomentComment)

  • id — INT — Primary key — NOT NULL — pk
  • id (moment_id) — VARCHAR(100) — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account211.id — NOT NULL — 모먼트ID
  • id (account_id) — INT — Foreign key → Account.id — NOT NULL — 계정ID
  • Field (parent_id) — INT — NOT NULL — 부모 id(답글)
  • Field (text) — VARCHAR(1000) — NOT NULL — 내용
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field2 (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field3 (is_active) — BOOLEAN — NOT NULL — 삭제여부

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account21322 (MomentCommentStat)

  • id — INT — Primary key — NOT NULL — pk
  • id (moment_comment_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account2132.id — NOT NULL — 댓글id
  • Field (like) — INT — NOT NULL — 좋아요 수
  • Field (reply) — INT — NOT NULL — 답글수

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account213222 (MomentCommentReport)

  • id — INT — Primary key — NOT NULL — pk
  • id (comment_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account2132.id — NOT NULL
  • id (account_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account2132.id — NOT NULL — 계정ID
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (type) — VARCHAR(100) — NOT NULL — 신고유형
  • Field (description) — VARCHAR(1000) — 내용

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account21323 (MomentWatchLog)

  • id — INT — Primary key — NOT NULL — pk
  • id (moment_id) — VARCHAR — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account211.id — NOT NULL — 모먼트ID
  • id (account_id) — INT — Foreign key → Account.id — NOT NULL — 계정 ID
  • Field (is_active)
  • Field2 (created_at)
  • Field3 (updated_at)

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account22 (PropertyTagIconMap)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (name) — VARCHAR(100) — NOT NULL — 태그명
  • Field (icon_url) — VARCHAR(2048) — NOT NULL — 아이콘이미지URL

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account222 (LocationFineDust)

  • id — INT — Primary key — NOT NULL — pk
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (region) — VARCHAR(30) — NOT NULL — 지역명
  • Field (date) — DATETIME — NOT NULL — 예보날짜
  • Field (grade) — VARCHAR(30) — NOT NULL — 예보값

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account28 (answer_img)

  • id — INT — Primary key — NOT NULL — pk
  • id (answer_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account28.id — NOT NULL — 답변id
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (url) — TEXT — NOT NULL — url

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account28 (question_img)

  • id — INT — Primary key — NOT NULL — pk
  • id (question_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Account28.id — NOT NULL — 질문id
  • Field (created_at) — DATETIME — NOT NULL — 생성시간
  • Field (updated_at) — DATETIME — NOT NULL — 수정시간
  • Field (is_active) — BOOLEAN — NOT NULL — 삭제여부
  • Field (url) — TEXT — NOT NULL — url