Land-in
Tables (11)
event_participations
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- event_id — VARCHAR(255) — Foreign key → events.id — NOT NULL
- joined_at — DATETIME(6) — NOT NULL
events
- id — VARCHAR(255) — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- city — VARCHAR(255) — NOT NULL
- country — VARCHAR(255) — NOT NULL
- status — VARCHAR(255) — NOT NULL
- featured — BIT — NOT NULL
- start_date — DATE
- end_date — DATE
- description — TEXT
- hero_image_url — VARCHAR(255)
- hero_image_fallback_url — VARCHAR(255)
- map_image_url — VARCHAR(255)
- partner_name — VARCHAR(255)
- partner_logo_url — VARCHAR(255)
- theme_color — VARCHAR(255)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
nfc_scan_logs
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- tag_uid — VARCHAR(255) — NOT NULL
- scanned_at — DATETIME(6) — NOT NULL
- result — VARCHAR(255) — NOT NULL
nfc_tags
- id — CHAR(36) — Primary key — NOT NULL
- step_id — CHAR(36) — Foreign key → steps.id — NOT NULL
- tag_uid — VARCHAR(255) — NOT NULL
- active — BIT — NOT NULL
- created_at — DATETIME(6)
nft_templates
- id — CHAR(36) — Primary key — NOT NULL
- step_id — CHAR(36) — Foreign key → steps.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- rarity — VARCHAR(255) — NOT NULL
- description — TEXT
reward_templates
- id — CHAR(36) — Primary key — NOT NULL
- event_id — VARCHAR(255) — Foreign key → events.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- partner_name — VARCHAR(255) — NOT NULL
- how_to_use — TEXT
- validity_days — INT — NOT NULL
- emoji — VARCHAR(255)
- accent_color — VARCHAR(255)
step_completions
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- step_id — CHAR(36) — Foreign key → steps.id — NOT NULL
- completed_at — DATETIME(6) — NOT NULL
steps
- id — CHAR(36) — Primary key — NOT NULL
- event_id — VARCHAR(255) — Foreign key → events.id — NOT NULL
- order_index — INT — NOT NULL
- place_name — VARCHAR(255) — NOT NULL
- place_description — TEXT
- image_url — VARCHAR(255)
- image_fallback_url — VARCHAR(255)
- lat — DECIMAL(10,7)
- lng — DECIMAL(10,7)
- final_step — BIT — NOT NULL
- created_at — DATETIME(6)
user_nfts
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- step_id — CHAR(36) — Foreign key → steps.id — NOT NULL
- event_id — VARCHAR(255) — Foreign key → events.id — NOT NULL
- nft_template_id — CHAR(36) — Foreign key → nft_templates.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- rarity — VARCHAR(255) — NOT NULL
- minted_at — DATETIME(6) — NOT NULL
- mint_status — VARCHAR(255)
- on_chain_chain_id — BIGINT
- contract_address — VARCHAR(255)
- token_uri — VARCHAR(1024)
- token_id — VARCHAR(128)
- transaction_hash — VARCHAR(128)
- on_chain_minted_at — DATETIME(6)
- mint_failure_reason — VARCHAR(1000)
user_rewards
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- event_id — VARCHAR(255) — Foreign key → events.id — NOT NULL
- reward_template_id — CHAR(36) — Foreign key → reward_templates.id — NOT NULL
- coupon_code — VARCHAR(255) — NOT NULL
- status — VARCHAR(255) — NOT NULL
- issued_at — DATETIME(6) — NOT NULL
- valid_until — DATE — NOT NULL
- used_at — DATETIME(6)
users
- id — CHAR(36) — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- display_name — VARCHAR(255) — NOT NULL
- avatar_url — VARCHAR(255)
- wallet_address — VARCHAR(255)
- wallet_chain_id — BIGINT
- wallet_provider — VARCHAR(255)
- wallet_connected_at — DATETIME(6)
- nft_count — BIGINT — NOT NULL
- landmark_count — BIGINT — NOT NULL
- city_count — BIGINT — NOT NULL
- country_count — BIGINT — NOT NULL
- completed_collection_count — BIGINT — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)