ㄹㄹㄹㄹ

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