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