epro2

Tables (19)

badges

  • id — int
  • code — varchar — NOT NULL
  • name — varchar — NOT NULL
  • description — varchar
  • icon_url — varchar
  • condition_type — varchar
  • threshold_value — float
  • created_at — datetime

classification_requests

  • id — int
  • user_id — int — Foreign key → users.id — NOT NULL
  • clothing_item_id — int — Foreign key → clothing_items.id
  • image_url — varchar — NOT NULL
  • status — varchar
  • predicted_grade — varchar
  • predicted_material — varchar
  • predicted_category — varchar
  • processed_at — datetime
  • created_at — datetime

clothing_favorites

  • id — int
  • user_id — int — Foreign key → users.id — NOT NULL
  • clothing_item_id — int — Foreign key → clothing_items.id — NOT NULL
  • created_at — datetime

clothing_images

  • id — int
  • clothing_item_id — int — Foreign key → clothing_items.id — NOT NULL
  • image_url — varchar — NOT NULL
  • is_main — varchar
  • created_at — datetime

clothing_items

  • id — int
  • user_id — int — Foreign key → users.id — NOT NULL
  • name — varchar
  • category — varchar
  • brand — varchar
  • size — varchar
  • color — varchar
  • preference — int
  • detail_desc — varchar
  • material — varchar
  • condition_grade — varchar
  • status — varchar
  • acquired_at — date
  • disposed_at — date
  • disposal_method — varchar
  • purchase_price — float
  • target_price — float
  • created_at — datetime
  • updated_at — datetime

eco_point_transactions

  • id — int
  • user_id — int — Foreign key → users.id — NOT NULL
  • points — int — NOT NULL
  • reason_type — varchar — NOT NULL
  • description — varchar
  • created_at — datetime

email_verification_tokens

  • id — int
  • user_id — int — Foreign key → users.id — NOT NULL
  • token — varchar — NOT NULL
  • expires_at — datetime — NOT NULL
  • used_at — datetime
  • created_at — datetime

material_energy_factors

  • id — int
  • material — varchar — NOT NULL
  • unit — varchar — NOT NULL
  • energy_kwh_per_unit — float
  • water_l_per_unit — float
  • co2_kg_per_unit — float — NOT NULL

oauth_accounts

  • id — int
  • user_id — int — Foreign key → users.id — NOT NULL
  • provider — varchar — NOT NULL
  • provider_user_id — varchar — NOT NULL
  • linked_at — datetime

outfit_items

  • id — int
  • outfit_id — int — Foreign key → outfits.id — NOT NULL
  • clothing_item_id — int — Foreign key → clothing_items.id — NOT NULL
  • role — varchar
  • created_at — datetime

outfits

  • id — int
  • user_id — int — Foreign key → users.id — NOT NULL
  • title — varchar
  • description — varchar
  • source — varchar
  • context_tag — varchar
  • context_weather — varchar
  • created_at — datetime

pickup_requests

  • id — int
  • user_id — int — Foreign key → users.id — NOT NULL
  • clothing_item_id — int — Foreign key → clothing_items.id
  • type — varchar — NOT NULL
  • status — varchar
  • pickup_address — varchar
  • desired_date — date
  • memo — varchar
  • created_at — datetime
  • updated_at — datetime

posts

  • id — int
  • user_id — int — Foreign key → users.id — NOT NULL
  • category — varchar — NOT NULL
  • title — varchar — NOT NULL
  • content — text — NOT NULL
  • view_count — int
  • created_at — datetime
  • updated_at — datetime

profile_image_history

  • hist_id — int
  • user_id — int — Foreign key → users.id — NOT NULL
  • image_path — varchar — NOT NULL
  • uploaded_at — date

recycling_centers

  • id — int
  • name — varchar — NOT NULL
  • type — varchar — NOT NULL
  • address — varchar
  • lat — float
  • lon — float
  • open_hours — varchar
  • phone — varchar
  • homepage_url — varchar
  • created_at — datetime

user_badges

  • id — int
  • user_id — int — Foreign key → users.id — NOT NULL
  • badge_id — int — Foreign key → badges.id — NOT NULL
  • awarded_at — datetime

user_energy_stats_daily

  • id — int
  • user_id — int — Foreign key → users.id — NOT NULL
  • stat_date — date — NOT NULL
  • recycled_kg — float
  • water_saved_l — float
  • co2_saved_kg — float
  • items_count — int
  • created_at — datetime

user_profiles

  • user_id — int — Foreign key → users.id
  • nickname — varchar
  • avatar_url — varchar
  • total_water_saved_l — float
  • total_carbon_saved_kg — float
  • eco_points — int
  • total_collected_kg — float
  • total_clothing_count — int
  • last_login_at — datetime

users

  • id — int
  • login_id — varchar — NOT NULL
  • password — varchar — NOT NULL
  • name — varchar — NOT NULL
  • phone — varchar
  • email — varchar
  • address — varchar
  • birth_date — date
  • role — varchar
  • status — varchar
  • mem_img — varchar
  • created_at — datetime
  • updated_at — datetime