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