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