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