SSAFY_Training
Tables (9)
asset_bundles
- id — UUID
- bundle_key — VARCHAR(100) — NOT NULL
- version — VARCHAR(50) — NOT NULL
- base_url — VARCHAR(500) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
asset_files
- id — UUID
- asset_bundle_id — UUID — Foreign key → asset_bundles.id — NOT NULL
- category — VARCHAR(50) — NOT NULL
- asset_key — VARCHAR(100) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- mime_type — VARCHAR(100)
- file_size — BIGINT
- checksum — VARCHAR(255)
- metadata — JSONB
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
challenge_definitions
- id — UUID
- challenge_code — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- challenge_type — VARCHAR(50) — NOT NULL
- description — TEXT
- reward_money — INT — NOT NULL
- reward_exp — INT — NOT NULL
- reward_payload — JSONB
- is_repeatable — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
item_templates
- id — VARCHAR(100)
- name — VARCHAR(100) — NOT NULL
- short_label — VARCHAR(20) — NOT NULL
- kind — VARCHAR(30) — NOT NULL
- equip_slot — VARCHAR(30)
- price — INT — NOT NULL
- sell_price — INT — NOT NULL
- effect_text — VARCHAR(255)
- stackable — BOOLEAN — NOT NULL
- color_hex — VARCHAR(20)
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
save_files
- id — UUID
- user_id — UUID — Foreign key → users.id — NOT NULL
- slot_no — INT — NOT NULL
- version — INT — NOT NULL
- current_area — VARCHAR(50) — NOT NULL
- current_place — VARCHAR(50) — NOT NULL
- time_label — VARCHAR(50) — NOT NULL
- week — INT — NOT NULL
- day_label — VARCHAR(50) — NOT NULL
- hp — INT — NOT NULL
- hp_max — INT — NOT NULL
- money — INT — NOT NULL
- stress — INT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ
save_inventory_items
- id — UUID
- save_file_id — UUID — Foreign key → save_files.id — NOT NULL
- item_template_id — VARCHAR(100) — Foreign key → item_templates.id — NOT NULL
- slot_index — INT — NOT NULL
- quantity — INT — NOT NULL
- is_equipped — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
user_challenges
- id — UUID
- user_id — UUID — Foreign key → users.id — NOT NULL
- save_file_id — UUID — Foreign key → save_files.id
- challenge_definition_id — UUID — Foreign key → challenge_definitions.id — NOT NULL
- status — VARCHAR(30) — NOT NULL
- progress_value — INT — NOT NULL
- started_at — TIMESTAMPTZ
- completed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
user_progress
- id — UUID
- save_file_id — UUID — Foreign key → save_files.id — NOT NULL
- day — INT — NOT NULL
- week — INT — NOT NULL
- ending_flag — VARCHAR(100)
- coding — INT — NOT NULL
- presentation — INT — NOT NULL
- teamwork — INT — NOT NULL
- luck — INT — NOT NULL
- stress — INT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
users
- id — UUID
- email — VARCHAR(255) — NOT NULL
- phone — VARCHAR(50)
- birthday — DATE
- provider — VARCHAR(50) — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ