LGCNS 2차

테이블 (16)

facility_db_location

  • id — BIGINT — 기본 키 — NOT NULL
  • region — VARCHAR(20) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • facility_name — VARCHAR(100)
  • contact — VARCHAR(100)
  • latitude — DECIMAL(18,15)
  • longitude — DECIMAL(18,15)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

facility_db_service

  • id — BIGINT — 기본 키 — NOT NULL
  • location_id — BIGINT — 외래 키 → facility_db_location.id — NOT NULL
  • service_id — VARCHAR(50) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • status — VARCHAR(20)
  • start_time — TIME
  • end_time — TIME
  • is_free — TINYINT(1)
  • url — VARCHAR(200)
  • reservation_deadline_at — DATETIME
  • active — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

match_db_match

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • description — VARCHAR(500)
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • max_participant — INT — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • skill_level — VARCHAR(30) — NOT NULL
  • sport_type — VARCHAR(15) — NOT NULL
  • gender_group — VARCHAR(10) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • service_id — VARCHAR(50) — NOT NULL
  • target_points — BIGINT

match_db_match_participant

  • match_participant_id — BIGINT — 기본 키 — NOT NULL
  • match_id — BIGINT — 외래 키 → match_db_match.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • user_id — BIGINT — NOT NULL
  • contribution_points — BIGINT

match_db_match_user_state

  • user_id — BIGINT — 기본 키 — NOT NULL
  • withdrawn — TINYINT(1) — NOT NULL

match_db_outbox_event

  • event_id — CHAR(36) — 기본 키 — NOT NULL
  • aggregate_type — VARCHAR(50) — NOT NULL
  • aggregate_id — VARCHAR(64) — NOT NULL
  • event_type — VARCHAR(100) — NOT NULL
  • payload — LONGTEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • retry_count — INT — NOT NULL
  • next_retry_at — DATETIME
  • created_at — TIMESTAMP — NOT NULL
  • published_at — DATETIME

match_db_processed_event

  • consumer_name — VARCHAR(100) — 기본 키 — NOT NULL
  • event_id — CHAR(36) — 기본 키 — NOT NULL
  • processed_at — DATETIME — NOT NULL

match_db_saga_instance

  • id — CHAR(36) — 기본 키 — NOT NULL
  • participant_id — BIGINT — 외래 키 → match_db_match_participant.match_participant_id — NOT NULL
  • request_key — VARCHAR(100) — NOT NULL
  • points — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • current_step — VARCHAR(40) — NOT NULL
  • retry_count — INT — NOT NULL
  • next_retry_at — DATETIME
  • last_error — VARCHAR(1000)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

point_db_point_operation

  • id — CHAR(36) — 기본 키 — NOT NULL
  • wallet_id — BIGINT — 외래 키 → point_db_point_wallet.id — NOT NULL
  • match_id — BIGINT — NOT NULL
  • amount — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

point_db_point_transaction

  • id — BIGINT — 기본 키 — NOT NULL
  • wallet_id — BIGINT — 외래 키 → point_db_point_wallet.id — NOT NULL
  • operation_id — CHAR(36) — 외래 키 → point_db_point_operation.id
  • match_id — BIGINT
  • type — VARCHAR(10) — NOT NULL
  • amount — BIGINT — NOT NULL
  • original_transaction_id — BIGINT — 외래 키 → point_db_point_transaction.id
  • operation_key — VARCHAR(150) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

point_db_point_wallet

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • balance — BIGINT — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_db_outbox_event

  • event_id — CHAR(36) — 기본 키 — NOT NULL
  • aggregate_type — VARCHAR(50) — NOT NULL
  • aggregate_id — VARCHAR(64) — NOT NULL
  • event_type — VARCHAR(100) — NOT NULL
  • payload — LONGTEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • retry_count — INT — NOT NULL
  • next_retry_at — DATETIME
  • created_at — TIMESTAMP — NOT NULL
  • published_at — DATETIME

user_db_processed_event

  • consumer_name — VARCHAR(100) — 기본 키 — NOT NULL
  • event_id — CHAR(36) — 기본 키 — NOT NULL
  • processed_at — DATETIME — NOT NULL

user_db_profile

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user_db_user.id — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • district — VARCHAR(30) — NOT NULL
  • image_url — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_db_sport_preference

  • id — BIGINT — 기본 키 — NOT NULL
  • profile_id — BIGINT — 외래 키 → user_db_profile.id — NOT NULL
  • sport_type — VARCHAR(15) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_db_user

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • withdrawn_at — DATETIME
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL