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