KCD_SERVICE
테이블 (8)
연습 패스 구독 (PROMOTION_PASS_SUBSCRIBE_2)
- PK (id) — 기본 키 — NOT NULL
- (started_date)
- Field (state)
- Field
연습 패스 구독 (PROMOTION_PASS_SUBSCRIBE)
- Key (promotion_pass_subscribe_seq_no) — Int — 기본 키 — NOT NULL
- (promotion_pass_subscribe_id) — String
- (promotion_pass_type_id) — String
- (member_id) — Int
- (promotion_pass_subscribe_status) — Enum
- (promotion_pass_in_subscription) — Boolean
- (promotion_pass_start_date) — LocalDate
- (promotion_pass_end_date) — LocalDate
- (promotion_pass_pay_day) — Int
- (created_at) — LocalDateTime
- (updated_at) — LocalDateTime
- (created_by) — Long
- (updated_by) — Long
연습 패스 타입 (PROMOTION_PASS_TYPE)
- Key (promotion_pass_type_seq_no) — Int — 기본 키 — NOT NULL
- (promotion_pass_type_id) — String
- (promotion_pass_name) — String
- (promotion_pass_in_sale) — Boolean
- (promotion_pass_only_individual) — Boolean
- (promotion_pass_in_subscription) — Boolean
- (promotion_pass_price) — Int
- (created_at) — LocalDateTime
- (updated_at) — LocalDateTime
- (created_by) — Long
- (updated_by) — Long
예약(Booking) (SHOP_BOOKING)
- Key (id) — Int — 기본 키 — NOT NULL
- (user_id) — Int
- Field (shop_id) — Int
- Field (state) — String
- Field (is_paid) — Boolean
- Field (book_type) — String
- Field (hole) — Int
- Field (person) — Int
- Field (game) — Int
- Field (pay_info) — String
- Field (book_date) — LocalDate
- Field (book_time) — LocalTime
쿠폰(LegacyCoupon) (SHOP_DISCOUNTCOUPON)
- Key (id) — Int — 기본 키 — NOT NULL
크레딧 (MEMBER_CREDIT)
- Key (id) — 기본 키 — NOT NULL
- Field (user_id)
- Field (subscribe_id)
- Field
- Field2
- Field3
크레딧 사용 (MEMBER_CREDIT_HISTORY)
- Key (id) — 기본 키 — NOT NULL
- Field (user_id)
- Field (credit)
- Field (type)
패스 구독 로그(PromotionPassSubscribeLog) (PROMOTION_PASS_SUBSCRIBE_LOG)
- Key (promotion_pass_subscribe_seq_no) — Int — 기본 키 — NOT NULL
- (promotion_pass_subscribe_id) — String
- (promotion_pass_type_id) — String
- (member_id) — Int
- (promotion_pass_subscribe_status) — Enum
- (promotion_pass_in_subscription) — Boolean
- (promotion_pass_start_date) — LocalDate
- (promotion_pass_end_date) — LocalDate
- (promotion_pass_pay_day) — Int
- (created_at) — LocalDateTime
- (updated_at) — LocalDateTime
- (created_by) — Long
- (updated_by) — Long