test
Tables (38)
champions_badge
- storeCode — character — Primary key — NOT NULL — 아이디
- startGardeImageUrl — character — NOT NULL — 뱃지
- halfGardeImageUrl — character — NOT NULL — 뱃지
- endGardeImageUrl — character — NOT NULL — 뱃지
- title — character — NOT NULL — 뱃지
- description — character — NOT NULL — 설명
- grade — champions_badge_grade_enum — NOT NULL — 현재
chmapions_badge
- storeCode — character — Primary key — NOT NULL — 아이디
- title — character — NOT NULL — 뱃지
- description — character — NOT NULL — 설명
- startGardeImageUrl — character — NOT NULL — 뱃지
- halfGardeImageUrl — character — NOT NULL — 뱃지
- endGardeImageUrl — character — NOT NULL — 뱃지
- grade — chmapions_badge_grade_enum — NOT NULL — 현재
common_event
- id — integer — Primary key — NOT NULL
- title — character — NOT NULL — 제목
- content — text — NOT NULL — 내용
- writer — character — NOT NULL — 작성자
- isActive — boolean — NOT NULL — 활성화
- viewCount — integer — NOT NULL — 조회수
- startDate — date — NOT NULL — 시작일
- endDate — date — NOT NULL — 종료일
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- isExpose — boolean — NOT NULL — 공개
- thumbnail — character — 미리보기
common_faq
- id — integer — Primary key — NOT NULL
- title — character — NOT NULL — 제목
- content — text — NOT NULL — 내용
- writer — character — NOT NULL — 작성자
- isActive — boolean — NOT NULL — 활성화
- isExpose — boolean — NOT NULL — 공개
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- categoryId — integer
common_faq_category
- id — integer — Primary key — NOT NULL
- title — character — NOT NULL — 카테고리
- parentId — integer
common_notice
- id — integer — Primary key — NOT NULL
- content — text — NOT NULL — 내용
- writer — character — NOT NULL — 작성자
- isActive — boolean — NOT NULL — 활성화
- viewCount — integer — NOT NULL — 조회수
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- isFix — boolean — NOT NULL — 고정
- isExpose — boolean — NOT NULL — 공개
- title — character — NOT NULL — 제목
common_terms
- id — integer — Primary key — NOT NULL
- title — character — NOT NULL — 제목
- content — text — NOT NULL — 내용
- writer — character — NOT NULL — 작성자
- isActive — boolean — NOT NULL — 활성화
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- isExpose — boolean — NOT NULL — 공개
- categoryId — integer
common_terms_category
- id — integer — Primary key — NOT NULL
- title — character — NOT NULL — 제목
- isExpose — boolean — NOT NULL — 공개여부
coupon
- couponNo — character — Primary key — NOT NULL — 랜덤
- startDate — date — NOT NULL — 유호시작일
- endDate — date — NOT NULL — 유효
- isUsed — boolean — NOT NULL — 사용
- isDelete — boolean — NOT NULL — 삭제
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- userId — character — 유저
- isPeriod — boolean — NOT NULL — 쿠폰
- orderNo — character — 사용
- useStore — character — 사용
- orderKind — character — 주문
- isCancel — boolean — 주문
- couponInfoCouponCode — character — 쿠폰분류코드(POS연계)
coupon_info
- couponCode — character — Primary key — NOT NULL — 쿠폰분류코드(POS연계)
- couponName — character — NOT NULL — 쿠폰명
- couponImage — character — NOT NULL — 쿠폰
- couponDes — text — NOT NULL — 쿠폰
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- constraintStores — text — 매장
- couponType — coupon_info_coupontype_enum — NOT NULL — 쿠폰
- couponValue — integer — NOT NULL — 쿠폰
happiness_manwon
- masterNo — character — Primary key — NOT NULL — 랜덤
- storeCode — character — NOT NULL — 유호시작일
- totalCount — integer — NOT NULL — 남은
- bacode — character — 유효
- bacodePeriodDate — timestamp — NOT NULL — 바코드
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- useCount — integer — NOT NULL — 총
- userId — character — 유저
happiness_manwon_history
- id — integer — Primary key — NOT NULL
- masterNo — character — NOT NULL — 랜덤
- purchasedNo — bigint — NOT NULL — 쿠폰
- prevRemainingQuantity — integer — NOT NULL — 기존
- RemainingQuantity — integer — NOT NULL — 현재
- requestCount — integer — NOT NULL — 사용
- requestItemCodes — text — NOT NULL — 사용
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- historyType — happiness_manwon_history_historytype_enum — NOT NULL — 유호시작일
happiness_manwon_purchase
- id — integer — Primary key — NOT NULL
- maxQuantity — integer — NOT NULL — 최초
- usedQuantity — integer — NOT NULL — 사용수량
- remainingQuantity — integer — NOT NULL — 잔여수량
- periodDate — date — NOT NULL — 만료일
- isPeriod — boolean — NOT NULL — 만료여부
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- masterNo — character — NOT NULL — 랜덤
- extendCount — integer — NOT NULL — 남은
membership
- id — integer — Primary key — NOT NULL
- user — character — NOT NULL — 닉네임
- gradeChangeDate — date — NOT NULL — 이름
- seasenStemp — integer — NOT NULL — 스탬프
- totalStemp — integer — NOT NULL — 스탬프
- stemp — integer — NOT NULL — 스탬프
- isFristL — boolean — NOT NULL
- isFristT — boolean — NOT NULL
- isFristK — boolean — NOT NULL
- email — character — NOT NULL — 이메일
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- grade — membership_grade_enum — NOT NULL
order
- id — integer — Primary key — NOT NULL
- orderNo — character — NOT NULL — 주문
- custermer_id — character — NOT NULL — 주문자
- payMathod — order_paymathod_enum — 결제
- storeCode — character — NOT NULL — 매장
- status — smallint — NOT NULL — 주문상태
- isTakeOut — boolean — NOT NULL — 테이크아웃
- isCarrier — boolean — NOT NULL — 케리어
- isTransferToPos — boolean — NOT NULL — 포스에
- paidAmount — integer — NOT NULL — 최종적으로
- productAmount — integer — NOT NULL — 제품의
- discountPrice — integer — NOT NULL — 할인
- totalPrice — integer — NOT NULL — 제품
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- P_TID — character — 제품
- P_AMT — integer — 결제
- FN_CD — order_fn_cd_enum — 제품
- payDate — character — 제품
- couponNoList — text — 사용
- orderName — character — NOT NULL — 주문
- manwonItemList — text — 사용
order_history
- id — integer — Primary key — NOT NULL
- historyType — character — NOT NULL — 주문
- orderNo — character — NOT NULL — 주문
- custermer_id — character — NOT NULL — 주문자
- payMathod — order_history_paymathod_enum — NOT NULL — 결제
- paidAmount — integer — NOT NULL — 최종적으로
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
order_item
- id — integer — Primary key — NOT NULL
- orderNo — character — NOT NULL — 주문
- quantity — integer — NOT NULL — 주문
- productType — character — NOT NULL — 제품명
- productNameEn — character — NOT NULL — 제품
- unitPrice — integer — NOT NULL — 제품
- sellPrice — integer — NOT NULL — 판매
- isTax — boolean — NOT NULL — 제품
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- productName — character — NOT NULL — 제품명
- discountPrice — integer — NOT NULL — 할인된
order_item_option
- id — integer — Primary key — NOT NULL
- optionCode — character — NOT NULL — 주문
- quantity — integer — NOT NULL — 주문
- unitPrice — integer — NOT NULL — 제품
- sellPrice — integer — NOT NULL — 판매
- isTax — boolean — NOT NULL — 제품
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- orderItemId — integer
- optionName — character — NOT NULL — 제품
- optionNameEn — character — NOT NULL — 제품
- discountPrice — integer — NOT NULL — 할인된
- couponCode — character — 판매
order_pay
- id — integer — Primary key — NOT NULL
- orderNo — character — NOT NULL — 주문
- payMathod — order_pay_paymathod_enum — NOT NULL — 결제
- status — character — 결제
- TID — character — NOT NULL — PG사
- AMT — integer — 결제
- AUTH_DT — character — 요청
- FN_CD — order_pay_fn_cd_enum — 요청
- AUTH_NO — character — 결제
- UNAME — character — 결제자
- RMESG2 — character — 할부기간
- receiptUrl — character — 영수증
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
product
- productCode — character — Primary key — NOT NULL
- productName — character — NOT NULL — 제품명
- productType — character — NOT NULL — 제품명
- productNameEn — character — NOT NULL — 제품
- content — text — NOT NULL — 제품
- price — integer — NOT NULL — 제품
- priceType — character — NOT NULL — 가격
- productImageUrl — character — 메뉴
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- isBest — boolean — NOT NULL — 베스트
- isNew — boolean — NOT NULL — 신메뉴
- isManwon — boolean — NOT NULL — 만원의
- categoryId — integer
product_category
- id — integer — Primary key — NOT NULL
- categoryType — product_category_categorytype_enum — NOT NULL
- categoryCode — character — NOT NULL
- categoryName — character — NOT NULL
- parentId — integer
product_option
- optionCode — character — Primary key — NOT NULL
- optionType — character — NOT NULL — 옵션타입
- optionName — character — NOT NULL — 옵션
- optionNameEn — character — NOT NULL — 제품
- price — integer — NOT NULL — 제품
- priceType — character — NOT NULL — 가격
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- isTax — boolean — NOT NULL — 세금
- categoryId — integer
product_option_category
- id — integer — Primary key — NOT NULL
- categoryType — product_option_category_categorytype_enum — NOT NULL
- categoryCode — character — NOT NULL
- isFree — boolean
- categoryName — character — NOT NULL
- parentId — integer
product_options
- product_code — character — Primary key — NOT NULL
- option_code — character — Primary key — NOT NULL
store
- id — integer — Primary key — NOT NULL
- storeCode — character — NOT NULL — 매장
- areaCode — character — NOT NULL — 지역코드
- ownerName — character — NOT NULL — 대표명
- bizNumber — character — NOT NULL — 사업자번호
- storeName — character — NOT NULL — 매장명
- postCode — character — NOT NULL — 우편
- roadAddress — character — NOT NULL — 도로명
- jibunAddress — character — NOT NULL — 지번
- detailAddress — character — NOT NULL — 이름
- phone — character — NOT NULL — 전화번호
- isOpen — boolean — NOT NULL — 매장
- openDate — timestamp — NOT NULL — 매장
- openTime — character — NOT NULL — 매장
- endTime — character — NOT NULL — 매장
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- storeType — store_storetype_enum — NOT NULL — 가맹
- isCupDeposit — boolean — NOT NULL — 컵
- lat — double — NOT NULL — 위도
- lng — double — NOT NULL — 경도
store_area
- id — integer — Primary key — NOT NULL
- areaCode — character — NOT NULL — 지역
- areaName — character — NOT NULL — 업로드
store_category
- id — integer — Primary key — NOT NULL
- isExpose — boolean — NOT NULL — 공개여부
- serviceName — character — NOT NULL — 타이틀
- content — character — NOT NULL — 설명
- logo — character — NOT NULL — 로고
store_image
- id — integer — Primary key — NOT NULL
- imageUrl — character — NOT NULL — 이미지
- imageName — character — NOT NULL — 업로드
- imageLenght — character — NOT NULL — 이미지
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- storeId — integer
store_menu
- id — integer — Primary key — NOT NULL
- storeCode — character — NOT NULL — 옵션코드
- isCanOrder — boolean — NOT NULL — 주문
- sortNum — integer — NOT NULL — 옵션타입
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- productProductCode — character
- reasonCanNotOrder — store_menu_reasoncannotorder_enum — NOT NULL — 주문
store_new_oepn
- id — integer — Primary key — NOT NULL
- imageUrl — character — NOT NULL — 지역
- storeName — character — NOT NULL — 업로드
- storeCode — character — NOT NULL — 업로드
- linkUrl — character — 업로드
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- openDate — date — NOT NULL — 매장
store_store_category
- store_id — integer — Primary key — NOT NULL
- store_category_id — integer — Primary key — NOT NULL
user
- id — character — Primary key — NOT NULL — 유저
- password — character — 비밀번호
- nickname — character — 닉네임
- name — character — NOT NULL — 이름
- phone — character — NOT NULL — 전화번호
- email — character — NOT NULL — 이메일
- failCount — smallint — NOT NULL — 로그인
- gender — user_gender_enum — NOT NULL
- birth — date — NOT NULL — 생일
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- outDate — timestamp — 탈퇴일자
- lastLogin — timestamp — 마지막
- ipAddress — character
- refreshToken — character — 리프레시
- loginKind — user_loginkind_enum — NOT NULL — 로그인
- profileImage — character — 프로필
- fcmToken — character — 현재
- os — character — 운영체제
- agreeId — integer
user_agree
- id — integer — Primary key — NOT NULL
- isAgreePushAlarmOrder — boolean — NOT NULL
- isAgreePushAlarmEvent — boolean — NOT NULL
- isAgreePushAlarmMembership — boolean — NOT NULL
- isAgreeMarketting — boolean — NOT NULL
- isAgreeAutoLogin — boolean — NOT NULL
user_alarm
- id — integer — Primary key — NOT NULL
- title — character — 제목
- content — character — NOT NULL — 내용
- isChecked — boolean — NOT NULL — 내용
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
- userId — character — 유저
- alarmType — "UserAlarmTypeEnum" — 내용
- forId — character — 페이지
user_favorites_product
- id — integer — Primary key — NOT NULL
- productProductCode — character
- create_at — timestamp — NOT NULL — 생성일
- userId — character — 유저
user_favorites_store
- id — integer — Primary key — NOT NULL
- storeId — integer
- create_at — timestamp — NOT NULL — 생성일
- userId — character — 유저
user_fcms
- user — character — Primary key — NOT NULL
- token — character — 현재
- prevToken — character — 이전
- os — character — 운영체제
- prevOs — character — 운영체제
- create_at — timestamp — NOT NULL — 생성일
- update_at — timestamp — NOT NULL — 수정일
- delete_at — timestamp — 삭제일
user_out_reason
- id — integer — Primary key — NOT NULL
- reasonEtc — character — 유저
- gender — character — 성별
- ageRange — character — 나이대
- joinDate — date — NOT NULL — 유저
- create_at — timestamp — NOT NULL — 생성일
- reason — user_out_reason_reason_enum — NOT NULL — 운영체제