eee

Tables (11)

agencies

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • logo_url — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

artists

  • id — BIGINT
  • agency_id — BIGINT — NOT NULL — agencies.id 참조
  • name — VARCHAR(100) — NOT NULL
  • profile_image_url — VARCHAR(255)
  • debut_date — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_artists_agency_id

card_set_items

  • id — BIGINT
  • card_set_id — BIGINT — NOT NULL — card_sets.id 참조
  • card_id — BIGINT — NOT NULL — cards.id 참조
  • INDEX — idx_csi_card_set_id
  • INDEX — idx_csi_card_id

card_sets

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • completion_reward_desc — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

cards

  • id — BIGINT
  • artist_id — BIGINT — NOT NULL — artists.id 참조
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • card_type — ENUM('IMAGE', 'VIDEO') — NOT NULL
  • file_url — VARCHAR(255) — NOT NULL
  • duration_ms — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_cards_artist_id

packs

  • id — BIGINT
  • product_id — BIGINT — NOT NULL — products.id 참조 (1:1 관계)
  • description — TEXT

pool_items

  • id — BIGINT
  • pool_id — BIGINT — NOT NULL — pools.id 참조
  • card_id — BIGINT — NOT NULL — cards.id 참조
  • rarity_tier — ENUM('COMMON', 'RARE', 'EPIC', 'LEGENDARY', 'SPECIAL') — NOT NULL
  • draw_probability — DECIMAL(5, 2) — NOT NULL
  • INDEX — idx_pi_pool_id
  • INDEX — idx_pi_card_id

pools

  • id — BIGINT
  • pack_id — BIGINT — NOT NULL — packs.id 참조 (1:1 관계)
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT

products

  • id — BIGINT
  • product_code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • product_type — ENUM('DIGITAL_PACK', 'PHYSICAL_GOODS') — NOT NULL
  • shipping_fee — DECIMAL(10, 2)
  • is_active — BOOLEAN — NOT NULL
  • sale_start_at — TIMESTAMP
  • sale_end_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_products_sales_period

user_owned_cards

  • id — BIGINT
  • user_id — BIGINT — NOT NULL — users.id 참조
  • card_id — BIGINT — NOT NULL — cards.id 참조
  • obtained_at — TIMESTAMP
  • source_pack_id — BIGINT — packs.id 참조
  • INDEX — idx_uoc_user_id
  • INDEX — idx_uoc_card_id

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP