ㄹㄹㄹㄹ
Tables (14)
address
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- label — VARCHAR(20)
- normalized_label — VARCHAR(20)
- receiver_name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- zipcode — VARCHAR(10) — NOT NULL
- address1 — VARCHAR(255) — NOT NULL
- address2 — VARCHAR(255)
- memo — VARCHAR(255)
- is_default — TINYINT(1) — NOT NULL
- is_deleted — TINYINT(1) — NOT NULL
- deleted_at — DATETIME
- active_default_owner_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_address_user
- INDEX — idx_address_user_deleted
- INDEX — idx_address_user_deleted_default
entry
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- event_id — BIGINT — NOT NULL
- course_id — BIGINT — NOT NULL
- pace_id — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL — PRE_SAVED | RESERVED | APPLIED | WON | LOST
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
event_image
- id — BIGINT — Primary key — NOT NULL
- event_id — BIGINT — NOT NULL
- type — VARCHAR(20) — NOT NULL — THUMBNAIL | DETAIL
- url — VARCHAR(500) — NOT NULL
- sort — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
event_item_option
- id — BIGINT — Primary key — NOT NULL
- item_id — BIGINT — NOT NULL
- option — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
event_package
- id — BIGINT — Primary key — NOT NULL
- event_id — BIGINT — NOT NULL
- item_id — BIGINT — NOT NULL
- item_type — VARCHAR(20) — NOT NULL — BASIC | ADDITIONAL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
event_sales_info
- id — BIGINT — Primary key — NOT NULL
- event_id — BIGINT — NOT NULL
- is_refundable — TINYINT(1) — NOT NULL
- is_transferable — TINYINT(1) — NOT NULL
- refund_start_at — DATETIME
- refund_end_at — DATETIME
- non_refundable_at — DATETIME
- cancellation_fee — VARCHAR(255)
- refund_policy — TEXT
- weather_refund — TEXT
- delivery_target — VARCHAR(100)
- delivery_method — VARCHAR(50)
- delivery_start_at — DATETIME
- delivery_end_at — DATETIME
- delivery_fee — VARCHAR(50)
- delivery_area — VARCHAR(200)
- delivery_info — VARCHAR(200)
- address_change_period — DATETIME
- delivery_compensation — VARCHAR(500)
- seller_name — VARCHAR(100)
- business_no — VARCHAR(20)
- ecommerce_no — VARCHAR(50)
- is_ecommerce_mediator — TINYINT(1) — NOT NULL
- customer_service — VARCHAR(50)
- seller_address — VARCHAR(200)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
event_stock
- id — BIGINT — Primary key — NOT NULL
- event_pace_id — BIGINT — NOT NULL
- total_stock — INT — NOT NULL
- confirmed_stock — INT — NOT NULL
- version — BIGINT — 낙관적 잠금용 버전
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
login_histories
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT
- login_ip — VARCHAR(45)
- login_agent — VARCHAR(512)
- login_method — VARCHAR(20) — NOT NULL — EMAIL | SNS
- auth_provider — VARCHAR(20) — NOT NULL — LOCAL | KAKAO | NAVER
- is_success — TINYINT(1) — NOT NULL
- fail_reason — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
media_objects
- id — BIGINT — Primary key — NOT NULL
- owner_id — BIGINT — NOT NULL
- object_key — VARCHAR(512) — NOT NULL
- content_type — VARCHAR(100) — NOT NULL
- media_status — VARCHAR(20) — PRESIGNED | UPLOADED | DELETED
- expires_at — DATETIME — NOT NULL
- confirmed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_media_status_expires — '미디어 오브젝트 (S3 파
members
- id — BIGINT — Primary key — NOT NULL — auth 모듈 users.id와 동일 (자동생성 아님)
- is_deleted — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
order_package
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — NOT NULL
- event_item_id — BIGINT — NOT NULL
- price — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
orders
- id — BIGINT — Primary key — NOT NULL
- order_number — VARCHAR(255) — NOT NULL
- user_id — BIGINT — NOT NULL
- event_course_id — BIGINT — NOT NULL
- event_pace_id — BIGINT
- entry_id — BIGINT
- event_id — BIGINT
- event_title — VARCHAR(50)
- event_app_type — VARCHAR(20) — LOTTERY | FIRST_COME
- event_status — VARCHAR(30) — CLOSING_SOON | IN_PROGRESS | READY | END | DRAW_COMPLETED
- event_at — DATETIME
- event_venue — VARCHAR(255)
- course_name — VARCHAR(50)
- pace_name — VARCHAR(50)
- order_status — VARCHAR(20) — NOT NULL — PENDING | PAID | CANCELLED | EXPIRED | FAILED
- item_total_amount — BIGINT — NOT NULL
- shipping_fee — BIGINT — NOT NULL
- discount_amount — BIGINT — NOT NULL
- final_amount — BIGINT — NOT NULL
- recipient_name — VARCHAR(50) — NOT NULL
- address_label — VARCHAR(20)
- recipient_phone — VARCHAR(20) — NOT NULL
- zip_code — VARCHAR(10) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- detail_address — VARCHAR(200)
- delivery_memo — VARCHAR(200)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
payments
- id — BIGINT — Primary key — NOT NULL
- payment_key — VARCHAR(200)
- order_number — VARCHAR(100) — NOT NULL
- amount — BIGINT — NOT NULL
- method — VARCHAR(50)
- status — VARCHAR(30) — NOT NULL — READY | IN_PROGRESS | WAITING_FOR_DEPOSIT | DONE | CANCELED | PARTIAL_CANCELED | ABORTED | EXPIRED
- member_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- name — VARCHAR(50)
- gender — VARCHAR(10) — MALE | FEMALE
- birthdate — DATE
- phone_number — VARCHAR(20)
- mobile — VARCHAR(20)
- password — VARCHAR(255)
- auth_provider — VARCHAR(20) — NOT NULL — LOCAL | KAKAO | NAVER
- provider_id — VARCHAR(100)
- role — VARCHAR(20) — NOT NULL — USER
- status — VARCHAR(20) — NOT NULL — ACTIVE | INACTIVE
- verification_status — VARCHAR(20) — NOT NULL — UNVERIFIED | VERIFIED
- marketing_consent — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL