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