kimcaddie

테이블 (14)

대회 참여용 난수 리스트 (League_Code)

  • idx — Int — 기본 키 — NOT NULL
  • 리그 Idx (league_id) — Varchar(50)
  • 난수 (code) — Varchar(100)
  • 멤버 (member_id) — Varchar(20)
  • 생성일 (created_at) — timestamp(6)
  • 업데이트일 (updated_at) — timestamp(6)

매장 (Tb_shop)

  • 매장 Seq No (shop_seq_no) — 기본 키 — NOT NULL
  • 매장Id (shop_id)

모임 미션 (community_mission)

  • Key (community_mission_seq_no) — bigint — 기본 키 — NOT NULL
  • Field (community_mission_id) — varchar(24)
  • Field (community_id) — varchar(24)
  • Field (community_mission_type_id) — varchar(24)
  • Field (community_mission_current_value) — bigint
  • Field (community_mission_status_cd) — varchar(16)

모임 미션 기록 (community_mission_history)

  • Key (community_mission_history_seq_no) — bigint — 기본 키 — NOT NULL
  • Field (member_id) — int
  • Field (community_id) — varchar(24)
  • Field (community_mission_id) — varchar(24)
  • Field (community_mission_type_id) — varchar(24)
  • Field (external_id) — varchar(24)
  • Field (community_mission_value) — bigint

모임 미션 타입 (community_mission_type)

  • Key (community_mission_type_seq_no) — bigint — 기본 키 — NOT NULL
  • Field (community_mission_type_id) — varchar(24)
  • Field (community_mission_type_cd) — varchar(24)
  • Field (community_mission_name) — varchar(24)
  • Field (community_mission_benefit) — JSON
  • Field (promotion_coupon_basic_type_id) — varchar(24)
  • Field (community_mission_goal_value) — bigint

모임 스케줄 (community_schedule)

  • Key (id) — 기본 키 — NOT NULL
  • Field (schedule_name) — varchar(24)
  • Field (participant_cnt) — Int
  • Field (schedule_started_at) — LocalDateTime
  • 참가비 결제방식 (payment_type) — varchar(24)
  • Field (schedule_description) — varchar(400)
  • 예약 상태 (booking_state) — varchar(8)
  • 그룹장 멤버 (group_leader_id) — int

모임 스케줄 멤버 (community_schedule_member)

  • Key (id) — 기본 키 — NOT NULL
  • Field (community_schedule_id) — varchar(24)
  • Field (member_id) — int

모임 엠블럼 (community_emblem)

  • Key (community_emblem_seq_no) — bigint — 기본 키 — NOT NULL
  • Field (community_emblem_id) — varchar(24)
  • Field (community_id) — varchar(24)
  • Field (community_emblem_info) — JSON

모임 엠블럼 템플릿 (community_emblem_templete)

  • Key (community_emblem_templete_seq_no) — bigint — 기본 키 — NOT NULL
  • Field (community_emblem_templete_type_id) — bigint
  • Field (community_emblem_templete_status_cd) — varchar(24)
  • Field (community_emblem_templete_type_cd) — varchar(24)
  • Field (community_emblem_templete_name) — VARCHAR(8)

모임 회원 (community_member)

  • Key (community_member_seq_no) — bigint — 기본 키 — NOT NULL
  • Field (community_id) — varchar(24)
  • Field (community_member_id) — varchar(24)
  • Field (community_member_status_cd) — varchar(8)
  • Field (member_id) — int
  • Field (community_member_registered_date) — localdate
  • Field (community_member_탈퇴_date) — localdate

모임 회원 내역 (community_member_history)

  • Key (community_member_history_seq_no) — bigint — 기본 키 — NOT NULL
  • Field (community_id) — varchar(24)
  • Field (community_member_id) — varchar(24)
  • Field (community_member_status_cd) — varchar(8)
  • Field (member_id) — int
  • Field (community_member_registered_date) — localdate
  • Field (community_member_탈퇴_date) — localdate

모임정보 (community)

  • Key (community_seq_no) — bigint — 기본 키 — NOT NULL
  • Field (community_status_cd)
  • Field (community_id) — varchar(24)
  • Field (community_name) — varchar(24)
  • Field (community_location_id) — int
  • 가입 방식 (registration_approval) — varchar(8)
  • 가입 질문 (registration_question) — JSON
  • 모임 설명 (description) — TEXT

스크린 골프 토너먼트 (League)

  • seqNo (seq_no) — Int — 기본 키 — NOT NULL
  • 리그 ID (league_id) — Varchar(50)
  • 대회명 (name) — Varchar(100)
  • 대회 주최사 (host_company) — Varchar(100)
  • 대회 운영사 (operating_company) — Varchar(100)
  • 대회 코드 (league_code) — Varchar(50)
  • 대회 시작일 (started_at) — timestamp(6)
  • 대회 종료일 (ended_at) — timestamp(6)
  • 대회 로고 (logo_image) — String
  • 1인당 예산 (budget_per_person) — Int
  • 생성일 (created_at) — timestamp(6)
  • 업데일트일 (updated_at) — timestamp(6)
  • Field

토너먼트 매장 (League_Shop)

  • seqNo (league_shop_seq_no) — Int — 기본 키 — NOT NULL
  • 노출여부 (is_visible) — Boolean
  • 리그 ID (league_id) — Varchar(50)
  • 매장 Seq No (shop_seq_no) — Int
  • 생성일 (created_at) — timestamp(6)
  • 업데이트 (updated_at) — timestamp(6)